oracle PL SQLѧϰ°¸Àý£¨Ò»£©
¡¾Ê¾Àý1.1¡¿ ²éѯ¹ÍÔ±±àºÅΪ7788µÄ¹ÍÔ±ÐÕÃûºÍ¹¤×Ê¡£
²½Öè1£ºÓÃSCOTT/TIGERÕË»§µÇ¼SQL*Plus¡£
²½Öè2£ºÔÚÊäÈëÇøÊäÈëÒÔϳÌÐò£º
/*ÕâÊÇÒ»¸ö¼òµ¥µÄʾÀý³ÌÐò*/
SET SERVEROUTPUT ON
DECLARE--¶¨Ò岿·Ö±êʶ
v_name VARCHAR2(10); --¶¨Òå×Ö·û´®±äÁ¿v_name
v_sal NUMBER(5); --¶¨ÒåÊýÖµ±äÁ¿v_sal
BEGIN --¿ÉÖ´Ðв¿·Ö±êʶ
SELECT ename,sal
INTO v_name,v_sal
from emp
WHERE empno=7788;
--ÔÚ³ÌÐòÖвåÈëµÄSQLÓï¾ä
DBMS_OUTPUT.PUT_LINE('7788ºÅ¹ÍÔ±ÊÇ£º'||v_name||'£¬¹¤×ÊΪ£º'||to_char(v_sal));
--Êä³ö¹ÍÔ±ÃûºÍ¹¤×Ê
END; --½áÊø±êʶ
²½Öè3£º°´Ö´Ðа´Å¥»òF5¿ì½Ý¼üÖ´ÐгÌÐò¡£
Êä³öµÄ½á¹ûÊÇ£º
7788ºÅ¹ÍÔ±ÊÇ£ºSCOTT£¬¹¤×ÊΪ£º3000
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
======================================================================================================================
¡¾Ê¾Àý2.1¡¿ ±äÁ¿µÄ¶¨ÒåºÍ³õʼ»¯¡£
ÊäÈëºÍÔËÐÐÒÔϳÌÐò£º
SET SERVEROUTPUT ON
DECLARE --ÉùÃ÷²¿·Ö±êʶ
v_job VARCHAR2(9);
v_count BINARY_INTEGER DEFAULT 0;
v_total_sal NUMBER(9,2) := 0;
v_date DATE := SYSDATE + 7;
c_tax_rate CONSTANT NUMBER(3,2) := 8.25;
v_valid BOOLEAN NOT NULL := TRUE;
BEGIN
v_job:='MANAGER';
--ÔÚ³ÌÐòÖи³Öµ
DBMS_OUTPUT.PUT_LINE(v_job);
--Êä³ö±äÁ¿v_jobµÄÖµ
DBMS_OUTPUT.PUT_LINE(v_count);
--Êä³ö±äÁ¿v_countµÄÖµ
DBMS_OUTPUT.PUT_LINE(v_date);
--Êä³ö±äÁ¿v
Ïà¹ØÎĵµ£º
SQL Server Extended Events£¨ÏÂÃæ¼ò³ÆXEvent£©ÊÇSQL Server 2008ÀïмӵÄʼþ´¦Àíϵͳ£¬ÓÃÀ´È¡´úSQL ServerÔ
ÏȵÄSQL TraceµÄ¸ú×Ù»úÖÆ¡£Ê¼þ´¦Àíϵͳ¶ÔÒ»¸ö¸´ÔÓ·þÎñÆ÷ϵͳµÄÅÅ´í£¬µ÷ÊÔÊǼ«Îª¹Ø¼üµÄ¡£ºÍSQL ServerÔÀ´µÄÊÂ
¼þ´¦ÀíϵͳÏà±È½Ï£¬XEvent¾ßÓÐÏÂÁеÄÓÅÊÆ£º
¡¡¡¡ÏûºÄ¸üÉÙµÄϵͳ×ÊÔ´£¬¸üÊÊÓÃÓÚÔÚ²úÆ··þÎñÆ÷É쵀 ......
sqlÈÕÆÚº¯Êý(ת)
[ 2007-8-23 16:33:00 | By: ²½ ]1.Ò»¸öÔµÚÒ»ÌìµÄ
Select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
2.±¾ÖܵÄÐÇÆÚÒ»
Select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)
3.Ò»ÄêµÄµÚÒ»Ìì
Select DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)
4.¼¾¶ÈµÄµÚÒ»Ìì
Select DATEADD(qq, DATEDIFF(qq,0,getdat ......
СµÜÏëÎʸöÎÊÌ⣬ÔÚSQL Server 2005ÉÏ£¬½¨Á¢Ö÷¼üµÄͬʱ¾Í»áĬÈÏÔÚÖ÷¼üÉÏÉèÖþ۴ØË÷Òý£¬ÄÇôÄÜ·ñÔÚÒ»¸ö×Ö¶ÎÉÏÉèÖÃÖ÷¼üºÍΨһÐÔË÷Òý£¨Unique£©£¬µ«ÊǰѾ۴ØË÷ÒýÉèÖõ½ÁíÒ»¸ö×Ö¶ÎÉÏ£¿
¾Ù¸ö¼òµ¥µÄÀý×Ó£¬±ÈÈçÎÒÓиö±í½ÐTableTest£¬±íÀïÓÐÁ½¸ö×ֶΣ¬id,date£¬±¾À´idÊÇÖ÷¼üµÄ£¬ÎÒÏÖÔÚÏë°Ñ¾Û´ØË÷ÒýÉèÖõ½date×Ö¶ÎÉÏ¡£
ÎÒÏÈɾ³ýÖ ......
OracleÖÐto_date()Óë24СʱÖƱíʾ·¨¼°mm·ÖÖÓµÄÏÔʾ£º
ÔÚʹÓÃOracleµÄto_dateº¯ÊýÀ´×öÈÕÆÚת»»Ê±£¬ºÜ¶àJava³ÌÐòÔ±Ò²Ðí»áºÍÎÒÒ»Ñù£¬Ö±¾õµÄ²ÉÓÓyyyy-MM-dd HH:mm:ss”µÄ¸ñʽ
×÷Ϊ¸ñʽ½øÐÐת»»£¬µ«ÊÇÔÚOracleÖлáÒýÆð´íÎ󣺓ORA 01810 ¸ñʽ´úÂë³öÏÖÁ½´Î”¡£È磺
to_date('2005-01-01 13:14:20 ......