What is using clause and give example?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between dbms and rdbms?
Give the various rollback segment states.
What is the difference between PFILE and SPFILE in Oracle?
what are corelated subqueries
> 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 we Update a table with out using UPDATE command?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What suggestions do you have to reduce the network traffic?
Explain the use of parfile option in exp command.
How many types of table in Oracle?
State and explain about oracle instance?
what is the syntax of SELECT command?