love mail

摘要： SYS@orcl SQL>SET TIME ON16:00:30 SYS@orcl SQL>CONN SCOTT/TIGER已连接。16:00:52 SCOTT@orcl SQL>select table_name from user_tables;TABLE_NAME ------------------------------ DEPT BONUS SALGRADE MEDEPT EMP TEST_TAB TEST03已选择7行。16:01:12 SCOTT@orcl SQL>select * from test03; EMPNO ENAME JOB MGR HIR 阅读全文

摘要： SCOTT@orcl SQL>conn test_user/test_user;已连接。TEST_USER@orcl SQL>create table test_tab(name varchar2(10));表已创建。TEST_USER@orcl SQL>create index test_idx on test_tab (name);索引已创建。TEST_USER@orcl SQL>alter table test_tab add constraint test_cons primary key (name);表已更改。TEST_USER@orcl SQL>se 阅读全文