Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2002/09/20(17:31) from 218.158.247.238 | |
ÀÛ¼ºÀÚ : °ÁÙ±â (jkkang65@hanmail.net) | Á¶È¸¼ö : 4060 , ÁÙ¼ö : 81 |
[Oracle] ¸í·É¾î ¸ðÀ½ |
---|
1. À¯ÀúÀÇ »ý¼º Çü½Ä create user À¯Àú¸í identified by Æнº¿öµå [ default tablespace Å×ÀÌºí½ºÆäÀ̽º¸í ] [ temporary tablespace Å×ÀÌºí½ºÆäÀ̽º¸í ] $ sqlplus system SQL> select * from all_users; USERNAME USER_ID CREATED ------------------------------ ---------- --------- SYS 0 07-APR-02 SYSTEM 5 07-APR-02 OUTLN 11 07-APR-02 DBSNMP 16 07-APR-02 TRACESVR 19 07-APR-02 AURORA$JIS$UTILITY$ 26 07-APR-02 OSE$HTTP$ADMIN 27 07-APR-02 AURORA$ORB$UNAUTHENTICATED 28 07-APR-02 SQL> create user jkkang identified by jkkang User created. SQL> alter user jkkang identified by jkkang123; User altered. SQL> grant connect,resource to jkkang; Grant succeeded. SQL> drop user jkkang; Çü½Ä drop user À¯Àú¸í; cascade; table Á¸ÀçÇÒ °æ¿ì À¯Àú°¡ object¸¦ ¼ÒÀ¯ÇÏ°í ÀÖÀ¸¸é À¯Àú¸¦ »èÁ¦ÇÒ ¼ö ¾ø´Ù. À̶§ À¯Àú¸í µÚ¿¡ cascade¸¦ »ç¿ëÇϸé, À¯Àú¿Í ±× À¯Àú°¡ ¼ÒÀ¯ÇÏ°í ÀÖ´Â ¸ðµç object¸¦ »èÁ¦ÇÒ ¼ö ÀÖ´Ù. 2. TableÀÇ »ý¼º SQL> create table Å×À̺í¸í; SQL> create table dept (deptno number(3) primary key, dname varchar2(10) unique, loc varchar2(10)); Table created. SQL> desc dept; Name Null? Type ----------------------------------------- -------- ---------------------------- DEPTNO NOT NULL NUMBER(3) DNAME VARCHAR2(11) LOC VARCHAR2(10) SQL> insert into dept values (100, '°ÁÙ±â', '´º¿å'); 1 row created. SQL> select * from dept; DEPTNO DNAME LOC ---------- ----------- ---------- 100 °Áٱ⠴º¿å SQL> delete from dept; 1 row deleted. SQL> drop table dept; Table dropped. |