What are temporal data types in oracle?

1066

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

1618

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3155

what is meant by magic query

2137

How to rename an existing table?

1052

How to create an oracle testing table?

1010

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2211

What is Undo Management Advisor in Oracle?

1042

Can we commit inside a function in oracle?

920

What is bind variable in oracle 11g?

995

Explain cascading triggers.

1013

How to run create database statement?

979

Why do you create or replace procedures rather that drop and recreate.

948

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2506

How do I reset a sequence in oracle?

1053