How to write a left outer join with the where clause in oracle?
- 0 Answers
- 827 Views
- I also Faced
- E-Mail Answers
i want department wise maxmum salary and empolyee name
How to load data through external tables?
when i run my query on yesterday it is fast but today it is slow why?
What is the difference between "as" and "is" in an oracle stored procedure?
How to rename an existing table?
What is index-organized table in Oracle?
What is system global area (sga) in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What are the attributes that are found in a cursor?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
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
How to calculate date and time differences in oracle?
Oracle General 
