How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

---

Explain the advantages and disadvantages of stored procedure?

0 Answers  

---

Is left join inner or outer?

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,

---

how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  

---

---

What is bind variable in pl sql?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

When the mutating error will comes? and how it will be resolved?

2 Answers  

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

---

how to retrieve the top 3 salaries of the table using rownum

31 Answers   Oracle,

---

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

---

What are the benefits of triggers?

0 Answers  

---