Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 / ¿ª·¢

¿Í»§¶ËÊÇ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´æ´¢¹ý³ÌµÄ¶¯Ì¬Óαê³ö´í - Oracle / ¿ª·¢

create or replace procedure prc
AS
sqlstr varchar2(3000);
type resultcur is ref cursor;
begin
sqlstr := ¡®select * from tableÃû where Ìõ¼þ¡¯;
open resultcur for sqlstr; ---´Ë´¦±¨´í
......
end prc;
Compilation errors for PROCEDURE PRC
Error: PLS-00330: invalid use of type name or subtype n ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [23] [24] [25] [26] 27 [28] [29] [30] [31] [32]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ