How many parts of a pl sql block are optional?


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

Post New Answer

More SQL PLSQL Interview Questions

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  


What information is needed to connect sql*plus an oracle server?

0 Answers  


What is auto increment?

0 Answers  


How many triggers can be applied on a table?

0 Answers  


What is data profiling in sql?

0 Answers  






What is nosql vs sql?

0 Answers  


What is on delete restrict?

0 Answers  


how to retrieve the top 3 salaries of the table using rownum

31 Answers   Oracle,


What is left join in postgresql?

0 Answers  


What is pessimistic concurrency control? : Transact sql

0 Answers  


Which is faster subquery or join?

0 Answers  


Explain character-manipulation functions?

0 Answers  


Categories