What is bind variable in oracle 11g?
No Answer is Posted For this Question
Be the First to Post Answer
6. Display the client name and order date for all orders using the traditional method.
How to do clean up if create database failed?
How remove data files before opening a database?
> 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 are the most common interview questions on ETL Testing for experience?
How to export your own schema?
Can we write dml statement in function in oracle?
How can we find the size of a database?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the function of Redo Log ?
How can I see all tables in oracle?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?