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

PostgreSQLºÍOracleÓ÷¨ÉϵÄÒ»Ð©Çø±ð

£¨1 £© ×¢ÒâÔö¼ÓÔ¼ÊøÊ±µÄд·¨£¬ºÍORACLE ÂÔÓв»Í¬
Oracle £º
ALTER TABLE SCHEMA.PREFIX_INFO ADD (
CONSTRAINT PK_PREFIX_INFO PRIMARY KEY (INFO_ID));
PostgresQL £º
alter table schema.prefix_info add constraint prefix_info_pkey primary key(info_id);
£¨2 £©ÏµÍ³Ä¬ÈϵÄ×î´óÖµÓëORACLE ²»Í¬
Oracle £º
CREATE SEQUENCE PREFIX_INFO_SEQUENCE
INCREMENT BY 1
START WITH 582
MINVALUE 1
MAXVALUE 9999999999999999999999999999
NOCYCLE
CACHE 20
NOORDER;
PostgresQL £º
CREATE SEQUENCE schema.prefix_info_sequence
increment 1
minvalue 1
maxvalue 9223372036854775807
start 582
cache 20;
£¨3 £©PostgresQL ÖÐµÄ || Óà ·¨ÓëÆäËûÊý¾Ý¿â²»Í¬£º
select a|| b from table1;
µ±a »òb ÆäÖÐÒ»¸öΪnull ʱ£¬ ¸Ã²éѯ·µ»Ønull £¬
£¨4 £©PostgresQL ÖÐûÓÐconcat º¯Êý£¬ÇÒÓÉÓÚ|| Ó÷¨µÄÎÊÌ⣬ÎÞ·¨Ê¹ÓÃ|| Ìæ»»£¬½â¾ö ·½·¨ÎªÔÚpublic schema Öд´½¨º¯Êýconcat
create or replace function concat(text, text)
returns text as
$body$select coalesce($1,'') || coalesce($2,'')$body$
language 'sql' volatile;
alter function concat(text, text) owner to postgres;
-- ÎÞÐèÌØÊâÊÚȨ¼´¿ÉÔÚÆäËûschema ÖÐʹÓÃ
£¨4 £©PostgresQL ÖÐûÓÐdual ÐéÄâ±í£¬Îª±£ Ö¤³ÌÐò¼æÈÝÐÔ£¬¿É´´½¨Î±ÊÓͼ£¨view £©Ìæ´ú£º
CREATE OR REPLACE VIEW dual AS
SELECT NULL::"unknown"
WHERE 1 = 1;
ALTER TABLE dual OWNER TO postgres;
GRANT ALL ON TABLE dual TO postgres;
GRANT SELECT ON TABLE dual TO public;
±ØÐëÊÚȨpublic ÒÔselect Ȩ ÏÞ
£¨5 £©¹ØÁª²éѯÓ÷¨Çø±ð
ORACLE:
¼òµ¥ÍâÁ¬½Ó£º
SELECT COUNT(DISTINCT(A.COL1)) AS RCOUNT from
SCHEMA.PREFIX_TABLE1 A,SCHEMA.PREFIX_TABLE2 B
WHERE 1 = 1
AND A.COL2 = B.COL2(+)
AND A.COL3 > 0
AND A.COL4 = '1'
³¬¼¶±ä̬ÍâÁ¬½Ó£º
SELECT COUNT(DISTINCT(A.COL1)) AS RCOUNT from
SCHEMA.PREFIX_TABLE1 A,SCHEMA.PREFIX_TABLE2 B,SCHEMA.PREFIX_TABLE3 C,SCHEMA.PREFIX_TABLE4 D
WHERE 1 = 1
AND A.COL2 = B.COL2
AND A.COL3 = C.COL3(+)
AND A.COL4 = D.COL4(+)
AND A.COL5 > 0
AND A.COL6 = '1'
POSTGRESQL:
¼òµ¥ÍâÁ¬½Ó£º
select count(distinct(a.col1)) as rcount from
schema.prefix_table1 a left ou


Ïà¹ØÎĵµ£º

oracle¼ì²âËø£¬ÊÍ·ÅËø

¼ì²âËø£º
SELECT A.OWNER,
A.OBJECT_NAME,
B.XIDUSN,
B.XIDSLOT,
B.XIDSQN,
B.SESSION_ID,
B.ORACLE_USERNAME,
B.OS_USER_NAME,
B.PROCESS,
B.LOCKED_MODE,
C.MACHINE,
C.STATUS,
C.SERVER,
C.SID,
C.SERIAL#,
C.PROGRAM
from ALL_OBJECTS A,
V$LOCKED_OBJECT B,
SYS.GV_$SESSION C
WHERE ( A.OBJE ......

oracleÐòÁÐÉú³ÉÆ÷(sequence)ʹÓõÄÒ»µãСעÒâ

ÓÐÈËÓöµ½Õâôһ¸öÎÊÌ⣬·ÃÎÊÒ»¸öÐòÁÐÔõô³ö´íÁË£¬´íÎóÈçÏ£º ORA-08002: ÐòÁÐ SEQ_GX.CURRVAL ÉÐδÔڴ˻ỰÖж¨Òå ÕâÊÇÒòΪÔÚÒ»¸öеĻỰÖУ¬ÐòÁÐÐèÒª³õʼ»¯£¬Ò²¾ÍÊÇͨ¹ý.NEXTVALÀ´Íê³ÉÐòÁеijõʼ»¯¡£ ²âÊÔÈçÏ£º Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 Connected as crmii SQL> SQ ......

oracle²éѯÁ·Ï°

empÔ±¹¤±í
(empnoÔ±¹¤ºÅ/enameÔ±¹¤ÐÕÃû/job¹¤×÷/mgrÉϼ¶±àºÅ/hiredateÊܹÍÈÕÆÚ/salн½ð/commÓ¶½ð/deptno²¿ÃűàºÅ)
------1.Ñ¡Ôñ²¿ÃÅ30ÖеÄËùÓÐÔ±¹¤.
select ename
from emp
where deptno = 30;
------2.ÁгöËùÓаìÊÂÔ±(CLERK)µÄÐÕÃû£¬±àºÅºÍ²¿ÃűàºÅ.
select ename,empno,deptno
from emp
where job='CLERK';
--- ......

Oracle Data Gurad ÀíÂÛ֪ʶ


RAC£¬ Data Gurad£¬ Stream ÊÇOracle ¸ß¿ÉÓÃÐÔÌåϵÖеÄÈýÖÖ¹¤¾ß£¬Ã¿¸ö¹¤¾ß¼´¿ÉÒÔ¶ÀÁ¢Ó¦Óã¬Ò²¿ÉÒÔÏ໥ÅäºÏ¡£ ËûÃǸ÷×ԵIJàÖØµã²»Í¬£¬ÊÊÓó¡¾°Ò²²»Í¬¡£
RAC ËüµÄÇ¿ÏîÔÚÓÚ½â¾öµ¥µã¹ÊÕϺ͸ºÔؾùºâ£¬Òò´ËRAC ·½°¸³£ÓÃÓÚ7*24 µÄºËÐÄϵͳ£¬µ«RAC ·½°¸ÖеÄÊý¾ÝÖ»ÓÐÒ»·Ý£¬¾¡¹ ......

ORACLEÔö¼Ó±í¿Õ¼ä

²é¿´ËùÓбí¿Õ¼äʹÓÃÇé¿ö 
SELECT UPPER(F.TABLESPACE_NAME) "±í¿Õ¼äÃû",
       D.TOT_GROOTTE_MB "±í¿Õ¼ä´óС(M)",
       D.TOT_GROOTTE_MB - F.TOTAL_BYTES "ÒÑʹÓÿռä(M)",
       TO_CHAR(ROUND((D.TOT_GROOTTE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ