What is the best way to do multi-row insert in oracle?

753

How to use group functions in the select clause using oracle?

767

How can I create database in oracle?

722

Can we create database in oracle using command line ?

750

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'));

1383

How to convert a string to a date in oracle database?

741

How do you find current date and time in oracle?

749

How to use null as conditions in oracle?

724

What is PL/SQL ?

1312

Why does Oracle not permit the use of PCTUSED with indexes?

2115

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

747

How do you tell what your machine name is and what is its IP address?

1700

What are the uses of a database trigger?

662

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1785

How to define an anonymous procedure with variables?

711