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 do you determine the current isolation level? : Transact sql
What is memory optimized?
What is meant by Join? What are the different types of Joins available? Explain.
What is memory optimized table?
What is the difference between SQL and PLSQL
Explain lock escalation? : Transact sql
How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')
How can I change database name in sql?
How to write html code in pl sql?
What is use of term?
What is the difference between rename and alias?
How do you use a while loop in pl 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)