Difference between sub query and nested query ?

Answer Posted / chiyan

Hi all, i go wth RK....plz dnt mislead others...best example
is me for dat case......i jst told the answer what i read
frm one another person !!!!!!!!!!The interviewer jst sacked
me out of the panel...so jst dnt laugh but think guys nd
gals.......

Is This Answer Correct ?    21 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the simplest tool to run commands on oracle servers?

516


How to grant create session privilege to a user in oracle?

571


What is a relational database management system?

677


Explain the use of inctype option in exp command.

594


How many types of tables are there in oracle?

576






How do we create privileges in oracle?

588


What is oracle data type?

555


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1436


> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

1569


How to convert characters to numbers in oracle?

596


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

613


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

1963


What are the uses of a database trigger?

516


Can objects of the same schema reside in different tablespace?

585


How to loop through a cursor variable?

568