Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

oracleµ¼³öÎÊÌâ - Oracle / ¿ª·¢

¿Í»§¶ËÊÇoracle9i,Ô¶³Ì·þÎñÆ÷¶ËÊÇoracle11g
ʹÓÃtoad µ¼³öÔ¶³Ì·þÎñÆ÷ÉϵÄÊý¾Ýʱ ±¨´íORA-01017: invalid username/password; logon denied
µ¼³öµÄÈÕÖ¾:
EXP-00056: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: invalid username/password; logon denied
EXP-00030: ¶ÁÈ¡ÊäÈëֵʱ³öÏÖÒâÍâµÄ EOF
EXP-00000: µ¼³öÖÕֹʧ°Ü

ÓÃÕ ......

oracleÈçºÎɾ³ý1Ô·ÝËùÓÐÊý¾Ý - Oracle / ¿ª·¢

oracleÈçºÎɾ³ý1Ô·ÝËùÓÐÊý¾Ý
±íÃûTEST¡¢Ê±¼äÁÐÃûcreate_date
create_date µÄ¸ñʽ Êý¾ÝÀàÐÍ

DATEÀàÐÍ ¸ñʽ2010-01-20 14:12:50


3 Â¥Õý½â ÏÂÊÖÕæ¿ì

Èç¹ûÊý¾ÝΪº£Á¿Êý¾ÝµÄ»°½¨ÒéʹÓ÷ÖÇø,Ó÷ÖÇøµÄtruncate

Òª¸ù¾ÝÔ·ݷÖ×éÔõô·Ö£¿ÎÒ·Ö³öÀ´ÊÇ°´Ìì·ÖµÄÓôÃÆÁË

group by to_char(create_date,'yyyymm')
......

Çë½ÌÒ»¸öoracle´æ´¢¹ý³ÌµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

´úÂëÈçÏ£º
create procedure putdraw
(ID char,money number)
as
vbalance number,vname char;
begin
select Bmoney,name into vbalance,vname from bankcheck
where CIN=ID;
if(vname is null) then
raise_application_error(-20000,'please create a zhanghao');
end if;
update bankcheck set Bmoney=Bmoney ......

oracleÁÐתÐÐÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÏÖÔÚÒ»¸ö±íÖÐÓÐÁ½ÁÐÊý¾Ý
shuliang area
1 025
2 0510
3 0511
4 0512
5 0513
ÒªÇóÊÇ°Ñarea×Ö¶ÎÖеÄֵת»»³É³ÇÊÐÃû³Æ£¬±ÈÈç025ÊÇÄϾ©£¬0510ÊÇÎÞÎý£¬0511ÊÇÕò½­£¬0512ÊÇËÕÖÝ£¬0512ÊÇÄÏͨ
ÏÔʾ³É
ÄϾ© ÎÞÎý Õò½­ ËÕÖÝ ÄÏͨ
1 2 3 4 5
ÇëÎÊsqlÔõôд°¡ ......

myeclipseÁ¬½ÓOracle±¨´í - Oracle / ¿ª·¢

ÎÒÓÃmyeclipseÁ¬½ÓOracleÒ»Ö±±¨´í£¬Ò»ÏÂÊDZ¨´í½Øͼ£¬
Çó¸ßÈËÏàÖú¡£
ÎÞͼÎÞÕæÏà....

file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/SF/Oracle%20JDBCÁ¬½Ó´íÎó.png
....

Äã¿´¿´Çý¶¯ºÍORACLEµÄ°æ±¾¶ÔӦô....

HTML code:
file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/SF/Oracle%20JD ......

¹ØÓÚoracleµÄ×Ô¶¨ÒåtypeµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ʹÓÃÁË×Ô¶¨Òåtype
ÈçÏÂ
create or replace type customtype as object(
ele1 char(7),
ele2 char(3)
);
Ö®ºóÔÚpackageÀïÃæÏëʹÓÃ
ÓÚÊÇд
l_ele1_c customtype.ele1%type;
µ«ÊDz»ÐУ¬pls00206µÄ´íÎó
ÆäʵÎÒ¾ÍÊÇÏëÔÚ×Ô¶¨ÒåtypeÄDZ߶¨ÒåºÃÁË£¬packageÄDZßÒÔºó¾Í²»»á±äÁË£¬Ö»ÒªÊ¹ÓÃcustomtype.ele1µÄtype¾ÍºÃÁË
ÇëÎÊ ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [1] [2] 3 [4] [5] [6] [7] [8] [9] [10]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ