摘要:
1. 复制表结构及其数据: create table table_name_new as select * from table_name_old 2. 只复制表结构: create table table_name_new as select * from table_name_old where 阅读全文
摘要:
// 建表 CREATE TABLE Person ( LastName varchar(30), FirstName varchar(30), Address varchar(30), Age int(3) ) // 建索引 CREATE INDEX PersonIndex ON Person ( 阅读全文
摘要:
-- C:/dba必需是已经存在的目录 -- create or replace directory UTL_DIR as 'C:\dba'; --用sys用户登录给要访问的用户指定访问目录的权限grant write on directory UTL_DIR to public;grant rea 阅读全文