CASE STUDIES OF CAPITAL BUDGETING

SQL> select * 2 from area64;

ARNO ARNAME ARTYP
---------- -------------------- ----- 1 Mumbai Urban 2 Paud Rural 3 Pune Urban

SQL> select * 2 from ppl64;

PNO PNAME DOB INCOME ARNO
---------- -------------------- --------- ---------- ---------- 1 Nikhil 10-AUG-91 150000 3 2 Suyoga 18-OCT-95 200000 2 3 Paddy 07-MAR-91 250000 1 4 Siddhi 28-FEB-95 100000 2 5 Manasi 15-APR-95 250000 3

SQL> select pname 2 from ppl64,area64 3 where(ppl64.arno=area64.arno)and(artyp='Urban'); where(ppl64.arno=area64.arno)and(artyp='Urban') *
ERROR at line 3:
ORA-00904: "ARTYP": invalid identifier

SQL> select pname 2 from area64,ppl64 3 where (area64.arno=ppl64.arno)and(artype='Urban');

PNAME
--------------------
Paddy
Manasi
Nikhil

SQL> select pno,pname,dob,income,arno 2 select pno,pname,dob,income,arno 3
SQL> select pno,pname,dob,income,ppl64.arno 2 from area64,ppl64 3 where(area64.arno=ppl64.arno)and(pname like 'M%');

PNO PNAME DOB INCOME ARNO
---------- -------------------- --------- ---------- ---------- 5 Manasi 15-APR-95 250000 3

SQL> select max(income) 2 from ppl64 3 where select *; where select * *
ERROR at line 3:
ORA-00936: missing expression

SQL> select max(income) 2 from ppl64 3 where(select *); where(select *) *
ERROR at line 3:
ORA-00936: missing expression

SQL> select * 2 from ppl64 3 where (select max(income); where (select max(income) *
ERROR at line 3:
ORA-00936: missing expression

SQL> select *