Explain self joins in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
how to get last monday of a month?
What is the data pump import utility?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Without giving condition how to retrieve the unmatched records from table.
Please explain oracle left join with an example?
can a table has a column that has only view data and in other columns we can change data?
What is SAVE POINT ?
> 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 TNS File
Explain the different normalization forms?
How to use "if" statements on multiple conditions?
The join defined by the default data link is an outer join yes or no ?