2019.02.15 / 19:15
Tibero °èÁ¤ »ý¼º, ±ÇÇѺο©, ±âº» Äõ¸® Å×½ºÆ® Çϱâ
hanulbit
Ãßõ ¼ö 278
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;