Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is an oracle stored procedure?
What is difference between stored procedures and application procedures?
How to order siblings in oracle hierarchy queries?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How to know the last executed procedure?
What is difference between stored function and application function?
How can a function retun more than one value in oracle with proper example?
In a distributed database system, can we execute two queries simultaneously?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is a database trigger?
What are types of exception?
Explian rowid, rownum?
What are % type and % rowtype?