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 the benefits of using PL/SQL packages?
What is a constraint?
How would you hide a table in sql. ie the table can be only visible to its maker?
Does truncate free space?
What are sql functions? Describe the different types of sql functions?
how to drop an existing table in mysql? : Sql dba
State the difference between implict and explict cursor's?
What is oracle sql called?
What is materialized view. What are different methods of refresh?
What are the new features in Oracle 10g. Compared to Oracle 9i?
What is sql catalog?
What is multiple partition?
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)