If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---

What is the usage of the distinct keyword?

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,

---

can i call procedure in package

3 Answers   TCS,

---

What is substitution variable?

0 Answers  

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

what is the difference between delete and truncate statement in sql? : Sql dba

0 Answers  

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

Is inner join same as self join?

0 Answers  

---

How do I turn a list into a table?

0 Answers  

---