Difference between lexical and bind varible.

1

Tell me about standby database? What are some of the configurations of it?

568

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2322

How can we use tkprof?

1

What is a sub query? What are its various types?

1179

What is Sequences?

630

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2071

1. What is PO rate variance gain and loss?

2920

Explain about your project and its relation to the current job position you are applying to?

1006

Can you remove an open file under unix?

694

How to define Data Block size in Oracle?

1111

What is the difference between pre-select and pre-query?

1219

How many types of v variables'? Where will appear for variables in odi?

574

Is truncate autocommit in oracle?

1087