How to run the anonymous block again?

1132

Difference between the “verify” and “feedback” command?

1363

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2149

What are the uses of a database trigger?

994

How to insert multiple rows with one insert statement in oracle?

1086

Explain overloading. Can functions be overloaded?

986

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1383

Can we insert data in view oracle?

1035

How to define default values for formal parameters?

1044

What is data type in oracle?

1125

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

1949

What is an index associated with a constraint?

1040

How to delete a column in an existing table?

1076

Please explain joins in oracle?

1062

Give the various rollback segment states.

1052