Answer / parthasarathi

timestamp is used to store dates along with time .. we can store hours , minutes, seconds and milli seconds.

Does normalization improve performance?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

What is the purpose of primary key?

0 Answers  

---

What are the usage of SAVEPOINTS?

5 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---

Define the select into statement.

0 Answers  

---

How much does sqlite cost?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

What is union and union all keyword in sql and what are their differences?

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

Mention what are different methods to trace the pl/sql code?

0 Answers  

---