How to create id with auto_increment on oracle?
what is null value?
What is partitioned table in Oracle?
After update how do u know how many records got updated
what is data independence exactly? give an example
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 create a stored procedure in oracle?
How does oracle handle read consistency?
Explain the use of analyse option in exp command.
does the query needs a hint to access a materialized view?
Explain an index segment?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How to fetch the row which has the max value for a column?