Answer Posted / vara prasad vizag

Syntax:
INSERT INTO <Table-Name> ( Col1,Col2....)
VALUES(Val1,Val2...);

Example:
INSERT INTO StudentInfo (Studno,Fname,Lname,DOB,DOJ, Gender)
VALUES(1234,'Varaprasad','Vizag','17-Nov-85','M');

How to add a new column to an existing table in oracle?

1068

---

How to create a new table in your schema?

1025

---

How to see the table columns used in an index?

957

---

How to fetch the row which has the max value for a column?

944

---

Explain the use of log option in exp command.

1045

---

How to use subqueries with the exists operator in oracle?

967

---

How to open a cursor variable?

971

---

Is there an oracle sql query that aggregates multiple rows into one row?

930

---

What is proxy method?

927

---

What privilege is needed for a user to query tables in another schema?

917

---

What are nested tables?

1102

---

What is user managed backup in Oracle?

1074

---

What is the usage of save points in oracle database?

904

---

What do you mean by cdb and pdb in oracle 12c?

1005

---

What is a connect identifier?

981

---