What are the data types allowed in a table?
Answers were Sorted based on User's Feedback
Answer / babloo
In a table the following data types are allowed :
1)varchar2()
2)date
3)long
4)integer
5)number
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
How to get help at the sql prompt?
What is pl/sql table? Why it is used?
What is rank function in sql?
How can we overcome recursive triggers in SQL?
What is type and rowtype in pl sql?
What does sign mean sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is a pl/sql block?
Does mysql support pl sql?
what are the differences between char and nchar? : Sql dba
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?
29 Answers Alps, Aricent, Bank Of America, Wipro,
What is indexing oracle sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)