What is using clause and give 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 find the duplicate rows count from employees table in oracle?
What is hash cluster in oracle?
Explain table?
what is difference between cartesian join & cross join even they give same result?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to export data to a csv file?
defination of bitmap index
What are the different types of trigger and explain its various uses and functions?
Please explain oracle left join with an example?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Explain what are the uses of rollback segment?