Answer Posted / chandiran
select <column name> from <table name>
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to define an anonymous block?
What is memory advisor in Oracle?
What is concurrency in oracle?
What is a schema in oracle?
material view and view disadvantages?
Explain mutating triggers.
definition of cluster and non-clustered index?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
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'));
How to write a left outer join with the where clause in oracle?
What are ddl statements in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to drop an index in oracle?
How to estimate disk space needed for an export job?
How to rollback the current transaction in oracle?