Answer / raji_4u

Check for "EXPLAIN PLAN".

Answer / bunty

To check the statement is indexed or not via AUTO Trace -Â
Trace only command

Cheers,
Bunty

Answer / tushar

SELECT * FROM ALL_INDEXES
WHERE OWNER = 'MYUSERNAME' AND TABLE_NAME ='MYTABNAME' AND INDEX_NAME = 'MY_IND_NAME'

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---

What is a call statement? Explain with an example.

1 Answers  

---

Is sql considered coding?

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,

---

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

which operator is used in query for pattern matching? : Sql dba

1 Answers  

---

Where is all the data on the internet stored?

1 Answers  

---

How does join work in sql?

1 Answers  

---

What packages(if any) has oracle provided for use by developers?

2 Answers  

---

Explain the methods used to protect source code of pl/sql.

1 Answers  

---

Name the different types of indexes in sql and define them.

1 Answers  

---