What is a sub query and what are the different types of subqueries?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what are the type of synonyms?
Explain an exception and its types?
What is an oracle user account?
Give the various exception types.
List the parts of a database trigger.
> 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?
How to view the tablespaces in the current database?
How many types of database triggers exist?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is blob datatype?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,