<div id="codeSnippetWrapper"> <div style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',courier,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px" id="codeSnippet">
<pre style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">1、简单sql语句，HellWorld示例

输出信息

);

;

;
;
 := sysdate;
 := ;
;
 || sName);  
 || sCount);  
 || sSal);
 || sDate);
 || sPI);
 || sValid);
 || sName);
 
   emp.empno%type   binary_integer;
 record (

;
;
 || temp.dname  ||  || temp.loc);

;
;
sql语句完成变量赋值
 sal,ename  v$sal,v$ename  emp  rownum = 1;
 || v$ename);
sql语句完成rowtype变量赋值
 *  v_row_emp  emp  empno = 7698;
 || v_row_emp.ename);
sql语句完成变量插入数据
  dept2   *  dept;
;
;
 dept2 (deptno,dname,loc);
;
 *  dept2;