Explain the structure of pl/sql in brief.
No Answer is Posted For this Question
Be the First to Post Answer
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
How do we use distinct statement? What is its use?
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?
Why do we use procedures in pl sql?
wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure
What is the difference between union and union all command?
what does it mean to have quoted_identifier on? : Sql dba
What is the use of triggers?
What is cold data?
Types of indexes. What is the default key created when a primary key is created in a table ?
Explain foreign key in sql?
What is pls_integer in pl sql?