Discover
Waves
Decks
Login
Discover
Waves
Decks
Buy perks
Login
Signup
25
miawoo
Available
Used
Resource Credits
173 Followers
1 Following
June 22, 2018
RSS feed
Posts
Blog
Posts
Comments
Communities
Wallet
Mute
miawoo
eclips
6y
이클립스에서 오라클 연결
이클립스 오라클 연결 *db 연결 이클립스 > window > preference > exerd > dbms연결설정 > 새연결 *db 포워드 이클립스 > eXerd > 포워드엔지니어링
$ 0.000
1
3
miawoo
heidisql
6y
heidisql autocommit 명령어
SET @@AUTOCOMMit = 0; -- DDL / DML / DCL /* DCL */ commit; rollback; UPDATE 고객 SET 나이 = 20 WHERE 고객아이디 = 'APPLE';
$ 0.000
4
2
miawoo
oracle
6y
oracle rownum
SELECT ROWNUM, E.* FROM EMP E ORDER BY E.SAL DESC; -- CTRL + ENTER : 쿼리실행 SELECT ROWNUM, T.* FROM (SELECT * FROM EMP ORDER BY SAL DESC) T; SELECT * FROM (SELECT ROWNUM AS RNUM, T.* FROM (SELECT * FROM
$ 0.000
2
3
miawoo
oracle
6y
오라클 셋팅
oracle 셋팅 oracle.com 오라클 다운로드 oracle developer 툴 다운로드 cmd 창 sqlplus sys as sysdba CREATE USER SCOTT IDENTIFIED BY TIGER; GRANT RESOURCE, CONNECT TO SCOTT;
$ 0.000
2
2
Center