ORACLE视图可以带参数查询吗? 如: create view aaa as select * from area_code where area_code=:vareacode之类的,如果可以,如何实现? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 sql*plus里面只能这样12:56:21 SQL> create view v1 as select * from tb11 where wzbh=&a;输入a的值: '0001'原值 1:create view v1 as select * from tb11 where wzbh=&a新值 1:create view v1 as select * from tb11 where wzbh='0001'视图已建立。实际:14012:56:32 SQL> select * from v1;WZBH RKBH RKSL RKJE---------- ---------- ---------- ----------0001 R001 9 54实际:4012:56:36 SQL> 要么动态创建...t_sql := 'create view v1 as select * from tb11 where wzbh='||t_str;execute immediate t_sql; 视图也是sql语句,只要你在程序里面动态sql执行之就行。 可以呀CREATE OR REPLACE VIEW AAA(字段1.....) as select 字段1.... from area_code where area_code=:vareacode; 因为SQL很复杂,原希望写在后台以防出错可改 declare l_sql varchar(100); test number;begin .... l_sql :='create view aaa as select * from area_code where area_code='; l_sql :=l_sql||test; execute immediate l_sql; ...end;/good luck ( p_date in date )as l_sql varchar(100); begin l_sql :='create view v_with_date as select * from zygl_ where sr_rq >=';l_sql :=l_sql||to_char(p_date); dbms_output.put_line(l_sql); execute immediate l_sql ;end sp_cr_view ;高书我参数类型错误 Oracle10g 可以通过自带的splplus连接,但是无法通过PL/SQL Developer连接 怎么向中间表里插入数据 紧急,复杂查询TimesTen 与oracle对比问题 一个关于效率的问题 sql 问题 sql语句:如何统计1月至5月每时段的发案数量,每时段是指将24小时分割位12段 在BCB版问,没有知道。 各位大哥请留步 帮小弟看看这个超简单的问题! 关于oracle8i做standby的详细步骤,23号结贴马上给分。 如何使Oracle 9i在开始时不自动启动?? 编译的程序不能执行 ora-3113的错误。谁知道怎样解决,或者从哪里开始入手分析。
输入a的值: '0001'
原值 1:create view v1 as select * from tb11 where wzbh=&a
新值 1:create view v1 as select * from tb11 where wzbh='0001'视图已建立。实际:140
12:56:32 SQL> select * from v1;WZBH RKBH RKSL RKJE
---------- ---------- ---------- ----------
0001 R001 9 54实际:40
12:56:36 SQL> 要么动态创建
...
t_sql := 'create view v1 as select * from tb11 where wzbh='||t_str;
execute immediate t_sql;
原希望写在后台以防出错可改
l_sql varchar(100);
test number;
begin
....
l_sql :='create view aaa as select * from area_code where area_code=';
l_sql :=l_sql||test;
execute immediate l_sql;
...
end;
/good luck
as
l_sql varchar(100);
begin
l_sql :='create view v_with_date as select * from zygl_ where sr_rq >=';
l_sql :=l_sql||to_char(p_date);
dbms_output.put_line(l_sql);
execute immediate l_sql ;end sp_cr_view ;
高书我参数类型错误