SQL/PLUS
4£®Êý¾ÝÀàÐÍת»»º¯Êý
¡ñÒþʽת»»
¸³ÖµÊ±¿É½øÐеÄÒþʽת»»ÓÐ
VARCHAR2»òCHAR —¡µNUMBER
VARCHAR2»òCHAR —¡µDATE
NUMBER —¡µVARCHAR2
DATE —¡µVARCHAR2
±í´ïʽÖпɽøÐеÄÒþʽת»»ÓÐ
VARCHAR2»òCHAR —¡µNUMBER
VARCHAR2»òCHAR —¡µDATE
¡ñÏÔʽת»»
TO_CHAR(number|date[,’fm___’])°´¸ñʽ°ÑÊý×Ö»òÈÕÆÚת»»³ÉVARCHAR2
TO_NUMBER(char)½«Êý×Ö×Ö·û´®×ª»¯³ÉÊý×Ö
TO_DATE(char[,’fm___’])°´¸ñʽ°Ñ×Ö·û´®×ª»»³ÉÈÕÆÚ
5£®³£¹æº¯Êý
¡ñNVL(expression1,expression2)£ºÈç¹ûexpression1ÖÐÓпÕÖµ´æÔÚ½«Ëüת»¯³É
expression2掙歜
¡ñDECODE(columnname|expression,search1,result1[,search2,result2,…][,default])
Èç¹ûexpressionµÄÖµµÈÓÚsearch1£¬ÔòÏÔʾresult1£¬·ñÔò¼ÌÐøÏòϲéÕÒ¡£Èç¹ûËùÓеÄ
search¶¼²»Âú×㣬ÏÔʾdefaultÖµ¡£
6£®Ìæ»»±äÁ¿
¡ñ&£ºÈç¹ûÔÚ±äÁ¿Ç°Ê¹ÓÃ&·ûºÅ£¬ÔÚÖ´ÐÐSELECTÓï¾äʱ£¬ÏµÍ³»áÌáʾÓû§Ìṩ¸Ã±äÁ¿µÄ
Öµ¹æÔò£º
1)Ìæ»»±äÁ¿µÄÀàÐÍÊÇ×Ö·û£¬±ØÐëÓÃÒýºÅÒýÆðÀ´
2)ϵͳ»áÏÔʾÌæ»»±äÁ¿±»Ìæ»»µÄ¹ý³Ì
¡ñ&&£ºÈç¹ûÐèÒªÖظ´Ê¹ÓÃijÌæ»»±äÁ¿µÄÖµ¶ø²»ÒªÇóÓû§¶à´Î¼üÈ룬¿ÉÒÔÔÚËüµÚÒ»´Î³öÏÖ
ʱʹÓÃ&&×Ö·û¡£
¡ñDEFINE£ºDEFINE variable*value£º´´½¨Ò»¸öCHARÀàÐͱäÁ¿²¢¸øÓè³õʼֵ
DEFINE variable£ºÏÔʾ±äÁ¿µÄÃû³Æ£¬ÖµºÍÀàÐÍ
DEFINE£ºÏÔʾËùÓÐÓû§¶¨ÒåµÄ±äÁ¿
UNDEFINE variable£ºÏû³ý±äÁ¿¶¨Òå
¡ñACCEPT£ºACCEPT variable [datatype][FORMAT format][PROMPT text][HIDE]
°´Ö¸¶¨¸ñʽ´´½¨Öƶ¨ÀàÐ͵ıäÁ¿£¬²¢Öƶ¨Óû§Ìáʾ£¬ÌáʾÓ
Ïà¹ØÎĵµ£º
SQLÖÐDATEADDºÍDATEDIFFµÄÓ÷¨
ÈÕÆÚ:2008-07-17 ×÷Õß:ϲ騰С¶þ 來Ô´:PHPChina
ͨ³££¬妳ÐèÒª獲µÃ當Ç°ÈÕÆÚºÍ計ËãһЩÆäËûµÄÈÕÆÚ£¬ÀýÈ磬妳µÄ³ÌÐò¿ÉÄÜÐèÒªÅÐ斷Ò»個ÔµĵÚÒ»Ìì»òÕß×îááÒ»Ìì¡£妳們´ó²¿·ÖÈË´ó¸Å¶¼ÖªµÀÔõ樣°ÑÈÕÆÚ進ÐзָÄê ......
×î½ü¼¸ÖÜÒ»Ö±ÔÚ½øÐÐÊý¾Ý¿âÅàѵ£¬ÀÏʦ¾«Õ¿µÄ¼¼ÊõºÍÉú¶¯µÄ½²½âʹÎÒÊÜÒæ·Ëdz¡£ÎªÁËÈøü¶àµÄÐÂÊÖÊÜÒ棬ÎÒ³é¿Õ°ÑSQLÓï¾äÓÅ»¯²¿·Ö½øÐÐÁËÕûÀí£¬Ï£Íû´ó¼ÒÒ»Æð½ø²½¡£¡¡¡¡
¡¡¡¡Ò»¡¢²Ù×÷·ûÓÅ»¯¡¡¡¡
¡¡1¡¢IN ²Ù×÷·û ¡¡¡¡
¡¡¡¡ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊÇ±È½Ï ......
ÔÚSQL ServerÖÐʹÓÃNewID()·½·¨²úÉúËæ»ú¼¯
ÀýÈ翼ÊÔϵͳÖеÄËæ»ú³öÌâ
¸Õ¿ªÊ¼Ïëµ½µÄÊÇRandomÀà
µ«ÊÇRandomЧÂÊÓеãµÍ
ºóÀ´Ïëµ½ÁËÔÚÊý¾Ý¿âÀïµÄnewid()
ÓÚÊDzÉÓÃÁËϱ߷½·¨£º
select top 5 * from tablename order by newid()
Ôڴ˱ê¼ÇһϠ......
CREATE PROCEDURE dbo.UspOutputData
@tablename sysname
AS
declare @column varchar(1000)
declare @columndata varchar(1000)
declare @sql varchar(4000)
declare @xtype tinyint
declare @name sysname
declare @objectId int
declare @objectname sysname
declare @ident int
set nocount on
......
PL/SQLʵÀý·ÖÎö
µÚÎåÕÂ
1¡¢PL/SQLʵÀý·ÖÎö
1£©ÔÚ¡¾SQLPlus Worksheet¡¿ÖÐÖ±½ÓÖ´ÐÐÈçÏÂSQL´úÂëÍê³ÉÉÏÊö²Ù×÷¡£(´´½¨±í)
¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D
CREATE TABLE "SCOTT"."TESTTABLE" ("RECORDNUMBER" NUMBER(4) NOT NULL, "CURRENTDATE" DATE NOT NULL)
TABLESPACE "SYSTEM ......