day0129

JdbcPstmt_01

create table sales (num number(5) primary key, type varchar2(10), sangpum varchar2(30), su number(5), dan number(5), ipgo date);

시퀀스 변수 4개

JdbcScore_02

create sequence seq_score;

create table sungjuk(num number(5) CONSTRAINT sungjuk_pk_num primary key,

name varchar2(20),

java number(5), oracle number(5), total number(5), average number(6,2));

day0129

QuizJdbc

시퀀스

create sequence seq_smem;

테이블

CREATE TABLE sawonmember ( s_no NUMBER PRIMARY KEY, s_name VARCHAR2(50), buseo VARCHAR2(50), position VARCHAR2(50), gender VARCHAR2(10), pay NUMBER(20), bonus NUMBER(20), ipsaday DATE );