수업/servlet, JSP

[POJO] 오라클에 db 업데이트

케잉 2023. 12. 12. 17:42

 

 

 

결과 

CREATE TABLE Board
(
	b_no                 number(5) NOT NULL ,
	b_title              VARCHAR2(300) NOT NULL ,
	b_writer             VARCHAR2(30) NOT NULL ,
	b_content            VARCHAR2(4000) NULL ,
	b_hiit               NUMBER(5) NULL ,
	b_date               VARCHAR2(30) NULL ,
	b_file               VARCHAR2(100) NULL 
)

Execution Successful


CREATE UNIQUE INDEX board_no_pk ON Board
(b_no   ASC)

Execution Successful


ALTER TABLE Board
	ADD CONSTRAINT  board_no_pk PRIMARY KEY (b_no)

Execution Successful

Schema Generation Complete
3 query succeeded.