Answer Posted / madhavi

1)varchar2()
2)date
3)TIMESTAMP[(precision)] default precision is 6 we can
mention from 0...9
4)long
5)integer
6)number
7)char
8)clob
9)raw()
10)pls_integer
11)binary_integer
12)nvarchar2()
13)bfile

what is the difference between nested subquery and correlated subquery?

986

---

What is the difference between truncate and drop statements?

1084

---

What is data definition language?

1044

---

How subquery works in sql?

995

---

What problem one might face while writing log information to a data-base table in pl/sql?

1066

---

What is sqlerrd?

921

---

Write a sql query to convert all character to uppercase after hypen.

1376

---

What is an oracle stored procedure?

987

---

What is the use of %rowtype?

976

---

What is the command used to fetch first 5 characters of the string?

1334

---

How do you use a while loop in pl sql?

940

---

What is the usage of sql functions?

1077

---

What are operators available in sql?

979

---

How do you delete duplicates in sql query using rowid?

892

---

What are user defined functions?

947

---