Answer Posted / ramesh

create table emp(sal number(5,2);

How to define a specific record type?

1084

---

How to load data through external tables?

1135

---

Difference between oracle's plus (+) notation and ansi join notation?

1101

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1146

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

---

What is truncate oracle?

971

---

What is max rowid in oracle?

1025

---

What is snapshot is too old? Give and example for better understand.

1603

---

Explain about achiever in sql?

1035

---

What is save point in oracle database?

1296

---

List the various oracle database objects?

1057

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2467

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1082

---

What is oracle data type?

963

---