Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sikdar
Commit is a TCL command which is used to make database
transaction parmanent.
The data is commited but it can't be rollbacked.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
> 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 can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to write text literals in oracle?
What is the relationship among database, tablespace and data file?
What are privileges and grants?
What happens if you lost a data file?
How to synchronize 2 schema's objects?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is an oracle wallet?
How many types of tables are there in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to rename an index in oracle?
Can we create trigger on materialized view in oracle?
How to use values from other tables in update statements using oracle?
What do you mean by group by clause?
