What is archive log in Oracle?
How to rename an index in oracle?
what is the use of system.effective.date variable in oracle?
What is the maximum number of triggers that can be applied to a single table?
how do u setup a replication site?
How would you optimize a slow SQL query?
How can I see all tables in oracle?
How to load data from external tables to regular tables?
What is raw datatype?
how to clone 9i Database on to 10g Database.
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'));
12 RULES OF RDBMS
when i run my query on yesterday it is fast but today it is slow why?