oracleÒ»¸ösqlµÄÎÊÌâ
¼ÙÈ磬ÎÒÏÖÔÚÒª²éѯ±íaÖеÄ2¸ö×Ö¶Îx,y
¾ÍÊÇ select x,y from a
ÏÔÈ»Ëü»áÊä³ö2ÁеÄ
µ«ÊÇ£¬ÎÒÏÖÔÚÏëÈÃËûÖ»Êä³öÒ»ÁУ¬µ«ÊÇ£¬x,y×ֶεÄÄÚÈݱØÐ붼ÓÐ
×Ö¶ÎÄÚÈÝÒÔ x-yÐÎʽÊä³ö£¬ÇëÎÊÔõô×ö£¿
select x||'-'||y from a;
лл£¬»¹ÕæÐÐ
Ư¹ý~
select x||y from a;
select a||''||b from table
select concat('x',concat('_','y')) from dual;
ÓÃconcatº¯ÊýÒ²¿ÉÒÔʵÏÖ
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......