What is a self join ?

6 Answers   BirlaSoft,

---

What is a table in a database?

0 Answers  

---

List the different type of joins?

0 Answers  

---

What is the difference between a procedure and a function?

0 Answers  

---

Can we create table in function?

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,

---

What is primary key secondary key alternate key candidate key?

0 Answers  

---

how to fetch alternate records from a table? : Sql dba

0 Answers  

---

What is set serveroutput on in pl sql?

0 Answers  

---

real time applications of nullif?

3 Answers  

---

What are the advantages of sql?

0 Answers  

---

how to create table with in the procedure or function?

2 Answers   Genpact, HCL,

---