hi friends,
I have a table A
col as
status|NUM
and value as
open |1
open |2
close |3
close |3
the O/P should be
open|close
1 |3
2 |4
- 1 Answers
- 4188 Views
- CTS, I also Faced
- E-Mail Answers
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
Describe the types of sub query?
How are Indexes Update ?
How does one get the view definition of fixed views/tables?
sql query to get zero records from a table
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to synchronize 2 schema's objects?
What to do if dba lost the system password?
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 a view?
When do I need to use a semicolon vs a slash in oracle sql?
What is Read-Only Transaction ?
Oracle General 
