Briefly explain what is literal? Give an example where it can be used?
No Answer is Posted For this Question
Be the First to Post Answer
What are the execution control statements?
what is the dual table in oracle?
How would you extract DDL of a table without using a GUI tool?
What is an Oracle index?
Is the After report trigger fired if the report execution fails ?
What is background process in Oracle?
Find all employees in Dept “Marketing”.
Explain the use of record option in exp command.
> 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 index?
how may join possible between (requisition with purchase order)
how to create a new database in oracle?