Selected Category: oracle (11)

View Mode: Post List Post Summary

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

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

(Read More...)

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

▲top

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

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

(Read More...)

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

▲top

SELECT decode(id,

    111, 'AAA',

(Read More...)

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

▲top

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

from dual

(Read More...)

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

▲top

SELECT NVL(FIELD,'*')

FROM TABLE 

(Read More...)

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

▲top

可將 ASCII CODE 轉成 database character set

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

(Read More...)

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

▲top

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

FROM U_SECURITY.TABLE1;

(Read More...)

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

▲top

DROP VIEW "MyUser"."MyView";

CREATE VIEW "MyUser"."MyView" AS

(Read More...)

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

▲top

DROP TABLE "MyUser"."MyTable";

 

(Read More...)

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

▲top

CREATE USER "MyUser" PROFILE "DEFAULT"

    IDENTIFIED BY "MyUser"

(Read More...)

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

▲top
1 2