src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1450

What is a data lock in oracle?

818

What is concurrency in oracle?

772

What is the difference between "as" and "is" in an oracle stored procedure?

766

How to drop an existing table in oracle?

828

What are the different types of database objects?

758

How is it different from a normal table?

798

How do you store pictures in a database?

762

How would you go about verifying the network name that the local_listener is currently using?

1830

How to export your own schema?

777

How to calculate date and time differences in oracle?

784

How to write a left outer join with the where clause in oracle?

851

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2028

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2004

Is it possible to split the print reviewer into more than one region ?

2041