sql´óÈ«³¬Ïêϸ
SQL ÃüÁî
Õⲿ·Ö°üº¬ÄÇЩ PostgreSQL Ö§³ÖµÄ SQL ÃüÁîµÄÐÅÏ¢£®ÕâÀïµÄ "SQL" ¾ÍÊǸÃÓïÑÔͨ³£µÄº¬Ò壻 ÿÌõÃüÁîµÄÓë±ê×¼ÓйصļæÈÝÐÔµÄÐÅÏ¢¿ÉÒÔÔÚÏà¹ØµÄ²Î¿¼Ò³ÖÐÕÒµ½£®
Table of Contents
ABORT -- Í˳öµ±Ç°ÊÂÎñ
ALTER GROUP -- Ïò×éÖÐÔö¼ÓÓû§»ò´Ó×éÖÐɾ³ýÓû§
ALTER USER -- ¸Ä±äÊý¾Ý¿âÓû§Õʺţ®
ANALYZE -- ÊÕ¼¯ÓëÊý¾Ý¿âÓйصÄͳ¼Æ
BEGIN -- ¿ªÊ¼Ò»¸öÊÂÎñ¿é
CHECKPOINT -- Ç¿ÖÆÒ»¸öÊÂÎñÈÕÖ¾¼ì²éµã
CLOSE -- ¹Ø±ÕÒ»¸öÓαê
CLUSTER -- ¸ù¾ÝÒ»¸öË÷Òý¶Ôij¸ö±í¼¯´Ø
COMMENT -- ¶¨Òå»òÕ߸ıäÒ»¸ö¶ÔÏóµÄÆÀ×¢
COMMIT -- Ìá½»µ±Ç°ÊÂÎñ
COPY -- ÔÚ±íºÍÎļþÖ®¼ä¿½±´Êý¾Ý
CREATE AGGREGATE -- ¶¨ÒåÒ»¸öеľۼ¯º¯Êý
CREATE CONSTRAINT TRIGGER -- ¶¨ÒåÒ»¸öеÄÔ¼Êø´¥·¢Æ÷
CREATE DATABASE -- ´´½¨ÐÂÊý¾Ý¿â
CREATE FUNCTION -- ¶¨ÒåÒ»¸öк¯Êý
CREATE GROUP -- ¶¨ÒåÒ»¸öеÄÓû§×é
CREATE INDEX -- ¶¨ÒåÒ»¸öÐÂË÷Òý
CREATE LANGUAGE -- ¶¨ÒåÒ»ÖÖеĹý³ÌÓïÑÔ
CREATE OPERATOR -- ¶¨ÒåÒ»¸öеIJÙ×÷·û
CREATE RULE -- ¶¨ÒåÒ»¸öеÄÖØÐ´¹æÔò
CREATE SEQUENCE -- ´´½¨Ò»¸öеÄÐòÁз¢ÉúÆ÷
CREATE TABLE -- ¶¨ÒåÒ»¸öбí
CREATE TABLE AS -- ´ÓÒ»Ìõ²éѯµÄ½á¹ûÖд´½¨Ò»¸öбí
CREATE TRIGGER -- ¶¨ÒåÒ»¸öеĴ¥·¢Æ÷
CREATE TYPE -- ¶¨ÒåÒ»¸öеÄÊý¾ÝÀàÐÍ
CREATE USER -- ´´½¨Ò»¸öеÄÊý¾Ý¿âÓû§ÕÊ»§
CREATE VIEW -- ¶¨ÒåÒ»¸öÊÓͼ
DECLARE -- ¶¨ÒåÒ»¸öÓαê
DELETE -- ɾ³ýÒ»¸ö±íÖеÄÐÐ
DROP AGGREGATE -- ɾ³ýÒ»¸öÓû§¶¨ÒåµÄ¾Û¼¯º¯Êý
DROP DATABASE -- ɾ³ýÒ»¸öÊý¾Ý¿â£®
DROP FUNCTION -- ɾ³ýÒ»¸öÓû§¶¨ÒåµÄº¯Êý
DROP GROUP -- ɾ³ýÒ»¸öÓû§×é
DROP INDEX -- ɾ³ýÒ»¸öË÷Òý
DROP LANGUAGE -- ɾ³ýÒ»¸öÓû§¶¨ÒåµÄ¹ý³ÌÓïÑÔ
DROP OPERATOR -- ɾ³ýÒ»¸öÓû§¶¨Òå²Ù×÷·û
DROP RULE -- ɾ³ýÒ»¸öÖØÐ´¹æÔò
DROP SEQUENCE -- ɾ³ýÒ»¸öÐòÁÐ
DROP TABLE -- ɾ³ýÒ»¸ö±í
DROP TRIGGER -- ɾ³ýÒ»¸ö´¥·¢Æ÷¶¨Ò壮
DROP TYPE -- ɾ³ýÒ»¸öÓû§¶¨ÒåÊý¾ÝÀàÐÍ
DROP USER -- ɾ³ýÒ»¸öÊý¾Ý¿âÓû§ÕʺÅ
DROP VIEW -- ɾ³ýÒ»¸öÊÓͼ
END -- Ìá½»µ±Ç°µÄÊÂÎñ
EXPLAIN --&nb
Ïà¹ØÎĵµ£º
Èý¡¢Ç¶Ì×±íµÄʹÓ÷½·¨
1¡¢½«Ç¶Ì×±í¶¨ÒåΪPL/SQLµÄ³ÌÐò¹¹Ôì¿é
TYPE type_name IS TABLE OF element_type[NOT NULL];
ÈçÏÂÀýËùʾ£º
DECLARE
-- Define a nested table of variable length strings.
TYPE card_table IS TABLE OF VARCHAR2(5 CHAR);
-- Declare and initialize a n ......
ORACLE 10GµÄ¼¯ºÏAPI
¼¯ºÏAPI·½·¨×îÔçÊÇÔÚORACLE 8IÖÐÒýÈëµÄ¡£¼¯ºÏAPIÌṩÁ˼ò»¯·ÃÎʼ¯ºÏµÄ·½·¨¡£ÔÚORACLE 10GÒÔǰ£¬ÕâЩ·½·¨È·Êµ¼ò»¯Á˶Լ¯ºÏµÄ·ÃÎÊ¡£µ«ÊÇ£¬²¢²»ÊÇ·ÇÒªÇóÕÆÎÕÕâЩ·½·¨²»¿É¡£´ÓORACLE 9IµÄINDEX-BY±íµ½ORACLE 10GµÄÁªºÏÊý×éµÄת»»£¬Ê¹ËüÃdzÉΪ±ØÐëÕÆÎյķ½·¨¡£
ÏÂÃæÊÇÎÒ´ÓÊéÉÏժ¼ÏµÄһР......
×ܽáÒ»ÏÂSQLÓï¾äÖÐÒýºÅ(')¡¢quotedstr()¡¢('')¡¢format()ÔÚSQLÓï¾äÖеÄÓ÷¨ÒÔ¼°SQLÓï¾äÖÐÈÕÆÚ¸ñʽµÄ±íʾ(#)¡¢('')
ÔÚDelphiÖнøÐÐ×Ö·û±äÁ¿Á¬½ÓÏà¼Óʱµ¥ÒýºÅÓÃ('''),ÓÖÒýºÅÓÃ('''')±íʾ
Ê×Ïȶ¨Òå±äÁ¿
var
AnInt:integer=123;//ΪÁË·½±ãÔڴ˶¼¸øËüÃǸ³³õÖµ¡£ËäÈ»¿ÉÄÜÔÚÒý¸³³õÖµÔÚijЩÇé¿öϲ»¶Ô
AnIntStr:string='456'; ......
ORACLE SQLÓï¾äÓÅ»¯×ܽá
1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, Ä ......
Êý¾Ý¿âÖÐÖ÷¼üºÍÍâ¼ü
(1)×÷ÓÃ
¼òµ¥ÃèÊö£º
Ö÷¼üÊǶԱíµÄÔ¼Êø£¬±£Ö¤Êý¾ÝµÄΨһÐÔ£¡
Íâ¼üÊǽ¨Á¢±íÓÚ±íÖ®¼äµÄÁªÏµ£¬·½±ã³ÌÐòµÄ±àд£¡
(2)Éè¼ÆÔÔò
Ö÷¼üºÍÍâ¼üÊǰѶà¸ö±í×é֯Ϊһ¸öÓÐЧµÄ¹ØÏµÊý¾Ý¿âµÄÕ³ºÏ¼Á¡£Ö÷¼üºÍÍâ¼üµÄÉè¼Æ¶ÔÎïÀíÊý¾Ý¿âµÄÐÔÄܺͿÉÓÃÐÔ¶¼ÓÐמö¶¨ÐÔµÄÓ°Ïì¡£
±ØÐ뽫Êý¾Ý¿âÄ£Ê ......