What is the default value of CHAR type?
Answers were Sorted based on User's Feedback
Answer / priyanka
The default value of char and number is null.
The default size is taken as 1 for char.
| Is This Answer Correct ? | 20 Yes | 2 No |
Answer / naresh
When a char variable is not specified in a data definition
or variable declaration statement, the default length is 1.
When a variable is not specified when using the CAST and
CONVERT functions, the default length is 30.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are nested triggers ?
6 Answers Amazon, Appeal Soft, IBM, Infosys, TCS,
How do you get all records from 2 tables. Which join do you use?
What is meant by temporal data?
How many types of cursors are available in pl/sql?
What is the use of sql trace?
select top 3 sal from each dept?
17 Answers IBM, TCS,
what is heap table? : Sql dba
How do I write a cron which will run a sql query and mail the results to agroup?
What is the difference between anonymous block and named block or stored procedure?
What is cursor in pl sql with examples?
Does truncate require commit?
What are sql ddl commands?
Oracle (3253)
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)