select * into xyz2808 from xyz808 while right( xyz808.m808,4) like '2808'我想从表xyz808中查询出列m808(字符型)的值右边4位等于 2808,写入新表xyz2808

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/06 01:14:42
select * into xyz2808 from xyz808 while right( xyz808.m808,4) like '2808'我想从表xyz808中查询出列m808(字符型)的值右边4位等于 2808,写入新表xyz2808

select * into xyz2808 from xyz808 while right( xyz808.m808,4) like '2808'我想从表xyz808中查询出列m808(字符型)的值右边4位等于 2808,写入新表xyz2808
select * into xyz2808 from xyz808 while right( xyz808.m808,4) like '2808'
我想从表xyz808中查询出列m808(字符型)的值右边4位等于 2808,写入新表xyz2808

select * into xyz2808 from xyz808 while right( xyz808.m808,4) like '2808'我想从表xyz808中查询出列m808(字符型)的值右边4位等于 2808,写入新表xyz2808
如果xyz2808表没有的话可以这样写
select * into xyz2808 from xyz808 where right(xyz808.m808,4) like '2808'
如果xyz2808表已存在就要这样写
insert into xyz2808
select * from xyz808 while right( xyz808.m808,4) like '2808'
当然你的列的数量两个表要对应

select * into dept2 from dept select * into b from a where 11 数据库中select into from 和 insert into select的区别 SELECT abap 中 select.into 和 move.to 的区别! insert into a select * from b 和select * into a from b 这两个语句是不是一样的? oracle 中select into是什么意思把一个表里面的内容复制到另一个吗 还是别的 是不是还要先创建一个表啊create table aaa as select * from bbb 这样的效果 用select into 能做到么? select count (1)V_COUNT := 0;SELECT COUNT(1) INTO V_COUNT FROM CUST WHERE CUST_ID = ARG_CUST_ID;IF V_COUNT = 0 THEN我是个初学者,今有如上这么一段程序,里面select count(1)是什么意思? insert into REC_OVER(ORG_ID) select '1' from dual where not exists (select ORG_ID from REC_OVER )insert into REC_OVER(ORG_ID) select '1' from dual where not exists (select ORG_ID from REC_OVER ) 请问oracle里这样的语句,为什么在sql/plus可 select count() into :r_count from zw_kmyeb where km_code like '5%' and qcye0;messagebox('r_count',r_count)like 5%是什么? PLSQL中复制表select * into b from a where 11这句话中where 11在这里怎么理解 insert into a (select * from b)和把记录取出来然后分别insert那个的效率高? select * into a from a..a 请问,这句中的a....有什么用a..是另一个库吗 select hkont from bseg into table itab_bseg where ( hkont like '1001%' or hkont like '1002%' ).中%是什么意思 英语翻译x=.value a= select .into table t + x&a(+x a=为什么要加引号?) piease.select select()是什么? select your