What is a view and how is it different from a table?
- 0 Answers
- 564 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How can you use check constraints for self referential integrity?
> 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?
Explain an exception?
What are the different types of modules in oracle forms?
Can you assign multiple query result rows to a variable?
How to get a list of all user accounts in the database?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is the parameter mode that can be passed to a procedure?
What suggestions do you have to reduce the network traffic?
Explain alias?
Oracle General 
