What is a connect identifier?

988

How to define an oracle cursor variable?

980

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2214

How to open and close an explicit cursor in oracle?

1008

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1944

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)

2266

Difference between hot backup vs. Cold backup?

952

Explain coalesce function?

1129

Explain an exception and its types?

1024

What do you understand by database schema and what does it hold?

1185

How do I limit the number of oracle database connections generated by weblogic server?

1012

What is the database name in oracle?

975

How can we force the database to use the user specified rollback segment?

1079

What are the system predefined user roles?

987

Explain the importance of .pll extension in oracle?

958