What are the data types allowed in a table?

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

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

816


how to extract a unit value from a date and time? : Sql dba

569


tell me about various levels of constraint. : Sql dba

542


What language is oracle sql developer?

521


Write a unique difference between a function and a stored procedure.

541






what is oltp (online transaction processing)? : Sql dba

542


What are sql functions? Describe in brief different types of sql functions?

499


How do I make my sql query run faster?

476


What are the commands used in sql?

543


What are different categories of sql commands?

646


what are the differences between char and varchar? : Sql dba

538


What is procedure and function?

526


Why do we use view in sql?

542


What has stored procedures in sql?

611


What is spool?

605