bazingaz的专栏

//table1和table2为两个测试表 随便插入几条数据 SQL> select * from table1; ID NAME ---------- -------------------- 1 wh 2 wp 3 wq SQL> select * from table2;

list 查看缓冲区的命令 l/ 执行缓冲区的命令change 改变缓冲区的命令 c ? setsave 保存缓冲区命令@ 执行文件命令get 查看文件命令get c:\oracle\a.txtedit 编辑缓存区文件column id heading "编号"describe col dname format A10 heading "部门名称"

declarev_name varchar2(10);v_sql varchar2(100);beginv_name:='name';v_sql:='select '||v_name||' from table1 where id = 1 ';execute immediate v_sql into v_name;dbms_output.put_line(v_name)

declarex varchar2(10):='ssss';begin--x:='This is..';dbms_output.put_line('x''s value is' ||x);end;/===============================SQL> set serveroutput on-----------------if---------

create or replace procedure RL_SZJC_ADDNEWistmp_flag number;tmp_now date;strSql varchar2(1000);--next_id number;tmp_rec RL_SZJC%ROWTYPE;type dy_cursor is ref cursor;cur_a dy_cursor;b

SQL> select * from emp;EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO----- ---------- --------- ----- ----------- --------- --------- ------ 7369 SMITH CLERK 790