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
Ïà¹ØÎĵµ£º
Ò»¸ö±íÖÐÓм¸°ÙÍòÌõÊý¾Ý£¬¶Ôij¸ö×ֶμÓÁËË÷Òý£¬µ«ÊDzéѯʱÐÔÄܲ¢Ã»ÓÐʲôÌá¸ß£¬ÕâÖ÷Òª¿ÉÄÜÊÇoracleµÄË÷ÒýÏÞÖÆÔì³ÉµÄ¡£
¡¡¡¡oracleµÄË÷ÒýÓÐһЩË÷ÒýÏÞÖÆ£¬ÔÚÕâЩË÷ÒýÏÞÖÆ·¢ÉúµÄÇé¿öÏ£¬¼´Ê¹ÒѾ¼ÓÁËË÷Òý£¬oracle»¹ÊÇ»áÖ´ÐÐÒ»´ÎÈ«±íɨÃ裬²éѯµÄÐÔÄܲ»»á±È²»¼ÓË÷ÒýÓÐËùÌá¸ß£¬·´¶ø¿ÉÄÜÓÉÓÚÊý¾Ý¿âά»¤Ë÷ÒýµÄϵͳ¿ªÏúÔì³ÉÐÔÄܸ ......
1¡¢±àдĿµÄ
ʹÓÃͳһµÄÃüÃûºÍ±àÂë¹æ·¶£¬Ê¹Êý¾Ý¿âÃüÃû¼°±àÂë·ç¸ñ±ê×¼»¯£¬ÒÔ±ãÓÚÔĶÁ¡¢Àí½âºÍ¼Ì³Ð¡£
2¡¢ÊÊÓ÷¶Î§
±¾¹æ·¶ÊÊÓÃÓÚ¹«Ë¾·¶Î§ÄÚËùÓÐÒÔORACLE×÷Ϊºǫ́Êý¾Ý¿âµÄÓ¦ÓÃϵͳºÍÏîÄ¿¿ª·¢¹¤×÷¡£
3¡¢¶ÔÏóÃüÃû¹æ·¶
3.1 Êý¾Ý¿âºÍSID
Êý¾Ý¿âÃû¶¨ÒåΪϵͳÃû+Ä£¿éÃû
¡ï È«¾ÖÊý¾Ý¿âÃûºÍÀý³ÌSID ÃûÒªÇóÒ»ÖÂ
¡ï ÒòSID ......
Ò»Ö±ÒÔΪ <id name="id" type="integer">
<column name="ID" precision="5" scale="0" />
<generator class="sequence"¡¡/>
</id> ÕâÑù¾Í¿ÉÒÔ×ÔÔöÁË¡£¡£
¿É½ñÌìÔÚ²âÊÔʱ£¬·¢ÏÖ¿ØÖÆ̨һֱ±¨“ÐòÁкŲ»´æÔÚ"µÄ´í¡£¡£¡£ºóÀ´²ÅÖªµÀÔÚsequenceºóà ......
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 ......
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 ......