What is difference b/w stored procedures and application procedures, stored function and application function?
Explian rowid, rownum?what are the psoducolumns we have?
what is the starting oracle error number?
what is meant by forward declaration in functions?
In a Distributed Database System Can we execute two queries simultaneously? Justify?
How we can create a table in PL/SQL block. insert records into it? is it possible by some procedure or function? please give example?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
State the difference between implict and explict cursors?
How to know the last executed procedure?
How can a function retun more than one value in oracle with proper example?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?