What is a schema in sql?

1 Answers  

---

How to trace the errors in pl/sql block code?

5 Answers   TCS,

---

Which software is used for pl sql programming?

0 Answers  

---

How can you view the errors encountered in a trigger?

0 Answers  

---

Does truncate free space?

0 Answers  

---

Whis is not false in primary key?

0 Answers   Fintellix,

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 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 many subqueries can be nested in a statement?

0 Answers  

---

What is the unique index?

0 Answers  

---

Does varchar need length?

0 Answers  

---

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

---