Answer / karthik murugan

sql is not a named block, it can be stored as sql file outside the database, when stored procedures are named block can be stored inside the database.

Answer / thanjairajan@gmail.com

SQL is a Language. Stored procedure is transact SQL statement.

What is the difference between left outer join and left join?

0 Answers  

---

What is dba in sql? : SQL DBA

0 Answers  

---

What is a stored procedure ?

5 Answers  

---

Is sql sequential or random?

0 Answers  

---

What is sql basics?

0 Answers  

---

---

What is sql dialect?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---

What is the difference between inner join and outer join?

0 Answers  

---

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

what is inline view?

15 Answers  

---