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 |
How do I create a sql database?
What is the command used to fetch the first 5 characters of a string?
can i use dbms_output.put_line in a function u are telling as return statement
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is difference between cursor and ref cursor?
What does subquery mean in sql?
Can you selectively load only those records that you need? : aql loader
Is progress software supports to ( pl/sql )?
What is faster join or subquery?
What is sql trigger example?
Is sql the best database?
Mention what does plv msg allows you to do?
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)