Interested to Buy Any Domain ? << Click Here >> for more details...
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
2 45941:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
1 4897I 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.
32791.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
6 8278We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
IBM,
2 7061Post New Oracle General Questions
How many file formats are supported to export data?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
> 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 THE DEFINITION OF DEFAULT CUSTOMER IN AR?
please explain.. DB architecture ...
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to get a list of all user accounts in the database?
What is partitioned table in Oracle?
What are the types of partitions in oracle?
6. Display the client name and order date for all orders using the traditional method.
How do I connect to oracle?
What is a dead lock in oracle?
What happens to the current transaction if the session is killed?
How to define a data field as not null?
What is instant client oracle?
