What is the recommended interval at which to run statspack
snapshots, and why?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between substr and instr?
How can we find the size of a database?
Differentiate between TRUNCATE and DELETE?
> 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?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
Respected sir, Please send me technical questions related to oracle apps..
what happened to the global index when I truncate the data in one of the partition?
What happens in oracle commit?
List out the difference between commit, rollback, and savepoint?
How to define an oracle sub procedure?
What is the difference between normal and corelated subqueries?
What are a cluster and non-cluster index?