Input data
(1) Input database (Database name: SAMPLE_DB, table name: SAMPLE_TBL11)
Create the following table SAMPLE_TBL11 in the Oracle database SAMPLE_DB. Make sure that Shift JIS (Japanese_Japan. JA16SJIS) is the kanji character encoding (NLS_LANG) used for connecting to the database.
|
Field name |
NULL? |
Type |
|---|---|---|
|
KOUMOKU1 |
NOT NULL |
CHAR(1) |
|
KOUMOKU2 |
|
VARCHAR2(4000) |
|
KOUMOKU3 |
|
NUMBER(4) |
|
KOUMOKU4 |
|
NUMBER(7) |
|
KOUMOKU5 |
|
NUMBER(7,2) |
Figure 8.35 Input table (SAMPLE_TBL10)