Explain what are the characteristics of data files?
No Answer is Posted For this Question
Be the First to Post Answer
What happens if you set the sga too low in oracle?
> 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?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
what diffrence between function and procedure?
what is the uses of cusor
How to get maxsal , minsal, ename department wise in single query
What is the fastest query method to fetch data from the table?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is oracle database 10g express edition?
Briefly explain what is literal? Give an example where it can be used?
How to define and use table alias names in oracle?
Explain mutating triggers.