1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the default value of CHAR type?

Question Posted / raja k

Answers were Sorted based on User's Feedback



What is the default value of CHAR type?..

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

What is the default value of CHAR type?..

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 is the default value of CHAR type?..

Answer / prasanna

default value for chat type is 1

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  

Where do we use pl sql?

0 Answers  

List different type of expressions with the example.

0 Answers  

What is sql prepared statement?

0 Answers  

Can we use pl sql in mysql?

0 Answers  




Why are sql stored procedures used?

0 Answers  

What is pl sql variable?

0 Answers  

What is scalar function?

0 Answers  

What are field types?

0 Answers  

How can a pl sql block be executed?

0 Answers  

What is an Exception ? What are types of Exception ?

2 Answers  

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories