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

PL/SQL ѧϰ±Ê¼Ç1

PL/SQL ²»¾ß±¸ÊäÈëÊä³öµÄÄÜÁ¦
µ«ÊÇ¿ÉÒÔÒÀ¿¿»·¾³À´Ö´ÐÐÊýÖµµÄÊäÈëÊä³ö¸øPL/SQL ¿é
SQLPLUS »·¾³ÓÃsubstitution variables ºÍ host(bind) variable À´´«ÈëÊýÖµ¸øPL/SQL¿é
substitution variable: such as a preceding ampersand  &a
host(bind) variable : such as a  preceding colon :x
Ìæ´ú±äÁ¿¿ÉÒÔ²»ÓÃÉùÃ÷£¬µ«ÊÇ»áÔÚÖ´ÐеÄʱºòÓÐÒ»¸ö½»»¥Ê½Ìáʾ
°ó¶¨±äÁ¿ÐèÒªÉùÃ÷²¢ÇÒ¸³ÖµµÄʱºòÓÃexecÓï¾ä
SQL> var df df
Usage: VAR[IABLE] [ <variable> [ NUMBER | CHAR | CHAR (n [CHAR|BYTE]) |
VARCHAR2 (n [CHAR|BYTE]) | NCHAR | NCHAR (n) |
NVARCHAR2 (n) | CLOB | NCLOB | REFCURSOR |
BINARY_FLOAT | BINARY_DOUBLE ] ]
SQL> var a number
SQL> exec :a :=123
PL/SQL procedure successfully completed.
SQL> edit
Wrote file afiedt.buf
1 declare
2 begin
3 dbms_output.put_line('result='||'&a'||:a);
4* end;
SQL> /
Enter value for a: i love u
old 3: dbms_output.put_line('result='||'&a'||:a);
new 3: dbms_output.put_line('result='||'i love u'||:a);
result=i love u123
PL/SQL procedure successfully completed.
SQL>


Ïà¹ØÎĵµ£º

SQLÓï¾äÓÅ»¯µÄÔ­Ôò

MysqlµÄÓÅ»¯Ô­Ôò1£º
1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£
ȱʡÇé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷Òý
Ï£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ
¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£Ò»°ãÀ´Ëµ£º
a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾­³£Óз¶Î§²éѯ£¨ > ,< £¬> =,< =£©ºÍorder by¡¢group by ......

Ìí¼ÓÊý¾ÝÔ´²¢ÅäÖÃÊý¾ÝÔ´Óësql ServerÉí·ÝÑé֤ģʽ

      ÔÚÊý¾Ý¿âÓ¦ÓóÌÐò·¢²¼Ê±£¬¿Í»§¶Ë°²×°ÔÚ¾ÖÓòÍøÖеÄÖ÷»úAÉÏ£¬sql server °²×°ÔڸþÖÓòÍøµÄÖ÷»úBÉÏ¡£¿Í»§¶ËÈí¼þÖаüº¬ÓÐËüÒªÁ¬½ÓµÄÊý¾Ý¿âµÄÐÅÏ¢¡£ÈçÊý¾ÝÔ´£¬·þÎñÆ÷Ãû³Æ£¬Êý¾Ý¿âµÈ£¬ÊµÀý£ºdata source=SQLOLEDB;SERVER=DongZi\sqlExpress;uid=sa;pwd=123;database=MachineRoom
¡£ÄÇôÎÒÃÇÔÚÖ÷» ......

SQL ÓïÑÔµÄËÄ´ó×é³É²¿·Ö DQL DML DDL DCL

SQL(Structure Query Language)ÓïÑÔÊÇÊý¾Ý¿âµÄºËÐÄÓïÑÔ¡£
SQLµÄ·¢Õ¹ÊÇ´Ó1974Ä꿪ʼµÄ£¬Æä·¢Õ¹¹ý³ÌÈçÏ£º
1974Äê-----ÓÉBoyceºÍChamberlinÌá³ö£¬µ±Ê±³ÆSEQUEL¡£
1976Äê-----IBM¹«Ë¾µÄSanjaseÑо¿ËùÔÚÑÐÖÆRDBMS SYSTEM Rʱ¸ÄΪSQL¡£
1979Äê-----ORACLE¹«Ë¾·¢±íµÚÒ»¸ö»ùÓÚSQLµÄÉÌÒµ»¯RDBMS²úÆ·¡£
1982Äê-----IBM¹«Ë¾³ö°æµ ......

¡¾¸Äб¹éÕý¡¿ sqlserver sql ·ÖÒ³Óï¾ä

      ÔÚGoogleÉÏʹÓÓsql ·ÖÒ³”¹Ø¼ü×Ö½øÐÐËÑË÷£¬¼¸ºõËùÓеĴ𰸶¼ÊÇÄÇÈýÌõ¡£Æä¶þЧÂÊ×î¸ß£¬ÆäÈýʹÓÃÓα꣬ЧÂÊ×î²î¡£
      ÏÂÃæÊÇÄÇÈýÖÖ·½·¨ £¨²åÈë´úÂëûÓÐsqlÑ¡Ï
·½·¨1£º
ÊÊÓÃÓÚ SQL Server 2000/2005
SELECT TOP Ò³´óС *
from table1
WHERE ......

Çå³ýSQL SERVER Êý¾Ý¿âÈÕÖ¾

  1.Çå¿ÕÈÕÖ¾  
  DUMP     TRANSACTION     ¿âÃû     WITH     NO_LOG          
   
  2.½Ø¶ÏÊÂÎñÈÕÖ¾£º  
  BACKUP   LOG   Êý¾Ý¿âÃû   WITH   NO_LOG  
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ