SQL *PLUS RepostµÄ¿ª·¢·½·¨
SQL *PLUS RepostµÄ¿ª·¢·½·¨
ʹÓÃSQL*PLUS ¿ÉÖ±½ÓÔÚIE BrowserÖÐÉú³É¹æÕûµÄ×Ö·ûÐÍReport. ʵÏÖ·½·¨¼òµ¥£¬²¼ÊðÈÝÒס£
·½·¨:
1. ÀûÓÃÎı¾±à¼Æ÷±àдSQL*PLUS ½Å±¾£¬±£´æ³É .sql Îļþ¡£
2. ÉÏ´«sql ÎļþÖÁÓ¦ÓõÄsql Ŀ¼¡£
3. ×¢²áMethod ΪSQL*PLUS µÄConcurrent,²¢µ÷ÓÃ´Ë sql Îļþ.
SQL*PLUS Report µÄ¸ñʽ»¯·½·¨:
1. ¸Ä±äÁбêÌâ
COLUMN <×Ö¶ÎÃû»ò×ֶαðÃû> HEADING <±êÌâÃû>
Àý:
COLUMN LAST_NAME HEADING 'LAST NAME'
COLUMN SALARY HEADING 'MONTHLY SALARY'
COLUMN COMMISSION_PCT HEADING 'COMMISSION'
2. ÁбêÌâ×Ô¶¯ÕÛÐÐ
COLUMN <×Ö¶ÎÃû»ò×ֶαðÃû> HEADING <±êÌâÃû1-1|±êÌâÃû1-2>
Àý£º
COLUMN SALARY HEADING 'MONTHLY|SALARY'
COLUMN LAST_NAME HEADING 'LAST|NAME'
3. ¸Ä±ä±êÌâÏ»®Ï߸ñʽ£¨Format of underline£©
SET UNDERLINE
Àý£º
SET UNDERLINE =
/
4. ¸Ä±äÁеÄÏÔʾ¸ñʽ
COLUMN <×Ö¶ÎÃû»ò×ֶαðÃû> FORMAT <¸ñʽÃèÊö>
ÊýÖµÐ͸ñʽÃèÊöÓëto_numberº¯Êý»ù±¾Ò»Ö£¬Èç:
$99.990
ÆäËü¸ñʽÊý¾Ý¾ùÓÃA(n)À´ÉèÖÿí¶È,È磺
A10
Èç¹ûÓÐ×Ö·û³¬³ö10,Ôò»á×Ô¶¯ÕÛÐÐ. ³ý·ÇÄã×öÈçÏÂÉèÖà :
SET WRAP OFF
Ôò¶à³öµÄ×Ö·û»á±»½Øµô.
5. ¸´ÖÆ×ֶθñʽÉèÖÃ
COLUMN <Ä¿±ê×Ö¶ÎÃû> LIKE <À´Ô´×Ö¶ÎÃû> HEADING <±êÌâÃû>
Àý:
COLUMN COMMISSION_PCT LIKE SALARY HEADING BONUS
6. ²»ÏÔʾijһÁÐ
COLUMN <Ä¿±ê×Ö¶ÎÃû> NOPRINT
7. ÅÅÐòºó£¬Öظ´×ֶβ»ÏÔʾ(¼´·Ö×é
Ïà¹ØÎĵµ£º
ÎÒ˵µÄ²»¶¨Ìõ¼þÊÇÖ¸²éѯÌõ¼þµÄ¸öÊý²»¶¨¡£ÓÐʱһ¸ö£¬ÓÐʱÁ½¸ö£¬ÓÐʱºÃ¼¸¸ö¡£
Ê×ÏÈÎÒ·¢ÏÖ
select * from A where a='kkk' Óë
select * from A where a like 'kkk'
ÆäʵЧ¹ûÊÇÒ»Ñù£¬Ö»Òª like ºóÃæµÄ×Ö·û´®²»°üº¬Í¨Åä·û¡£ÕâÑùÒ»À´¾ÍºÜ·½±ãÁË¡£Æ©ÈçÓÐ
select * from A where a='KKK' and b='LLL'
ÓÐÁ½¸ö²éѯÌõ¼þ£¬ ......
protected void Button1_Click(object sender, EventArgs e)
{
string strsql = "select * from TreeViewTemp where parentID=0";
DataTable dt = db.GetDataTable(strsql);
StringWriter sw = new StringWriter();
//StreamWriter sw = new Strea ......
--
SQL Server Splitº¯Êý
--
Author:zc_0101
--
˵Ã÷£º
--
Ö§³Ö·Ö¸î·û¶à×Ö½Ú
--
ʹÓ÷½·¨
--
Select * from DBO.F_SQLSERVER_SPLIT('1203401230105045','0')
--
select * from DBO.F_SQLSERVER_SPLIT('abc1234a12348991234',' ......
ÎÒ¾³£ÎʵÄÒ»¸öÎÊÌâÊÇ£ºÄãÊÇÈçºÎÀ´À©Õ¹SQL DatabaseµÄ£¿ÓкܶàµÄ·½·¨¿ÉÒÔ×öµ½£¬±ÈÈçʹÓûº´æ£¬¹²Ïí»òÕßÓÃÆäËûµÄ¼¼Êõ½«Ñ¹Á¦´ÓÊý¾Ý¿âÊÍ·Å£¬µ«Êµ¼ÊÉÏÎÒÃÇûÓС£SQL Database´Ó¸ù±¾ÉÏÀ´ËµÊDz»¾ßÓÐÀ©Õ¹ÐԵģ¬ÎÒÃÇҲûÓÐħ·¨Ê¹ËüºöÈ»¾ßÓÐÀ©Õ¹ÐÔ¡£
ʲôÊÇÀ©Õ¹ÐÔ£¿
±ØÐë¾ßÓм¸Ï¼¸µã£º
ºáÏòÀ©Õ¹£º¸ü¶àµÄserver¿ÉÒÔ´øÀ´¸ü¸ßµÄÐÔÄÜ ......
ÔÎĵØÖ·£ºhttp://www.dingos.cn/index.php?topic=1688.0
OracleÓÐrownumÓÃÓÚ·ÃÎʱíÖÐÐкš£ÄÇôÔÚSQL ServerÖÐÊÇ·ñÓеÈЧµÄÄØ£¿»òÕßÔÚSQL ServerÖÐÈçºÎÊä³öÐкţ¿
-----------------------------------
ÔÚSQL ServerÖÐûÓÐÖ±½ÓµÈЧÓÚOracleµÄrownum
-----------------------------------
Ñϸñ˵À´£¬ÔÚ¹ØϵÊý¾Ý¿âÖУ¬± ......