实验表
create table tb_char(name varchar2(20));
方法1：设置SQLPLUS环境变量 set define off insert into tb_char values(’&’);
方法2：使用函数chr insert into tb_char values(...
oracle 的插入和mysql 有点不一样，百度了下大概是这样吧，注意一行都不能少哦
insert all
into hlwsb_sjfx.zzs_server_ip_list(IP,ISUSE,NAME) values ('10.104.121.1',1,'发票下载服务器')
into hlwsb_sjfx.zzs_s...
oracle插入表数据的4种方式Created by Marydon on 2018-02-05 11:551.往表中插入一整行数据/*方法一*/INSERT INTO 表名 VALUES(val1,val2,val3,...);/*方法二*/INSERT INTO 表名 SELECT column1,column2,... FROM ...
创建表create table new_table_name as select * from (your_sql) as sql_table;new_table_name 替换为创建表名 your_sql 替换为sql语句插入表insert into old_table_name select * from (your_...
