Answer Posted / roopesh kumar

Varchar2: The max. allowed length is 4000 byte default 0
i.e. nothing. This is variable length datatype. it will
take only same space as value stored.

Char: Max. permitable length 2000 byte. Default length 0.
It will store value blank padded to right side till
full length as declared.

Ex. SQL> create table fg (d varchar2);
create table fg (d varchar2)
*
ERROR at line 1:
ORA-00906: missing left parenthesis


SQL> create table fg (d char);

Table created.

SQL> desc fg
Name Null? Type
------------------------------- -------- ----
D CHAR(1)
SQL> create table cher_chk (col1 char(12));

Table created.

SQL> insert into cher_chk values ('raj');

1 row created.
SQL> select length(col1) from cher_chk
2 /

LENGTH(COL1)
------------
12

what are the different tables present in mysql? : Sql dba

923

---

What is oracle sql developer?

992

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

884

---

how to drop an existing view in mysql? : Sql dba

995

---

what is a tablespace? : Sql dba

1004

---

Enlist the data types that can be used in pl/sql?

1002

---

What are pl/sql cursors?

989

---

How does index help in query performance?

967

---

how to get a list of all tables in a database? : Sql dba

918

---

What is a temporal table?

880

---

Explain the working of foreign key?

976

---

What is program debugging?

1129

---

what is myisam? : Sql dba

1000

---

What is field delimiter?

989

---

How to test for null values?

983

---