这个sql语句如何写 select * from t1,t2 where t1.id=t2.pid and instr(t1.name,t2.pname)<>0 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from t1,t2 where t1.id=t2.pid and (substr(trim(t1.name),5)=trim(t2.name) or substr(trim(t1.name),7)=trim(t2.name);; sorry,select * from t1,t2 where t1.id=t2.pid and (substr(trim(t1.name),5)=trim(t2.name) or substr(trim(t1.name),7)=trim(t2.name)); Net8(High Water Mark): 不行啊,ORACLE是不是将t1.name,t2.pname当成字符串了,而不是字段名。 select * from t1,t2 where t1.id=t2.pid and instrB(t1.name,t2.pname)>0 怎么会将t1.name,t2.pname当成字符串呢?又不是变量,这里是字段名嘛。不过我懒,没有测试。 select * from t1 where exists(select 1 from t2 where pid=id and instr(name,pname)>0) 老大们,还是不行,返回值全部为0, 我用的是oracle8.1.7 on redhatlinux 试试select t1.* from t1,t2 where t1.id=t2.pid and t2.pname like %t1.name% 不是语句有问题,是楼主表达不清.select * from t1 where exists(select 1 from t2 where pid=id or instr(name,pname)>0) oracle 11gR2版本的数据泵备份与恢复用户信息,急!!! jobs 不能自动运行 关与GROUP BY 的问题 java.sql.SQLException: ORA-01000: maximum open cursors exceeded ORACLE查询表和序列问题 long raw ;如何在存储过程里 进行 insert? 机器名改变后数据库无法启动? 关于sqlplus的问题 大家好,我想请教一下关于ORACLE编程的问题,多谢大家帮忙 表怎么变慢了? 急:Oracle中能否只导出数据而不导出表结构等信息? 救命啊~!Oracle高手来看看!实在是太难解决了!!!(在线等待)
select * from t1,t2 where t1.id=t2.pid and (substr(trim(t1.name),5)=trim(t2.name) or substr(trim(t1.name),7)=trim(t2.name));
不过我懒,没有测试。
select t1.* from t1,t2 where t1.id=t2.pid and t2.pname like %t1.name%
select * from t1 where exists(select 1 from t2 where pid=id or instr(name,pname)>0)