sql知识点总结

。示例：根据工号为7900的员工的以下信息:ename,job,sal,comm,hiredate。第一种：如果用type类型，定义5个变量保存查询结果。代码略。第二种：如果用rowtype类型，只需要定义一个rowtype类型的变量。代码： declare v_empno emp.empno%type; v_row emp%rowtype; begin v_empno:=7900; select * into v_row from emp where empno=7900; dbms_output.put_line('ename='||v_row.ename); dbms_output.put_line('job='||v_row.job);

　　dbms_output.put_line('sal='||v_row.sal); dbms_output.put_line('comm='||v_row.comm); dbms_output.put_line('hiredate='||v_row.hiredate); end; 打印： ename=JAMES job=CLERK sal=950 comm= hiredate=03-12月-81 说明 ?¤必须select *，或者根据表结构的顺序写出所有字段名。 ?¤使用rowtype类型最主要的限制在于表中不能有大对象字段如：CLOB、BLOB。 delete from SYS_CXLBCS where ID='career_area_query_list_dwmc_tsgssp'; insert into SYS_CXLBCS (ID, TYPE, TITLE, COLHEAD, SELECTSTR, DESCRIBE, DICT, WIDTH) values('career_area_query_list_dwmc_tsgssp','q','工时登记放大镜单位名称查询', '选定*5|单位名称*10|所属地区*10|单位类型*10|单位性质*10|组织机构代码*10|工商登记号码*10|法定代表人*10|联系电话*10|单位地址*10',' SELECT ''<a href="javascript:returnBack(''''''||AAB001||'''''',''''''||AAB004||'' '''',''''''||AAB002||'''''',''''''||BOB011||'''''')">选定 </a>'',AAB004,AAA021,AAB019,AAB020,AAB003,AAB007,AAB013,AAB015,AAE006 from ab01','年审信息列表','4:AAB019|5:AAB020','95'); commit;

　　select * from (select ''<input type="radio" name="checkbox" value=''||BB10.BBA031||''>'', ''<a href="javascript:ldbzjc_show2(''''''||BB10.BBA031||'''''')">''||Bb10. Bfe004||''</a>'' Bfe004, (Case When Be65.Bbd017 Is Not Null Then Be65.Bbd017 Else ''01'' End) Bbd017, ------归档标志 Bb10.Bfe104 Bfe104, (Case When bb10.Bae005 Is Not Null Then

　　bb10.Bae005 Else bb10.Bae003 End) ttt , Bb10.AAB301 AAB301, Bb10.BAE001 BAE001,------系统机构代码(隐藏) Bb10.Bfe004 含超链接标记）(隐藏) From Bb10 Left Join Bbak On Bb10.Bba031 = Bbak.Bba031 Left Join Be64 On Bb10.Bba031 = Be64.Bba031 Left Join Be65 On Bb10.Bba031 = Be65.Bba031) Bfe004_value ------案件编号（无包

　　Left Join Bbak On

　　Select * From (Select t.*, Rownum Rowno From (Select '<input type="radio" name="checkbox" value=' || Zd23.Bzd120 || '|' || Zd41.Bzd121 || '|' || Zd23.W01 || '|' || Zd23.Bad005 || '></TD>', Zd23.W01, Case When W02 Is Not Null Then f_Zzlr_Getdictname('BOE484', W02) When W03 Is Not Null Then f_Zzlr_Getdictname('AAA105', W03) When W04 Is Not Null Then f_Zzlr_Getdictname('BOE223', W04) End Bblx, '<a href="#" onclick="openview(''' || Zd23.Bzd120 || ''',''' || Zd41.Bzd121 || ''',''' || Zd23.Bad005 || ''')">' || Zd23.Fls03 || '</a>', Zd23.Fls01 From Zd23, Zd41 Where 1 = 1 And Bzd121 In (Select Min(..Bzd121) Bzd121 From Zd41, Zd23 Where Zd23.Bzd120 = Zd41.Bzd120 Group By Zd41.Bzd120) And Zd23.Bad005 = '01' And ((Zd23.Bae001 Like '4408%' And

　　Zd23.Bae001 <> '4408') Or (Zd23.Ba