What is ordinary table in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between simple view and complex view?
Explain oracle 12c new features for developers?
State the various uses of dbcc command?
How to select some rows from a table in oracle?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
Explain how you would restore a database using RMAN to Point in Time?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
> 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 is literal?
What are the advantages of oracle?
what is the difference between substr and instr function in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?