How to use "in" parameter properly?
No Answer is Posted For this Question
Be the First to Post Answer
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
What are the differences between lov and list item?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
> 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?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
what is a cartition product?
What is different types of joins?
Can we save images in a database and if yes, how?
What is a user role in oracle?
What happens to the current transaction if the session is ended?
What is varray?
What is java oracle used for?