给你举例:
copy from system/lili@oemrep create test1 using select * from test;
会创建表,如果表已经存在会报错
copy from system/lili@oemrep insert test1 using select * from test;
会向表中插入数据
copy from system/lili@oemrep create test1 using select * from test;
会创建表,如果表已经存在会报错
copy from system/lili@oemrep insert test1 using select * from test;
会向表中插入数据
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/87010/viewspace-417746/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/87010/viewspace-417746/