ORACLEÊý¾Ý¿â¶ÔÏó——ͬÒå´Ê¡¢ÐòÁС¢ÊÓͼ
ORACLEÊý¾Ý¿â¶ÔÏó
——ͬÒå´Ê¡¢ÐòÁС¢ÊÓͼ
ͬÒå´Ê£ºÍ¬Òå´ÊÊÇÏÖÓжÔÏóµÄ±ðÃû
¼ò»¯SQLÓï¾ä
Òþ²Ø¶ÔÏóµÄÃû³ÆºÍËùÓÐÕß
Ìṩ¶Ô¶ÔÏóµÄ¹«¹²·ÃÎÊ
ͬÒå´Ê·ÖΪ˽ÓÐͬÒå´ÊºÍ¹«ÓÐͬÒå´Ê
˽ÓÐͬÒå´ÊÖ»ÄÜÔÚÆäģʽÄÚ·ÃÎÊ£¬ÇÒ²»ÄÜÓ뵱ǰģʽµÄ¶ÔÏóͬÃû¡£
¹«ÓÐͬÒå´Ê¿É±»ËùÓеÄÊý¾Ý¿âÓû§·ÃÎÊ¡£
ÒÔ SYS Óû§µÇ¼
SQL> CONNECT SYS/SYS AS SYSDBA;
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as SYS
´´½¨Ë½ÓÐͬÒå´Ê
SQL> CREATE SYNONYM synemp FOR SCOTT.emp;
Synonym created
SQL> select * from synemp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782
Ïà¹ØÎĵµ£º
1
2
3
×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7
½¨Á¢±í¿Õ¼ä
8
9
CREATE TABLESPACE data01
10
DATAFILE '/oracle/oradata/d ......
¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓëoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£´ó¶àÇé¿ö¶¼¿ÉÒÔÓÃOracleÊý¾Ýµ¼Èëµ¼³öÍê³ÉÊý¾ÝµÄ±¸·ÝºÍ»¹Ô£¨²»»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£©¡£
¡¡¡¡OracleÓиöºÃ´¦£¬ËäÈ»ÄãµÄµçÄÔ²»ÊÇ·þÎñÆ÷£¬µ«ÊÇÄã×°ÁËoracle¿Í»§¶Ë£¬²¢½¨Á¢ÁËÁ¬½Ó £¨Í¨¹ýnet8 assistantÖб¾µØ——>·þÎñÃüÃû Ìí¼ÓÕýÈ·µÄ·þÎñÃüÃû
¡¡¡¡Æ ......
http://tech.163.com/05/0701/10/1NIODMQS00091589.html
ÒòΪÔÚPL/SQL Öв¢Ã»ÓÐÊý×é.
ÕâÊÇż²é×ÊÁÏÕҵķ¶ÀýºÍ×Ô¼ºÐ´µÄ·¶ÀýÀ´½âÊÍÈçºÎÔÚPL/SQL ÖÐʹÓÃÊý×é. Ò²ÐíºÜ¶àÈËÒÑÖªµÀ, ²»¹ý¾ÍÊÇÈò»ÖªµÀµÄÅóÓÑÃÇÁ˽âһϰɡ£
----------------------
µ¥Î¬Êý×é
------------------------
DECLARE
TYPE
emp_ssn_array IS TA ......
RedHat Linux°²×°Oracle10g(ͼÎÄÏê½â ½Ì³Ì)
http://winie.javaeye.com/blog/405120
¹Ø¼ü×Ö: redhat linux°²×°oracle10g(ͼÎÄÏê½â ½Ì³Ì)
Áí£¬±¾ÈËÓÐWordµç×ÓÎĵµ¸ñʽ£¬ÈçÐèÒª£¬ÇëÁªÏµ±¾ÈË£ºasima127@gmail.com
1
°²×°RedHat Enterprise Linux 3 ......
Hey all,
Since there seems to be a fair bit of disinformation, and utter nonsense,
floating around since my talk at the Black Hat Federal security conference
the other day, I have decided to publish the following papers.
http://www.databasesecurity.com/HackingAurora.pdf
http://www.databasesec ......