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 happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Why do we use subquery?
Which sorts rows in sql?
How can we make an if statement within a select statement?
Name some usages of database trigger?
What packages are available to pl/sql developers?
Can procedure in package be overloaded?
How do I view output in sql developer?
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
2 Answers Accenture, Unisoft Infotech,
How to move files from one directory to another in pl sql?
What is mutating error?
Why do we need a foreign key?
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)