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 35191:-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 3982I 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.
27461.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 6319We 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 5635Post New Oracle General Questions
How do I reset a sequence in oracle?
How to concatenate two text values in oracle?
How much memory your 10g xe server is using?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
State some uses of redo log files?
What is the data pump export utility?
How to create an initialization parameter file?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain parameter file in oracle.
How to create a stored function in oracle?
What are transaction isolation levels supported by oracle?
What is a sub query and what are the different types of subqueries?
How to empty your oracle recycle bin?
How to recover a dropped table in oracle?
What is difference between cartesian join and cross join?