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 37701:-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 4185I 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.
28641.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 6832We 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 6031Post New Oracle General Questions
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What are the execution control statements?
How to get execution path reports on query statements?
How do I find the database name in oracle?
What is tns entry?
What is catalog in Oracle?
How can we find out the current date and time in oracle?
What is a trigger oracle?
What is a view and how is it different from a table?
What is a user role in oracle?
how may join possible between (requisition with purchase order)
What privilege is needed for a user to delete rows from tables in another schema?
What is the fastest query method to fetch data from the table?
What is proxy method?
Whats the benefit of dbms_stats over analyze?