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

Write a sql select query that only returns each name only once from a table?

1006

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1031

---

What is file based approach?

933

---

What are the triggers associated with image items?

1034

---

What is data type in sql?

945

---

What is data modelling in sql?

1010

---

Can sql function call stored procedure?

1011

---

Sql technical questions

1265

---

What does cursor do in sql?

1011

---

What is where clause in sql?

1031

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1048

---

Can we use delete in merge statement?

1033

---

How do you take the union of two tables in sql?

978

---

How do I get sql certification?

961

---

what is top in tsql? : Transact sql

1110

---