What is difference between joins and union?
No Answer is Posted For this Question
Be the First to Post Answer
Can a composite key be null?
What program will open a mdb file?
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????
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
select 10 from dual; y its showing all the rows with 10?
what is sql server agent? : Sql dba
how tsql statements can be written and submitted to the database engine? : Transact sql
What are the datatypes a available in PL/SQL ?
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?
What is parallel hint?
What is nested table in pl sql?
What are the string functions in sql?