How to define a procedure inside another procedure?

1024

What are the differences between primary key and unique key?

1010

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 do I find the database name in oracle?

1037

How to convert character types to numeric types?

1132

How to load excel data sheet to oracle database

1024

How many types of auditing in Oracle?

1035

What is an oracle wallet?

942

How to turn on or off recycle bin for the session?

1109

Is rowid unique in oracle?

998

How to find the duplicate rows count from employees table in oracle?

1090

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1933

What is the sid in oracle?

964

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2310

How do I spool to a csv formatted file using sqlplus?

1033