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 *
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 *