CHAR() and VARCHAR2() : CHAR « Data Type « Oracle PL / SQL

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

CHAR() and VARCHAR2()

   
SQL> CREATE TABLE test_2 (
  2       name   VARCHAR2(20),
  3       gender CHAR(1)
  4       );


Table created.

SQL>
SQL> INSERT INTO test_2 VALUES ('George', 'M');

1 row created.

SQL> INSERT INTO test_2 VALUES ('Jane', 'F');

1 row created.

SQL>
SQL> SELECT * FROM test_2;

NAME                 G
-------------------- -
George               M
Jane                 F

SQL>
SQL> DROP TABLE test_2;

Table dropped.

SQL>
SQL>

   
    
  

Related examples in the same category