Answer / Sushama

To insert a new row into the employee_details table, you can use the INSERT INTO statement. Replace the table name and column names with your specific table details.nnExample:nINSERT INTO employee_details (employee_id, first_name, last_name, department) VALUES ('new_employee_id', 'NewFirstName', 'NewLastName', 'NewDepartment');

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

---

What are the three pl sql block types?

1 Answers  

---

How many commands are there in sql?

1 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

What is pragma in sql?

1 Answers  

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1 Answers  

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---

How do you write a complex sql query?

1 Answers  

---

What is rank () in sql?

1 Answers  

---

Why do we use procedures in pl sql?

1 Answers  

---

What is sql dialect?

1 Answers  

---

What is a temp table?

1 Answers  

---