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

OracleÓû§¹ÜÀí

oracleÓû§¹ÜÀí
                           
                           
ÖÆ×÷ÈË£ºÏòÏȺ¯
ÈÕÆÚ   2009-5-21
 
Æô¶¯-------------------------------------------------------------------
 
Æô¶¯¼àÌý        Lsnrctl start ;
 
Æô¶¯ÊµÀý        oradim  -starup –sid orcl;
 
ȨÏÞ£º-----------------------------------------------------------------
 
´´½¨Óû§        create user lisi identified by lisi ;
 
´´½¨Óû§È¨ÏÞ    grant create session to lisi;
 
´´½¨±íȨÏÞ      grant create table to lisi;
 
´´½¨±í¿Õ¼äȨÏÞ  grant unlimited tablespace to lisi;
 
³·ÏúȨÏÞ        revoke create table from lisi;
 
²é¿´È¨ÏÞ        select * from user_sys_privs;(ÆäÖÐuser_sys_privsÊÇÒ»¸öÊÓͼ)£¨ÏµÍ³£©
 
²é¿´µ±Ç°ÊÚȨ    select * from user_tab_privs;(ÆäÖÐuser_tab_privs Êǵ±Ç°ÊÓͼ)£¨¶ÔÏó£©
 
²é¿´ÁÐÓÃÊý¾Ý×Öµäcol select * from user_col_privs
 
³·ÏúʹÓÿռäµÄȨÏÞ  revoke unlimited tablespace from lisi;
 
²Ù×÷
 
²åÈëÒÔºó±ØÐëÊÖ¶¯Ìá½»²ÅÄÜÉúЧ   commit£»  ͬʱֻÓÐsysÓû§¿ÉÒÔ·ÃÎÊ
 
ÆÕͨÓû§ÊÚȨÈçÒªÔÚlisiÓû§ÀïÃæ·ÃÎÊwangwuµÄÓû§¾ÍÒªÉ趨
 
ÔÚwangwuÖР grant select on mytab to lisi;  (²éѯÊÚȨ)
              grant insert on mytab to lisi;  (²åÈëÊÚȨ)
              ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
  &nb


Ïà¹ØÎĵµ£º

ÈçºÎÔÚOracleÖи´ÖƱí½á¹¹ºÍ±íÊý¾Ý


1. ¸´ÖƱí½á¹¹¼°ÆäÊý¾Ý£º
create table table_name_new as select * from table_name_old
2. Ö»¸´ÖƱí½á¹¹£º
create table table_name_new as select * from table_name_old where 1=2;
»òÕߣº
create table table_name_new like table_name_old
3. Ö»¸´ÖƱíÊý¾Ý£º
Èç¹ûÁ½¸ö±í½á¹¹Ò»Ñù£º
insert into table_name_ ......

ORACLE to_charº¯ÊýÏê½â


The following are number examples for the to_char
function.
to_char
(1210.73,
'9999.9')
would return '1210.7'
to_char
(1210.73,
'9,999.99')
would return '1,210.73'
to_char
(1210.73,
'$9,999.00')
would return
'$1,210.73'
to_char
(21,
'000099')
would return '000021'
The foll ......

ORACLEÊý¾Ý¿âÉè¼ÆÓëÓÅ»¯


<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;
mso-font-charset:2;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:0 268435456 0 0 -2147483648 0;}
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 ......

oracle ¼Ç¼³¬¹ý1000Ìõ£¬Ê¹ÓÃin·½·¨

  ÔÚoracleÖУ¬ÎÒÃÇʹÓÃin·½·¨²éѯ¼Ç¼µÄʱºò£¬Èç¹ûinºóÃæµÄ²ÎÊý¸öÊý³¬¹ý1000¸ö£¬ÄÇô»á·¢Éú´íÎó£¬ÏÂÃæµÄÕâ¸ö·½·¨¾ÍÊǽâ¾öÕâ¸öÎÊÌâµÄ£¬Ëü½«ÎÒÃǵÄÉÏǧ¸ö²ÎÊý·Ö³É¼¸×飬±£Ö¤Ã¿×éµÄ²ÎÊý¸öÊý²»³¬¹ý1000
/**
  * Éú³É·ûºÏÌõ¼þµÄsqlÓï¾ä,½â¾öinÎÊÌâ
  * @param sqlParam£ºÎÒÃÇÐèÒª´¦ÀíµÄ²ÎÊýµÄ×Ö·û´®¸ñʽ£¬ÀýÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ