oracle
文章平均质量分 77
reunfish
这个作者很懒,什么都没留下…
展开
-
PL-SQL Syntaxes-Examples_Part2.txt
11) Procedures declare procedure findarea(myrad number) is area number; begin area:=3.14*myrad*myrad; dbms_output.put_line(Area is ||area); end; begin findarea(3); en原创 2006-03-07 20:09:00 · 752 阅读 · 0 评论 -
some sql queries.
CREATE TABLE EMP(EMPNO NUMBER(10) CONSTRAINT Nnull NOT NULL CONSTRAINT PKEY1 PRIMARY KEY,ENAME VARCHAR(15) ,JOB CHAR(12),MGR NUMBER(10),HIREDATE DATE,SAL NUMBER (8),COMM NUMBER(15),DEPTNO NUMBER(5));原创 2006-03-07 20:13:00 · 2401 阅读 · 0 评论