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 a materialized view? : Sql dba

1126

---

what is the stuff function and how does it differ from the replace function? : Sql dba

1107

---

What is the purpose of normalization?

1084

---

What is trigger in sql?

1156

---

What is lexical units in pl sql?

1204

---

Which table is left in left join?

1060

---

what are the differences between binary and varbinary? : Sql dba

1083

---

What are the constraints available in sql?

1083

---

What is the difference between execution of triggers and stored procedures?

1155

---

What are secondary keys?

1030

---

Does inner join return duplicate rows?

1036

---

Does sql view stored data?

1003

---

how to show all tables with 'mysql'? : Sql dba

1155

---

What are character functions in sql?

990

---

is it possible to pass an object or table to a procedure as an argument?

1176

---