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

oracle»ù´¡ÈëÃŽ̲Ä

 
½¨±í
create table <table_name>(
column_name1 column_type [not null] [check (expression)]
    [default value] [primary key][references <table_name>(column_name)],
column_name2 column_type [not null] [check (expression)]
    [default value] [primary key][references <table_name>(column_name)]
....
[constraint primary_name
   primary key(column_name1,column_name2...)
]
[unique(<column_name1,column_name2...>)]
                        );
create table <table_name>
as
     select * from <other_table_name> where <condition>
---------------------------------------------------------------------------------------
¸Ä±í½á¹¹
1 alter table <table_name> add(column_name column_type);
2 alter table <table_name> modify(column_naem column_type);
---------------------------------------------------------------------------------------
ɾ±í
drop table <table_name>;
truncate table <table_name>;
---------------------------------------------------------------------------------------
±íµÄÖØÃüÃû
rename <table_name1> to <table_name2>;
---------------------------------------------------------------------------------------
²åÈëÊý¾Ý
1 insert into <table_name> (column_name1, column_name2, ....)
    values   (column_value1, column_value2,.... );
2 insert into <table_name>
    values   (column_value1, column_value2,.... );   
3 insert into <table_name> (column_name1, column_name2, ....)
      select expression1,expression2, ....
      from   <table_name>
      [where <condition_expression>];
---------------------------------------------------------------------------------------
±íµ


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

ORACLE×ÔÔö³¤×Ö¶ÎʵÏÖ£¨×ª£©

ÏîÄ¿ÖУ¬ÐèÒª½¨Á¢×ÔÔö³¤×ֶΣ¬µ«Åöµ½oracle±¾Éí²»Ö§³Ö´ËÖÖÀàÐ͵Ä×ֶΣ¬Ö»ºÃÓñðµÄ°ì·¨¡£ 
ORACLE×ÔÔö³¤×Ö¶ÎʵÏÖ£¨×ª£©
     Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
       CREATE TABLE example(
          &nbs ......

oracle·¢ËÍÓʼþ´æ´¢¹ý³Ì:

oracle·¢ËÍÓʼþ´æ´¢¹ý³Ì:
create or replace procedure bsd_sendemail(
p_receiver varchar2,
p_sub varchar2,
p_txt varchar2)
is
p_user varchar2(30):='';
p_pass varchar2(30):='';
p_sendor varchar2(20):='Gnie';
p_server varchar2(20):='Mail_Server_IP';
p_port number:=25;
p_need_smtp number:=0;
p ......

OracleÊý¾Ý¿âʹÓü°ÃüÃû¹æÔòµÄÏê½â

¹«Ë¾Òѽ¨Á¢µÄ»ò´ý½¨Á¢µÄÍøÕ¾£¬È磺ÖÐÎÄÕ¾£¨CHINA£©£¬¹ú¼ÊÕ¾£¨ALIBABA£©£¬»ªÉÌÕ¾£¨CHINESE£©µÈ¡£
OLPS
Online process system£¬ÔÚÏß´¦Àíϵͳ£¬¼´ÎÒÃǵĻáÔ±¿ÉÒÔä¯ÀÀµÄÍøÕ¾ËùÁ¬½ÓµÄÊý¾Ý¿â£¬Ò²ÊÇÎÒÃÇËù˵µÄǰ̨¡£
BOPS
Back Office process system£¬ºǫ́´¦Àíϵͳ£¬¼´ÎÒÃǵÄÍøÕ¾µÄ·¢²¼ÏµÍ³¡£
BZO
Business Object(?)£¬¹«Ë ......

ORACLE ÄÚ´æ¹ÜÀí


Oracle 9i¶¯Ì¬SGA¹ÜÀí
ÔÚOracle 9iÖУ¬¿ÉÒÔÉèÖÃSGA_MAX_SIZE£¬¸Ã²ÎÊýÓÃÒÔ¿ØÖƸ÷»º³å³ØÊ¹ÓõÄÄÚ´æ×ܺͣ¬±¾ÖÊÉÏÊÇÔÚ½ø³ÌÖÐÔ¤ÏÈ·ÖÅäÒ»¶ÎÐéÄâµØÖ·±¸Óöø²»·ÖÅäÎïÀíÄڴ棬ĿµÄÊÇ·ÀÖ¹ºÍ½ø³Ç˽ÓеØÖ·¶ÎµÄ³åÍ»¡£
Ö»Òª×ܵÄSGAÄÚ´æÉèÖò»³¬¹ýSGA_MAX_SIZEµÄÉèÖ㬸ü¸Ä¶¼¿ÉÒÔÁ¢¼´ÉúЧ¡£ÐèҪעÒâµÄÊÇ£¬ÔÚOracle 9iR1ÖУ¬¶¯Ì¬¼õСÄÚ´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ