Answer / priyanka

The default value of char and number is null.
The default size is taken as 1 for char.

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.

Answer / prasanna

default value for chat type is 1

Is sql the best database?

0 Answers  

---

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

---

What is the execution plan in sql?

0 Answers  

---

How to look at the current sql*plus system settings?

0 Answers  

---

Why query optimization is needed?

0 Answers  

---

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

Does sql view stored data?

0 Answers  

---

What are different types of keys?

0 Answers  

---

How long does it take to learn pl sql?

0 Answers  

---

How to add, remove, modify users using sql?

0 Answers  

---

what are date and time data types in mysql? : Sql dba

0 Answers  

---

Which join is like inner join?

0 Answers  

---