¡¾×ª¡¿sql½âÎö²½Ö裬Ӳ½âÎöºÍÈí½âÎö
ÎÒÃǶ¼ÖªµÀÔÚOracleÖÐÿÌõSQLÓï¾äÔÚÖ´ÐÐ֮ǰ¶¼ÐèÒª¾¹ý½âÎö£¬ÕâÀïÃæÓÖ·ÖΪÈí½âÎöºÍÓ²½âÎö¡£ÔÚOracleÖдæÔÚÁ½ÖÖÀàÐ͵ÄSQLÓï¾ä£¬Ò»ÀàΪ
DDLÓï¾ä£¨Êý¾Ý¶¨ÒåÓïÑÔ£©£¬ËûÃÇÊÇ´ÓÀ´²»»á¹²ÏíʹÓõģ¬Ò²¾ÍÊÇÿ´ÎÖ´Ðж¼ÐèÒª½øÐÐÓ²½âÎö¡£»¹ÓÐÒ»Àà¾ÍÊÇDMLÓï¾ä£¨Êý¾Ý²Ù×ÝÓïÑÔ£©£¬ËûÃÇ»á¸ù¾ÝÇé¿öÑ¡Ôñ
Ҫô½øÐÐÓ²½âÎö£¬ÒªÃ´½øÐÐÈí½âÎö¡£
DML:INSERT,UPDATE,DELETE,SELECT
DDL:CREATE,DROP,ALTER
SQLÓï¾äµÄ½âÎö²½Ö裬µ±Ò»ÌõSQLÓï¾ä´Ó¿Í»§¶Ë½ø³Ì´«µÝµ½·þÎñÆ÷¶Ë½ø³Ìºó£¬ÐèÒªÖ´ÐÐÈçϲ½Ö裺
1ÔÚ¹²Ïí³ØÖÐËÑË÷ SQL Óï¾äµÄÏÖÓи±±¾
2ÑéÖ¤ SQL Óï¾äµÄÓï·¨ÊÇ·ñ׼ȷ
3Ö´ÐÐÊý¾Ý×Öµä²éÕÒÀ´ÑéÖ¤±íºÍÁеĶ¨Òå
4»ñÈ¡¶ÔÏóµÄ·ÖÎöËøÒÔ±ãÔÚÓï¾äµÄ·ÖÎö¹ý³ÌÖжÔÏóµÄ¶¨Òå²»»á¸Ä±ä
5¼ì²éÓû§·ÃÎÊÒýÓ÷½°¸¶ÔÏóµÄȨÏÞ
6È·¶¨Óï¾äµÄ×î¼ÑÖ´Ðмƻ®
6Óï¾äºÍÖ´Ðмƻ®ÔØÈë¹²ÏíµÄ SQL Çø
ÔÀ´£¬ÎÒÈÏΪӲ½âÎö¾ÍÊÇÉÏÃ漸¸ö²½Öè¡£Ïà¶ÔÓÚÓ²½âÎö£¬Èí½âÎöµÄ²½Öè¾ÍÊÇÉÏÃæµÚÒ»²½ÕÒµ½ÏÖÓÐSQLÓï¾äµÄ¸±±¾ºó£¬Ö»ÐèÒªÑéÖ¤Óû§ÊÇ·ñÓÐȨÏÞÖ´ÐоÍÊÇÁË£¬ÕâÑùÊ¡ÂÔÉÏÃæºÃ¼¸¸ö²½Ö裬Ïà¶ÔÓ²½âÎöÀ´ËµÐÔÄÜ¿ªÏú¾Í·Ç³£Ð¡ÁË¡£
ºóÀ´²ÅÖªµÀÉÏÃæµÄÕæÕýµÄ½âÎö²½Öè²»ÊÇÕâÑùµÄ¡£
ÊÂʵÉÏ£¬ÔÚOracleÖÐSQLÓï¾äµÄ½âÎö²½ÖèÈçÏ£º
1¡¢ Óï·¨¼ì²â¡£ÅжÏÒ»ÌõSQLÓï¾äµÄÓï·¨ÊÇ·ñ·ûºÏSQLµÄ¹æ·¶£¬±ÈÈçÖ´ÐУºSQL> selet * from emp;ÎÒÃǾͿÉÒÔ¿´³öÓÉÓÚSelect¹Ø¼ü×ÖÉÙÁËÒ»¸ö“c”£¬ÕâÌõÓï¾ä¾ÍÎÞ·¨Í¨¹ýÓï·¨¼ìÑéµÄ²½ÖèÁË¡£
2¡¢ ÓïÒå¼ì²é¡£Óï·¨ÕýÈ·µÄSQLÓï¾äÔÚ½âÎöµÄµÚ¶þ¸ö²½Öè¾ÍÊÇÅжϸÃSQLÓï¾äËù·ÃÎÊµÄ±í¼°ÁÐÊÇ·ñ׼ȷ£¿Óû§ÊÇ·ñÓÐȨÏÞ·ÃÎÊ»ò¸ü¸ÄÏàÓ¦µÄ±í»òÁУ¿
±ÈÈçÈçÏÂÓï¾ä£º
SQL> select * from emp;
select * from emp
*
ERROR at line 1:
ORA-00942: table or view does not exist
ÓÉÓÚ²éѯÓû§Ã»Óпɹ©·ÃÎʵÄemp¶ÔÏó£¬Òò´Ë¸ÃSQLÓï¾äÎÞ·¨Í¨¹ýÓïÒå¼ì²é¡£
3¡¢ ¼ì²é¹²Ïí³ØÖÐÊÇ·ñÓÐÏàͬµÄÓï¾ä´æÔÚ¡£¼ÙÈçÖ´ÐеÄSQLÓï¾äÒѾÔÚ¹²Ïí³ØÖдæÔÚͬÑùµÄ¸±±¾£¬ÄÇô¸ÃSQLÓï¾ä½«»á±»Èí½âÎö£¬Ò²¾ÍÊÇ¿ÉÒÔÖØÓÃÒѽâÎö¹ýµÄÓï¾äµÄÖ´Ðмƻ®ºÍÓÅ»¯·½°¸£¬¿ÉÒÔºöÂÔÓï¾ä½âÎö¹ý³ÌÖÐ×îºÄ·Ñ×ÊÔ´µÄ²½Ö裬ÕâÒ²ÊÇÎÒÃÇΪʲôһֱǿµ÷±ÜÃâÓ²½âÎöµÄÔÒò¡£
Õâ¸ö²½ÖèÓÖ¿ÉÒÔ·ÖΪÁ½¸ö²½Ö裺
£¨1¡¢£©ÑéÖ¤SQLÓï¾äÊÇ·ñÍêÈ«Ò»Ö¡£
ÔÚ
Õâ¸ö²½ÖèÖУ¬Oracle½«»á¶Ô´«µÝ½øÀ´µÄSQLÓï¾äʹÓÃHASHº¯ÊýÔËËãµÃ³öHASHÖµ£¬ÔÙÓë¹²Ïí³ØÖÐÏÖÓÐÓï¾äµÄHASHÖµ½øÐбȽϿ´ÊÇ·ñÒ»Ò»¶ÔÓ¦¡£ÏÖ
ÓÐÊý¾Ý¿âÖÐSQLÓï¾äµÄHASHÖµÎÒÃÇ¿É
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
use Tempdb
go
if object_ID('fn_ACITEncryption') is not null
drop function fn_ACITEncryption
go
create function fn_ACITEncryption
(
@Str nvarchar(4000),--¼ÓÃܵÄ×Ö·û´®
@Flag bit=1,--1¡¢¼ÓÃÜ 0¡¢½âÃÜ
@Key nvarchar(50)--ÃÜÎÄ
)
returns nvarchar(4000)--這Àï¿É轉換 ......
SQL°´ÕÕÈÕ¡¢ÖÜ¡¢Ô¡¢Äêͳ¼ÆÊý¾Ý ÊÕ²Ø
ÎÄÕ²ο¼£ºhttp://www.cnblogs.com/wenbhappy/archive/2008/07/02/1233660.html
Èç:
±í:consume_record
×Ö¶Î:consume (moneyÀàÐÍ)
date (datetimeÀàÐÍ)
ÇëÎÊÔõôдËÄÌõsqlÓï¾ä·Ö±ð°´ÈÕ,°´ÖÜ,°´ÔÂ,°´¼¾Í³¼ÆÏû·Ñ×ÜÁ¿.
Èç:1ÔÂ 1200Ô ......
¡¾1¡¿
create procedure proc_pager1
( @pageIndex int, -- ҪѡÔñµÚXÒ³µÄÊý¾Ý
@pageSize int -- ÿҳÏÔʾ¼Ç¼Êý
)
AS
BEGIN
declare @sqlStr varchar(500)
set @sqlStr='select top '+con ......
Ò»¡¢±³¾°½éÉÜ
¡¡¡¡
¡¡¡¡½á¹¹»¯²éѯÓïÑÔ(Structured Query Language£¬¼ò³ÆSQL)ÊÇÓÃÀ´·ÃÎʹØϵÐÍÊý¾Ý¿âÒ»ÖÖͨÓÃÓïÑÔ£¬ÊôÓÚµÚËÄ´úÓïÑÔ£¨4GL£©£¬ÆäÖ´ÐÐÌصãÊǷǹý³Ì»¯£¬¼´²»ÓÃÖ¸Ã÷Ö´ÐеľßÌå·½·¨ºÍ;¾¶£¬¶øÊǼòµ¥µØµ÷ÓÃÏàÓ¦Óï¾äÀ´Ö±½ÓÈ¡µÃ½á¹û¼´¿É¡£ÏÔÈ»£¬ÕâÖÖ²»¹Ø×¢ÈκÎʵÏÖϸ½ÚµÄÓïÑÔ¶ÔÓÚ¿ª·¢ÕßÀ´ËµÓÐ׿«´óµÄ±ãÀû¡£È»¶ø£¬Ó ......