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
Ïà¹ØÎĵµ£º
DBAÒª¶¨Ê±¶ÔÊý¾Ý¿âµÄÁ¬½ÓÇé¿ö½øÐмì²é£¬¿´ÓëÊý¾Ý¿â½¨Á¢µÄ»á»°ÊýÄ¿ÊDz»ÊÇÕý³££¬Èç¹û½¨Á¢Á˹ý¶àµÄÁ¬½Ó£¬»áÏûºÄÊý¾Ý¿âµÄ×ÊÔ´¡£Í¬Ê±£¬¶ÔһЩ“¹ÒËÀ”µÄÁ¬½Ó£¬¿ÉÄÜ»áÐèÒªDBAÊÖ¹¤½øÐÐÇåÀí¡£
ÒÔϵÄSQLÓï¾äÁгöµ±Ç°Êý¾Ý¿â½¨Á¢µÄ»á»°Çé¿ö:
select sid,serial#,username,program,machine,status
from v$session;
......
Ò»¸ö±íÖÐÓм¸°ÙÍòÌõÊý¾Ý£¬¶Ôij¸ö×ֶμÓÁËË÷Òý£¬µ«ÊDzéѯʱÐÔÄܲ¢Ã»ÓÐʲôÌá¸ß£¬ÕâÖ÷Òª¿ÉÄÜÊÇoracleµÄË÷ÒýÏÞÖÆÔì³ÉµÄ¡£
¡¡¡¡oracleµÄË÷ÒýÓÐһЩË÷ÒýÏÞÖÆ£¬ÔÚÕâЩË÷ÒýÏÞÖÆ·¢ÉúµÄÇé¿öÏ£¬¼´Ê¹ÒѾ¼ÓÁËË÷Òý£¬oracle»¹ÊÇ»áÖ´ÐÐÒ»´ÎÈ«±íɨÃ裬²éѯµÄÐÔÄܲ»»á±È²»¼ÓË÷ÒýÓÐËùÌá¸ß£¬·´¶ø¿ÉÄÜÓÉÓÚÊý¾Ý¿âά»¤Ë÷ÒýµÄϵͳ¿ªÏúÔì³ÉÐÔÄܸ ......
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 ......
Ö÷ÒªÊÇͨ¹ýreplaceºÍtranslateÀ´ÊµÏÖ
SQL> create view v_tt
2 as
3 select ename||' '||deptno as data
4 from emp;
View created.
SQL> select * from v_tt;
DATA
---------------------------------------------------
SMITH 20
ALLEN 30
WARD 30
JONES 20
MARTIN 30
BLAKE 30
CLARK 10
......
ÓÉÓÚÏîÄ¿µÄÐèҪȥGoogleËÑÁËһϠ£¬»¹Õæ¶à
¼ÇµÃ“Ïëµ±Äê”ijÌìÉÏÎçÔÚÕâÀï·¹ý£¬¿´µ½Ò»Î»ÅóÓÑÌùµÄ×Ô¼ºÐ´µÄÑéÖ¤Âë³ÌÐò£¬ËäÈ»ËûµÄ³ÌÐòÊǺڰ×ÓÐÔӵ㣬µ«ÆäʵºÜÈÝÒ×±»ÆÆ½âµÄ£¬µ«È´Óв»ÉÙÈËϲ»¶×Å¡£¡£¡£Ã»°ì·¨£¬µ±ÌìÏÂÎçÑо¿ÁËÒ»· BMP ͼƬ£¬È»ºó¾Íд³öÁËÕâЩ´úÂ룬ֻÊǵ±³õûÓй«²¼£¬ÑÛ¿´½ñÌìÕâô¶à»µÈËÂÒÔںܶàÂÛ̳ ......