Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kamala k n
+ will give matching rows from table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is a Nested Loop join?
How to write date and time literals in oracle?
What are the restrictions in a oracle read only transaction?
What privilege is needed for a user to delete rows from tables in another schema?
What is snapshot is too old? Give and example for better understand.
What is oracle used for?
What is difference between truncate and delete?
How to call a stored function in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
Explain an index segment?
What is tns service name?
What is a cognitive schema?
> 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?
State some uses of redo log files?
What is an oracle user role?
