Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18610 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / swati gupta
it is delete...........
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to get maxsal , minsal, ename department wise in single query
> 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 PL/SQL ?
What is oracle latest version?
what are archived logs?
How to use "out" parameter properly?
How to concatenate two text values in oracle?
Why do we need oracle client?
How do I start tns listener?
How to use select statement to count the number of rows in oracle?
Is oracle the best database?
What are the differences between date and timestamp in oracle?
How to create a temporary table in oracle?
What is oracle rownum?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
