How to pass parameters to procedures?
No Answer is Posted For this Question
Be the First to Post Answer
How to sort the query output in oracle?
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
what is normalisation?what are its uses?
What is the sid in oracle?
What are the parameters that we can pass through a stored procedure?
What is a read write transaction in oracle?
How to check database size in Oracle?
How to Truncate Table in Oracle
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
> 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 a collation and state the different types of collation sensitivity?
can you write commit in triggers?