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 |
What is dynamic SQl and how you will create and execute dynamic sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Define select, insert, create, delete, update, drop keywords
How do you retrieve the last N records from a table?
What is the advantage of index in sql?
What is the difference between mdf and ndf files?
Is there a 64 bit version of ssms?
What is the requirement of self-join?
what are all different types of collation sensitivity? : Sql dba
Mention what are different methods to trace the pl/sql code?
How do you write a complex sql query?
How do I debug a stored procedure?
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)