Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

asp¡¢delphi¡¢oracleµÄ¼¼ÊõÎĵµ×ܽá

1) DelphiÏòoracleÖд«µÝ²ÎÊý ÈçoracleÖеIJÎÊýÃûΪerpcx 
´ð£ºÈç¹ûÏë´Ó±íÀïÈ¡Öµµ½oracle£¬Ôòerpcx:=trim(aq1.fieldbyname('erpcx').AsString);
·ñÔòÖ±½ÓÓÿؼþÃû×Ö
Óï¾äΪ
with aperp do    
begin
connection:=dm.ADOCerp;      
parameters.Clear;       
procedurename:='pc_erpbominquery';       
parameters.CreateParameter(erpcx,ftstring,pdinput,60,erpcx); ´Ë¾äΪ´«²ÎÊýÓï¾ä
·ñÔòÖ±½ÓÓÃ Parameters.CreateParameter('@erpcx',ftString,pdInput,100,edit5.text);        
ExecProc;    
end; 
  
2)sqlÈ¡ËÄÉáÎåÈëÖ°  round(×Ö¶ÎÃû£¬Ð¡ÊýµãºóλÊýÈçÈ¡ÕûÊýΪ0) 
 
3)sqlÁ¬½Óͬһ·þÎñÆ÷µÄ²»Í¬±íµÄÊý¾Ý 
´ð£ºselect * from Êý¾Ý¿âÃû.dbo.±íÃû 
 
4£©ÒªÏë´Ó¶à¸ö±íÀï²éÊý¾Ý£¬aÀïÓÐ5¸ö bÀïÓÐ3¸ö cÀïÓÐ2¸öÏÔʾʱ¸ÃÈçºÎÈ¥µôÖظ´µÄ²¿·ÖÄØ
Èç ±ía                  ±íb                    ±íc
id  education          id    guanxi        id  work
0001  1´óѧ            0001    ¸¸×Ó          0001  1¹«Ë¾
0001  2´óѧ            0001    ĸ×Ó          0001  2¹«Ë¾
0001  3´óѧ            0001    ½ãÃÃ
0001  4´óѧ
´ð£ºalter table a add px int identity(1,1)
go
alter table b add px int identity(1,1)
go
alter table c add px int identity(1,1)
go
select  a.id,a.educatio


Ïà¹ØÎĵµ£º

oracleµÄË÷ÒýÏÝÚå

Ò»¸ö±íÖÐÓм¸°ÙÍòÌõÊý¾Ý£¬¶Ôij¸ö×ֶμÓÁËË÷Òý£¬µ«ÊDzéѯʱÐÔÄܲ¢Ã»ÓÐʲôÌá¸ß£¬ÕâÖ÷Òª¿ÉÄÜÊÇoracleµÄË÷ÒýÏÞÖÆÔì³ÉµÄ¡£
¡¡¡¡oracleµÄË÷ÒýÓÐһЩË÷ÒýÏÞÖÆ£¬ÔÚÕâЩË÷ÒýÏÞÖÆ·¢ÉúµÄÇé¿öÏ£¬¼´Ê¹ÒѾ­¼ÓÁËË÷Òý£¬oracle»¹ÊÇ»áÖ´ÐÐÒ»´ÎÈ«±íɨÃ裬²éѯµÄÐÔÄܲ»»á±È²»¼ÓË÷ÒýÓÐËùÌá¸ß£¬·´¶ø¿ÉÄÜÓÉÓÚÊý¾Ý¿âά»¤Ë÷ÒýµÄϵͳ¿ªÏúÔì³ÉÐÔÄܸ ......

½â¶ÁORACLEÊý¾Ý¿âµÄͳһÃüÃûÓë±àÂë¹æ·¶

1¡¢±àдĿµÄ
ʹÓÃͳһµÄÃüÃûºÍ±àÂë¹æ·¶£¬Ê¹Êý¾Ý¿âÃüÃû¼°±àÂë·ç¸ñ±ê×¼»¯£¬ÒÔ±ãÓÚÔĶÁ¡¢Àí½âºÍ¼Ì³Ð¡£
2¡¢ÊÊÓ÷¶Î§
±¾¹æ·¶ÊÊÓÃÓÚ¹«Ë¾·¶Î§ÄÚËùÓÐÒÔORACLE×÷Ϊºǫ́Êý¾Ý¿âµÄÓ¦ÓÃϵͳºÍÏîÄ¿¿ª·¢¹¤×÷¡£
3¡¢¶ÔÏóÃüÃû¹æ·¶
3.1 Êý¾Ý¿âºÍSID
Êý¾Ý¿âÃû¶¨ÒåΪϵͳÃû+Ä£¿éÃû
¡ï È«¾ÖÊý¾Ý¿âÃûºÍÀý³ÌSID ÃûÒªÇóÒ»ÖÂ
¡ï ÒòSID ......

hibernateÖÐoracleµÄ×ÔÔöÎÊÌ⣺

Ò»Ö±ÒÔΪ  <id name="id" type="integer">
<column name="ID" precision="5" scale="0" />
<generator class="sequence"¡¡/>
</id> ÕâÑù¾Í¿ÉÒÔ×ÔÔöÁË¡£¡£
¿É½ñÌìÔÚ²âÊÔʱ£¬·¢ÏÖ¿ØÖÆ̨һֱ±¨“ÐòÁкŲ»´æÔÚ"µÄ´í¡£¡£¡£ºóÀ´²ÅÖªµÀÔÚsequenceºóà ......

ORACLE ÔÚWHERE×Ó¾äÖÐÒýÓÃÁбðÃûµÄÎÊÌâ

SQL> select sal,comm from emp
2 where sal<2000;
SAL COMM
---------- ----------
800
1600 300
1250 500
1250 1400
1500 0
1100
950
1300
8 rows selected.
SQL> select sal as salary,comm as ......

oracle·Ö×麯ÊýÖ®ROLLUP

 
1.³õʼ»¯ÊµÑ黵¾³
1£©´´½¨²âÊÔ±ígroup_test
sec@ora10g> create table group_test (group_id int, job varchar2(10), name varchar2(10), salary int);
¡¡
Table created.
¡¡
2£©³õʼ»¯Êý¾Ý
insert into group_test values (10,'Coding',    'Bruce',1000);
insert into group_test val ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ