How to convert raw data type into text in oracle? Explain
No Answer is Posted For this Question
Be the First to Post Answer
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
How to select some rows from a table in oracle?
How to write a query with a left outer join in oracle?
How to use "for" statements in oracle?
What is an Oracle index?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
How to create a stored procedure in oracle?
Which is better Oracle or MS SQL? Why?
> 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?
Does oracle charge for java?
How to start your 10g xe server?