본문 바로가기

728x90

oracle17

oracle sql (1)variable month_sal number;declarev_sal number(8) :=1800;begin:month_sal :=v_sal/12;end;/print month_sal;---------------------------------(2)set serveroutput oned d:\test1.sqldeclare v_sal number(8) :=3000;month_sal number(8);beginmonth_sal :=v_sal/12;dbms_output.put_line('내 급여는'||to_char(month_sal));end;/set serveroutput on@test1.sql (3)declarev_deptno dept.deptno%type;v_dname dept.dname%type.. 2015. 10. 5.

oracle sql declarev_no emp.empno%type :=&res_no;v_cnt number;v_sal emp.sal%type;v_sal2 emp.sal%type :=0;beginselect count(*) into v_cnt from empwhere empno = v_no;if v_cnt =0 thendbms_output.put_line(v_no ||'는 없는 번호 입니다.');elseselect sal into v_sal from emp where empno=v_no;if v_sal >=4000 thenv_sal2 :=v_sal +400;elsif v_sal >=3000 thenv_sal2 :=v_sal +300;elsif v_sal >=2000 thenv_sal2 :=v_sal +200;elsev_sa.. 2015. 10. 5.

oracle sql 커서(암시적 커서,명시적 커서) ▶속성SQL%ROWCOUNT:수행된 SQL 문의 결과로서 나온 행의 수를 반환한다. 암시적커서:SQL%ROWCOUNT set serveroutput on //dbms_output.put_line을 사용하기 위해서 먼저 set serveroutput on 을 써준다. declarev_deptno number :=&del_no;emp_aa varchar2(40);begindelete from emp where deptno =v_deptno;dbms_output.put_line(SQL%ROWCOUNT ||'명이 삭제되었습니다.');end;/----------------------------------------------------------@명시적 커서(1)dept 테이블을 이용한 커서를 만들고 loop를 .. 2015. 9. 24.

oracle sql 1. create table board(unq number(5) not null,title varchar2(30) not null,pwd varchar2(30) not null,writer varchar2(30) not null,content varchar2(200),hit number(5));rdate timestamp); 2. insert into board values('1','aaa','1234','aaa1','sodan','',sysdate); 3. select *from board order by rdate desc;4.select *from board where title like '%a2%' or content like '%a2%'; 5.select *from board where to_c.. 2015. 9. 24.

이전 1 2 3 4 5 다음

728x90

티스토리툴바