Selected Category: oracle (11)

View Mode: Post List Post Summary

到控制台=>系統管理工具=>本機安全性原則上=>本機原則=>使用者權限指派->以批次工作登入

把你的Windows登入的那個帳號加進去就好ㄌ!!

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(23)

NUMBER(p,s):p 指定一個數目有多少個十進位數字,s 指定多少個小數位。

DATE:日期資料型態,它儲存的資訊包括:世紀、年、月、日、時、分、秒。

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(419)

SELECT decode(id,

    111, 'AAA',

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(136)

select rpad('ABCD',30,'A')

from dual

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(163)

SELECT NVL(FIELD,'*')

FROM TABLE 

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(179)

可將 ASCII CODE 轉成 database character set

select CHR(67) || CHR(65) AA

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(62)

SELECT (TABLE1.EMP_NUMBER || ' ' || TABLE1.EMP_NAME) EMP

FROM U_SECURITY.TABLE1;

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(43)

DROP VIEW "MyUser"."MyView";

CREATE VIEW "MyUser"."MyView" AS

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(131)

DROP TABLE "MyUser"."MyTable";

 

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(133)

CREATE USER "MyUser" PROFILE "DEFAULT"

    IDENTIFIED BY "MyUser"

Posted by fabch2 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(62)

1 2