What is difference between joins and union?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Can a composite key be null?

0 Answers  


What program will open a mdb file?

0 Answers  


I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,


I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,


select 10 from dual; y its showing all the rows with 10?

1 Answers  






what is sql server agent? : Sql dba

0 Answers  


how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  


What are the datatypes a available in PL/SQL ?

2 Answers  


Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  


What is parallel hint?

0 Answers  


What is nested table in pl sql?

0 Answers  


What are the string functions in sql?

0 Answers  


Categories