17,090
社区成员
发帖
与我相关
我的任务
分享
eygle@SZTYORA> desc emp;
名称 是否为空? 类型
----------------------------------------------------------------------------------------- -------- -----------------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NOT NULL NUMBER(2)
LOC NOT NULL VARCHAR2(13)
eygle@SZTYORA> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO LOC
---------- -------------------- ------------------ ---------- ------------------- ---------- ---------- ---------- ---------------------
7499 ALLEN SALESMAN 7698 1981-02-20 00:00:00 1600 300 30 CHICAGO
7521 WARD SALESMAN 7698 1981-02-22 00:00:00 1250 500 30 CHICAGO
7654 MARTIN SALESMAN 7698 1981-09-28 00:00:00 1250 400 30 CHICAGO
7844 TURNER SALESMAN 7698 1981-09-08 00:00:00 1500 0 30 CHICAGO
7900 JAMES CLERK 7698 1981-12-03 00:00:00 950 30 CHICAGO
7369 SMITH CLERK 7902 1980-12-17 00:00:00 800 20 DALLAS
已选择6行。
eygle@SZTYORA> select lpad(sal,15,'0') from emp;
LPAD(SAL,15,'0')
------------------------------------------------------------------------------------------------------------------------
000000000001600
000000000001250
000000000001250
000000000001500
000000000000950
000000000000800
已选择6行。
eygle@SZTYORA>
scott@RACDB> select lpad('luoyoumou',14,'0') from dual;
LPAD('LUOYOUMOU',14,'0')
----------------------------
00000luoyoumou
select lpad(day,2,'0') from tb_name;
select lpad(day,2,'0') from dual;