Answer Posted / subba rao

INSERT COMMAND CAN BE USED IN TWO WAYS

1.TO INSERT ALL VALUES INTO TABLE : VALUES INSERT INTO
<TABLE NAME> VALUES
(<COL_VALUE1>,<COL_VALUE2>...<COL_VALUEN>)

2.TO INSERT INTO SPECIFIED VALUES : INSERT INTO <TABLE
NAME> (<COL_NAME1>,<COL_NAME2>...<COL_NAMEN>)VALUES
(<COL_VALUE1>,<COL_VALUE2>...<COL_VALUEN>)

How to write a left outer join with the where clause in oracle?

1127

---

Differentiate between translate and replace?

1184

---

How can you use check constraints for self referential integrity?

1012

---

Explain about the analyze command in oracle?

1105

---

What is flashback in Oracle?

1058

---

How to use fetch statement in a loop?

1066

---

How to store pictures on to the database?

1030

---

How to convert a date to char in oracle? Give one example.

1106

---

What is a database table in oracle?

1067

---

Respected sir, Please send me technical questions related to oracle apps..

1865

---

what is Single Byte Overhead...?

2611

---

How to list all tables in your schema?

1113

---

Give syntax for SQL and ORACLE joins.

1142

---

What is oracle rowcount?

1143

---

if you ctreate table identity

2426

---