Use varchar2 as table column type : VARCHAR2 « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. VARCHAR2

Use varchar2 as table column type

    
SQL>
SQL> create table MyTable (
  2        event_name    varchar2(100),
  3        event_date    date);

Table created.

SQL>
SQL> insert into MyTable ( event_name, event_date ) values ( 'Oracle', TO_DATE( '2-DEC-2001', 'DD-MON-YYYY' ) );

1 row created.

SQL>
SQL> insert into MyTable ( event_name, event_date ) values ( 'Sample code', SYSDATE );

1 row created.

SQL>
SQL> column event_name format a40
SQL>
SQL> select * from MyTable;

EVENT_NAME                               EVENT_DATE
---------------------------------------- ------------------
Oracle                                   02-DEC-01
Sample code                              10-JUN-08

SQL> insert into MyTable (event_name, event_date) values ('World', TO_DATE( '2-DEC-2001', 'DD-MON-YYYY' ) );

1 row created.

SQL>
SQL> insert into MyTable ( event_name, event_date ) values ( 'code', SYSDATE );

1 row created.

SQL>
SQL> show parameters nls_date_format

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_date_format                      string
SQL>
SQL> insert into MyTable ( event_name, event_date ) values ( '9i', DATE '2001-10-11' );

1 row created.

SQL>
SQL> select * from MyTable;

EVENT_NAME                               EVENT_DATE
---------------------------------------- ------------------
Oracle                                   02-DEC-01
Sample code                              10-JUN-08
World                                    02-DEC-01
code                                     10-JUN-08
9i                                       11-OCT-01

SQL>
SQL> drop table MyTable;

Table dropped.

SQL>








Related examples in the same category

1.Comparison of CHAR with VARCHAR2 (Test the strings for equality)
2.Use % with like in a select statement for varchar2 column
3.declare varchar2 variables
4.Init a varchar2 type variable
5.varchar type are case sensitive
6.varchar2 type value with not null default value
7.Combine text string value in select clause
8.Are two text value equal
9.IN with text value
10.Change varchar type value
11.Assign a character string that is too long
12.Compare varchar2 value with =
13.Read clob data to varchar2 type variable
14.Use select into clause to assign value to a varchar2 type variable and output with dbms_output.put_line
15.Use case with switch varchar2 variable
16.Insert value to char type and varchar2 type
17.Check data size for varchar2 column
18.Varchar2 type column with different byte length
19.Varchar type variable is defined but has no value