select salary, job_id, hire_date into v_sal, v_job, v_date
来源:互联网 发布:淘宝类目数据查询 编辑:程序博客网 时间:2024/05/29 17:30
declare
v_sal varchar2(55) ;
v_job varchar2(55) ;
v_date DATE;
begin
select salary, job_id, hire_date into v_sal, v_job, v_date
from employee where employee_id = 120;
dbms_output.put_line(salary);
end;
v_sal varchar2(55) ;
v_job varchar2(55) ;
v_date DATE;
begin
select salary, job_id, hire_date into v_sal, v_job, v_date
from employee where employee_id = 120;
dbms_output.put_line(salary);
end;
0 0
- select salary, job_id, hire_date into v_sal, v_job, v_date
- select into
- select into
- select into
- SELECT...INTO
- select into 和 insert into
- insert into 与 select into
- select into 与 insert into
- ORALCE: Select into VS Insert into select
- SELECT...INTO 以及insert into...select总结
- MySQL select into 和 SQL select into
- insert into select和 select into用法
- select into 和 insert into select区别
- MySQL select into 和 SQL select into
- Insert into select and select into
- select into 与 insert into select
- select into 和insert into select
- Insert into select 和 select into from
- c#中如何操作消息队列
- 软件工程再学习
- gauss 3种模板
- 杭电acm5480
- 行编译器-360笔试题
- select salary, job_id, hire_date into v_sal, v_job, v_date
- Codeforces Round #322 (Div. 2)
- iOS开发 ----- 下拉刷新
- Nosql数据库——redis(四)数据类型
- Please set ORACLE_UNQNAME to database unique name.的解决方案
- 超级流氓网站ddooo.com
- K皇后问题
- 流氓网站 星火软件veryhuo.com
- centos7.0 MYSQL rpm包的安装与其它的一些问题