ÃֽŠ°Ô½Ã±Û(DB)
2019.02.15 / 19:15

Tibero °èÁ¤ »ý¼º, ±ÇÇѺο©, ±âº» Äõ¸® Å×½ºÆ® Çϱâ

hanulbit
Ãßõ ¼ö 275

1. sys°èÁ¤ Á¢¼Ó(tbsql sys/[sys°èÁ¤ºñºô¹øÈ£])
tbsql sys/********




2. »ç¿ëÀÚ°èÁ¤ »ý¼º(tablespace´Â default)
create user testid
identified by testpwd;




3. »ý¼ºµÈ »ç¿ëÀÚ¿¡°Ô ±ÇÇÑ ºÎ¿©
grant connect to testid;
grant resource to testid;




4. »õ·Î¿î °èÁ¤À¸·Î Á¢¼ÓÇϱâ
conn testid;
testpwd





5. Å×À̺íÀÇ »ý¼º
CREATE TABLE EMPLOYEE
(ID NUMBER, EMPLOYEE_NAME VARCHAR(20), ADDRESS VARCHAR(50));





6. µ¥ÀÌÅÍ insertÇϱâ
insert into employee values(1,'hanjoong-cho','kyungki');
insert into employee values(2,'jaewook-an','seoul');





7. µ¥ÀÌÅÍ Á¶È¸Çϱâ
select * from testid.employee;