Answer / Vitesh Kumar

"Yes, you can convert a date to character in Oracle using the TO_CHAR function. Here is an example:nnSELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') FROM dual;"

What is a deadlock in SQL? How can you prevent it?

1 Answers  

---

What is coalesce function?

1 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1 Answers  

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

Define oracle database

1 Answers  

---

What are the ansi data types supported in oracle?

1 Answers  

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

Write a syntax for update query in oracle?

1 Answers  

---

Can you drop an index associated with a unique or primary key constraint?

1 Answers  

---

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

1 Answers  

---

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  

---

How do you ensure database security?

1 Answers  

---