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

¸ßÊÖ,ÇóÒ»oracle sql²éѯ¹¦ÄÜ - Oracle / ¿ª·¢

-----²âÊÔ±í(oracle 10G):
create table portal_his.testuser(
XH numeric NOT NULL ,-----¸Ã×Ö¶ÎÖµÊÇΨһµÄ;
deptid numeric NOT NULL ,
zwid numeric NULL ,
names varchar(20) NULL,
constraint testuser_pk PRIMARY KEY (XH) 
);


------²âÊÔÊý¾Ý:
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(1,1,2,'a1');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(2,1,2,'a1');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(3,1,3,'a3');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(4,1,2,'');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(5,2,4,'a4');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(6,2,6,'a4');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(7,2,10,'a5');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(8,3,10,'');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(9,2,10,'');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(10,3,10,'a7');


Çósql²éѯ¹¦ÄÜ:
-----Èç¹ûnames×Ö¶ÎֵΪ''»ònull,Ôò°Ñ¸Ã¼Ç¼ÖÐdeptidºÍzwidÖµÏàµÈµÄnames×Ö¶ÎÖµÄÚÈÝȡһ¸ö³öÀ´(Èç¹ûÕÒµ½¾Íȡһ¸ö³öÀ´,ûÓÐÕÒµ½¾Í²»¹ÜËü).
xh deptid zwid names
1 1 2 a1
2 1 2 a1
3 1 3 a3
4 1 2 -----ÕâÀïµÄ²éѯ


Ïà¹ØÎÊ´ð£º

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ