Un-Answered Questions { SQL PLSQL }

Mention what does plv msg allows you to do?

866


Mention what is the use of function "module procedure" in pl/sql?

796


Why plvtab is considered as the easiest way to access the pl/sql table?

850


Mention what problem one might face while writing log information to a data-base table in pl/sql?

879


Mention what plvcmt and plvrb does in pl/sql?

846


What are aggregate and scalar functions?

732


What is user defined functions?

750


How to select unique records from a table?

780


What are tables and fields?

771


Advantages and disadvantages of stored procedure?

817


What is the command used to fetch first 5 characters of the string?

1109


What is the difference between cluster and non-cluster index?

820


What is online transaction processing (oltp)?

755


How can you create an empty table from an existing table?

805


What is clause?

802