What are the various oracle database objects?

1138

candidate key is subset of super key but not vice-verse explain

2064

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.

3322

What are group functions in oracle?

1035

How to do paging with oracle?

991

Explain how are indexes update?

1060

What is a nested table and how is it different from a normal table?

1044

Difference between cartesian join and cross join?

1031

Explain the use of compress option in exp command.

1015

What is the use of file param in imp command?

1159

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'));

1686

What do database buffers contain?

1021

Can we call procedure inside function in oracle?

1074

What is the difference between substr and instr?

1034

How to assign values to data fields in record variables?

1029