How to get a list of all background sessions in the database?

576

what is port in oracle? how is it related to database application.

1466

What is the difference between translate and replace in oracle?

696

How to create an initialization parameter file?

567

What do you understand by a database object?

630

Can we commit inside a function in oracle?

592

How to upsert (update or insert into a table)?

565

Write a syntax for update query in oracle?

648

 How to use an oracle sequence generator in a mapping?

597

Explain the features of oracle?

636

What are the restrictions in a oracle read only transaction?

599

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

1879

Whats the benefit of dbms_stats over analyze?

1526

Explain what are the different type of segments?

612

What is primefaces used for?

592