반응형
오라클 쿼리문들.
create TABLE EX
(
EXAM VARCHAR2(4000),
TXT CLOB
)
begin
spilt_data;
end;
update temp set examname=rownum where examname
>5
SELECT * from temp for update
SELECT * from GISA_EXAM_TEXT F
SELECT * from GISA_EXAM order by exam desc,q_no desc
SELECT * from temp
create TABLE GISA_EXAM
(
EXAM VARCHAR2(4000),
Q_NO NUMBER,
QUESTION VARCHAR2(4000),
CLUE VARCHAR2(4000),
ANS1 VARCHAR2(4000),
ANS2 VARCHAR2(4000),
ANS3 VARCHAR2(4000),
ANS4 VARCHAR2(4000),
RIGHT_ANS varchar2(4000),
expl varchar2(4000)
);
반응형
