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

PL/SQLʵÀý·ÖÎö

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"
2£©ÒÔadminÓû§Éí·ÝµÇ¼¡¾SQLPlus Worksheet¡¿£¬Ö´ÐÐÏÂÁÐSQL´úÂëÍê³ÉÏòÊý¾Ý±íSYSTEM.testableÖÐÊäÈë100¸ö¼Ç¼µÄ¹¦ÄÜ¡£
¨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
set serveroutput on
declare
maxrecords constant int:=100;
i int:=1;
begin
for i in 1..maxrecords loop
insert into SCOTT.testtable(recordnumber,currentdate)
values(i,sysdate);
end loop;
dbms_output.put_line('³É¹¦Â¼ÈëÊý¾Ý£¡');
commit;
end;
2¡¢ÔÚ¡¾SQLPlus Worksheet¡¿ÖÐÖ´ÐÐÏÂÁÐPL/SQL³ÌÐò£¬¸Ã³ÌÐò¶¨ÒåÁËÃûΪageµÄÊý×ÖÐͱäÁ¿£¬³¤¶ÈΪ3£¬³õʼֵΪ26¡£
¨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
declare
age number(3):=26;
begin
commit;
end;
3¡¢ÔÚ¡¾SQLPlus Worksheet¡¿ÖÐÖ´ÐÐÏÂÁÐPL/SQL³ÌÐò£¬¸Ã³ÌÐò¶¨ÒåÁËÃûΪpiµÄÊý×ÖÐͳ£Á¿£¬³¤¶ÈΪ9¡£
¨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
declare
pi constant number(9):=3.1415926;
begin
commit;
end;
4¡¢¸´ºÏÊý¾ÝÀàÐͱäÁ¿
ÏÂÃæ½éÉܳ£¼ûµÄ¼¸ÖÖ¸´ºÏÊý¾ÝÀàÐͱäÁ¿µÄ¶¨Òå¡£
1). ʹÓÃ%type¶¨Òå±äÁ¿
ΪÁËÈÃPL/SQLÖбäÁ¿µÄÀàÐͺÍÊý¾Ý±íÖеÄ×ֶεÄÊý¾ÝÀàÐÍÒ»Ö£¬Oracle 9iÌṩÁË%type¶¨Òå·½·¨¡£ÕâÑùµ±Êý¾Ý±íµÄ×Ö¶ÎÀàÐÍÐ޸ĺó£¬PL/SQL³ÌÐòÖÐÏàÓ¦±äÁ¿µÄÀàÐÍÒ²×Ô¶¯Ð޸ġ£
ÔÚ¡¾SQLPlus Worksheet¡¿ÖÐÖ´ÐÐÏÂÁÐPL/SQL³ÌÐò£¬¸Ã³ÌÐò¶¨ÒåÁËÃûΪmydateµÄ±äÁ¿£¬ÆäÀàÐͺÍtempuser.testtableÊý¾Ý±íÖеÄcurrentdate×Ö¶ÎÀàÐÍÊÇÒ»Öµġ£
¨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
Declare
mydate SYSTEM.testtable.currentdate%type;
begin
commit;
end;
2). ¶¨Òå¼Ç¼ÀàÐͱäÁ¿
ºÜ¶à½á¹¹»¯³ÌÐòÉè¼ÆÓïÑÔ¶¼ÌṩÁ˼ǼÀàÐ͵ÄÊý¾ÝÀàÐÍ£¬ÔÚPL/SQLÖУ¬Ò²Ö§³Ö½«¶à¸ö»ù±¾Êý¾ÝÀàÐÍÀ¦°óÔÚÒ»ÆðµÄ¼Ç¼Êý¾ÝÀàÐÍ¡£
ÏÂÃæµÄ³ÌÐò´úÂ붨ÒåÁËÃûΪmyrecordµÄ¼Ç¼ÀàÐÍ£¬¸Ã¼Ç¼ÀàÐÍÓÉÕûÊýÐ͵ÄmyrecordnumberºÍÈÕÆÚÐ͵Ämycurrentdate»ù±¾ÀàÐͱäÁ¿×é³É£¬srecordÊǸÃÀàÐ͵ıäÁ


Ïà¹ØÎĵµ£º

SQL´æ´¢¹ý³Ì·ÖÒ³Ëã·¨Ñо¿(Ö§³ÖǧÍò¼¶)

SQL´æ´¢¹ý³Ì·ÖÒ³Ëã·¨Ñо¿(Ö§³ÖǧÍò¼¶)
1.“¶íÂÞ˹´æ´¢¹ý³Ì”µÄ¸ÄÁ¼°æ
CREATE procedure pagination1
(@pagesize int, --Ò³Ãæ´óС£¬Èçÿҳ´æ´¢20Ìõ¼Ç¼
@pageindex int --µ±Ç°Ò³Âë)
as set nocount on
begin
declare @indextable table(id int identity(1,1),nid int) --¶¨Òå±í±äÁ¿
declare @PageL ......

SQL ÈÕÆÚ


MySQL Date º¯Êý
ÏÂÃæµÄ±í¸ñÁгöÁË MySQL ÖÐ×îÖØÒªµÄÄÚ½¨ÈÕÆÚº¯Êý£º
º¯ÊýÃèÊö
NOW()
·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼ä
CURDATE()
·µ»Øµ±Ç°µÄÈÕÆÚ
CURTIME()
·µ»Øµ±Ç°µÄʱ¼ä
DATE()
ÌáÈ¡ÈÕÆÚ»òÈÕÆÚ/ʱ¼ä±í´ïʽµÄÈÕÆÚ²¿·Ö
EXTRACT()
·µ»ØÈÕÆÚ/ʱ¼ä°´µÄµ¥¶À²¿·Ö
DATE_ADD()
¸øÈÕÆÚÌí¼ÓÖ¸¶¨µÄʱ¼ä¼ä¸ô
DATE_SUB()
´ÓÈÕÆÚ ......

һЩ²»´íµÄsqlÓï¾ä(ÃæÊÔ¿ÉÄÜÅöµ½Å¶£¡)

 Àý×Ó1)   Ò»¸ö±íTable_1  ÓÐÁ½¸ö×ֶΠ 
          id       number£¬  
          name   varchar2£¨7£©  
  & ......

½«±íÊý¾ÝÉú³ÉSQL½Å±¾µÄ´æ´¢¹ý³Ì

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 ......

Sql Server 2005 ÖеÄͬÒå´ÊÓë¸´ÖÆ

ÔÚ2005ÖÐÓÐͬÒå´ÊÓë¸´ÖÆµÄ¸ÅÄî
ͬÒå´ÊµÄÖ÷Òª×÷ÓÃÊÇ£º
        Ò»£ºË޶̶ÔÏóµÄÃû³Æ£¬¼õÉÙ¹¤×÷ÈËÔ±ÊéдµÄʱ¼ä£¬Ìá¸ßЧÂÊ¡£ÎÒÃÇÖªµÀ·ÃÎÊÊý¾Ý¿âÒ»¸ö¶ÔÏóµÄͨ³£×îÈ«µÄ¶ÔÏóÃû³ÆÊÇ£º·þÎñÆ÷Ãû³Æ¡£Êý¾Ý¿âÃû³Æ¡£¼Ü¹¹Ãû³Æ¡£¶ÔÏóÃû³Æ
        ¶þ£ºÍ¬²½Êý¾Ý¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ