Answer Posted / kumar
Transaction ends with COMMIT or ROLLBACK keywords.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain what are the uses of rollback segment?
How to create a stored program unit?
Explain what are the different type of segments?
How to use like conditions in oracle?
Explain an index?
How to insert a new row into a table in oracle?
How to convert characters to dates in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
how to make an oracle object
How can I create database in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to create a table in a specific tablespace?
Differentiate between post-database commit and post-form commit?
Explain enable novalidate constraint.
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.