Explain share and exclusive type of lock.
How to select multiple data from different tables which do not have related constraints?
What is recreating and rebuiding of indexes?
What are the uses of Cursor?
What are its advantage and disadvantage?
Latest Answer: Disadvantages:Using implicit/explicit cursors are depended by Situation. If the result set is less than 50 or 100 records it is better to go for implicit cursors. if the result set is large then you should use explicit cursors. other wise it will put ...
How to call a Procedure in Trigger and if any exception occurs in trigger then How do we rollback it?
How to access cursor output from web application and present the record set in tabular form?
What are all the different ways available to find the null value in a table
Latest Answer: NULL values are not using any assignment operator, So you need to compare them IS NULL e.g.Select * from emp where comm is NULL; ...
How to call SQL script file from PL/SQL?
Latest Answer: @[source drive]/filename.sql;@c:/sql_script.sql ...
When we insert new values into the table using loops. Is it going to be auto commit or do we need to commit manually?
Latest Answer: All the DML statement requires manual commit where as DDL statements are autocommitted. ...
What are Composite Variable?
Latest Answer: I assume that it should be composite data type not composite variables.Well there are two types of data types in Oracle PlSQL.Primitive datatyes: are simple datatypes which help to store simple data like integer, number, char, date etcEx: number, varchar, ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
