Latest Answer: Depends on when you commit the changes. If u are processing like above (in a for loop) you should commit post processing, after the cursor is closed. But that's often not useful on huge amount of data. any commited transactions to cursor data while the ...
Latest Answer: implicit ,explicit,ref cursor ...
Latest Answer: There are 3 types of joins basis on Oracle 8i
Simple join
     1. Equi join : Equi join is one which contains comparision operator '=' in where clause.
     2. Non Equi join: If the comparision operator in the join condition is other than ...
Latest Answer: contents or data of the table can be sorted by using clause ORDER BY in SELECT statement.By default the table is in ASCENDING order.SYN: SELECT * from [table name] where [condition] ORDER ...
Latest Answer: DDL is Data Definition Language.DDL-Create, Alter, Drop.DML is a Data Manipulation Language.DML-Insert, Update, Delete. ...
Latest Answer: send me questions about databases and certifications tools of databases oracle sqlserver please ...
Latest Answer: USING COMMENT LINES WITH (+) SIGN YOU CAN PASS THE HINTS TO SQL ENGINE----------->/* +PARALLEL() */ ...
Latest Answer: exceptions can be handled in various ways in the stored procedures. Method (1) could be using EXCEPTION block in the procedure within which use WHEN THEN. Method (2) could be declare a variable in DECLARE section as EXCEPTION type, ...
View page << Previous 2 3 4 5 [6]
Go Top
