テーブルの作成はできたのですが、中身の入れ方が上手く出来ません。
用途としては、サーブレット/JSPで作成したwebアプリケーションのログイン画面、一覧表示画面で使用したいのですが、上手くいきません。
参考にinsert文を教えて貰えればと思います。
CREATE TABLE company_info(
company_id NUMBER NOT NULL
, company_name VARCHAR2(50)
, abbreviation VARCHAR2(3)
, is_deleted CHAR (1) DEFAULT '0'
, created TIMESTAMP (6) DEFAULT systimestamp
, modified TIMESTAMP (6) DEFAULT systimestamp
, created_id VARCHAR2(20)
, modified_id VARCHAR2(20)
, CONSTRAINT company_info_pkc PRIMARY KEY (company_id)
);
CREATE UNIQUE INDEX sys_c007649
ON company_info(company_id);
-- EMPLOYEE_INFO
CREATE TABLE employee_info(
employee_id NUMBER NOT NULL
, name VARCHAR2(20)
, name_hiragana VARCHAR2(20)
, birthday DATE
, sex CHAR (1)
, mail_address VARCHAR2(50)
, telephone_number VARCHAR2(13)
, company_info_id NUMBER
, business_manager VARCHAR2(20)
, department CHAR (1)
, commissioning_status CHAR (1)
, is_deleted CHAR (1) DEFAULT '0'
, created TIMESTAMP (6) DEFAULT systimestamp
, modified TIMESTAMP (6) DEFAULT systimestamp
, created_id VARCHAR2(20)
, modified_id VARCHAR2(20)
, CONSTRAINT employee_info_pkc PRIMARY KEY (employee_id)
);
CREATE UNIQUE INDEX sys_c007651
ON employee_info(employee_id);
-- EMPLOYEE_STATE
CREATE TABLE employee_state(
employee_info_id NUMBER
, enter_date DATE
, retire_date DATE
, status CHAR (1)
, is_deleted CHAR (1) DEFAULT '0'
, created TIMESTAMP (6) DEFAULT systimestamp
, modified TIMESTAMP (6) DEFAULT systimestamp
, created_id VARCHAR2(20)
, modified_id VARCHAR2(20)
);
--LOGIN_INFO
create table login_info(
login_id varchar2(20 char),
password varchar2(20 char),
user_name varchar2(20 char),
is_deleted char(1) DEFAULT '0',
created timestamp DEFAULT systimestamp,
modified timestamp DEFAULT systimestamp,
created_id varchar2(20 char) ,
modified_id varchar2(20 char)
)
create sequence seq_id start with 1 increment by 1
回答2件
あなたの回答
tips
プレビュー