State and explain about oracle instance?
No Answer is Posted For this Question
Be the First to Post Answer
What is translate in oracle?
What are the set operators union, union all, minus & intersect meant to do?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to call a stored function with parameters?
7. Repeat query (7) but also display all clients who have never ordered anything.
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
Whats the benefit of dbms_stats over analyze?
> 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 does Oracle guarantee data integrity of data changes?
what is null value?
can u plz provide me oca sql dumps please i need them