Can we use views in stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
Differentiate between % rowtype and type record.
Are pl sql variables case sensitive?
How many scalar data types are supported in pl/sql?
Why do we use procedures in sql?
What normalization means?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
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 the difference between microsoft sql and mysql?
What is rule base and cost base optimizer?
what is uncommittable transactions? : Transact sql
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
What is pl sql collection?