Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / harsha vardhan reddy
SAVEPOINT is used to locate the transaction for further
manipulations.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to write numeric literals in oracle?
What are a query and state the different types of queries and their uses?
Explain implicit cursor.
what is difference between sql plus and sql*plus? (not sql and sql plus).
> 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?
What happens in oracle commit?
What privilege is needed for a user to connect to oracle server?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
how to join query for one source type is oracle another source type is sql server ?
Compare and contrast between sql and sql server and explain its various functions?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to test null values?
How to create a stored program unit?
When do you get a .pll extension in oracle? Explain its importance
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
