Can we use views in stored procedure?


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

Post New Answer

More SQL PLSQL Interview Questions

Differentiate between % rowtype and type record.

0 Answers  


Are pl sql variables case sensitive?

0 Answers  


How many scalar data types are supported in pl/sql?

0 Answers  


Why do we use procedures in sql?

0 Answers  


What normalization means?

0 Answers  






how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 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?

4 Answers   KPIT,


What is the difference between microsoft sql and mysql?

0 Answers  


What is rule base and cost base optimizer?

2 Answers   Thermotech,


what is uncommittable transactions? : Transact sql

0 Answers  


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.

9 Answers   Oracle,


What is pl sql collection?

0 Answers  


Categories