Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete an existing row from a table in oracle?
- 0 Answers
- 1129 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the order of defining local variables and sub procedures/functions?
can any one help me with import/export options in oracle............
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
What is the difference between Outer join and Full outer join?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
How to delete all rows a table in oracle?
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
How to assign query results to variables?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
> 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?
Can the query output be sorted by multiple columns in oracle?
Oracle General 
