Answer Posted / mk

Usually the trigger code is in a file e.g. trigger_name.sql

To create/replace the trigger object, at the SQL Plus prompt
type

@<folder>/trigger_name.sql

How does one use sql*loader to load images, sound clips and documents? : aql loader

1136

---

What is the non-clustered index in sql?

1024

---

What is tuple in sql?

1019

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7173

---

Which nosql database is best?

944

---

What is an example of translating a date into julian format?

1056

---

What is indexes?

1010

---

What are the parameter modes supported by pl/sql?

1039

---

What are predefined functions in sql?

990

---

Can a table contain multiple primary key’s?

1054

---

Can sql developer connect to db2?

1000

---

What is benefit of creating memory optimized table?

923

---

What is sqlca in powerbuilder?

967

---

What is raw datatype in sql?

996

---

What is union, minus and interact commands?

1233

---