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

Oracle´´½¨Óû§µÄÆæ¹ÖÎÊÌ⣿µÈ´ý¸ßÊÖ½â»ó



»·¾³ 10G

ʹÓÃem´´½¨Ò»¸öÓû§£¬Ò»ÇÐÕý³££¬

Óô´½¨Õâ¸öÓû§µÄ sqlÓï¾äÔÚ isql*plus ´´½¨ÁíÍâÒ»¸öÓû§

CREATE USER "Tim" PROFILE "DEFAULT" IDENTIFIED BY "*******" ACCOUNT UNLOCK

Ö»ÊÇÐÞ¸ÄÁËÓû§ÃûºÍÃÜÂë,Ò²Ìáʾ´´½¨³É¹¦¡£¶øÇÒÔÚemÀï±ß¿ÉÒÔ¿´µ½Õâ¸öÓû§ Tim

µ«ÊǽÓÏÂÀ´ Ö´ÐÐÊÚȨ²Ù×÷ grant create table to Tim

µÄʱºòÌáʾÎÒÓû§ºÍ½ÇÉ«²»´æÔÚ¡£

ºóÀ´·¢ÏÖÎ¨Ò»Çø±ðÊÇ£¬ÎÒʹÓÃem´´½¨µÄÓû§ÔÚemÀï±ßÏÔʾ¶¼ÊÇ´óдÃû×Ö£¨ÎÞÂÛÎÒ´´½¨µÄʱºòÊäÈë´óд»¹ÊÇСд£©

¶øÊ¹ÓÃisql*plus´´½¨µÄÓû§ ÔòÔÚemÀï±ßÏÔʾµÄÊÇÎÒµ±Ê±´´½¨Ê±ºòÊäÈëµÄ´óдС¹æÔò¡£

µ«ÕâÑùÔÙÊÚȨ¾ÍÊDz»ÐС£


ºóÀ´ÎÒ³¢ÊÔͬÑùµÄÓï¾ä£¬ÎÒ°ÑÓû§ÃûÈ«´óд£¬¾Í¶¼¿ÉÒÔÁË¡£

²éѯÓï¾äÀï±ßÎÒ´óСдÔõôÑù±ä»¯¶¼¿ÉÒԲ鵽Õâ¸öÓû§¡£¡£


ÕæÆæ¹Ö°¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡



¶¼ÊÇ""ÈǵĻö~

CREATE USER Tim PROFILE DEFAULT IDENTIFIED BY ******* ACCOUNT UNLOCK

SQL> CREATE USER "Tim" PROFILE "DEFAULT" IDENTIFIED BY "Tim" ACCOUNT UNLOCK;

Óû§ÒÑ´´½¨¡£

SQL> grant connect to tim;
grant connect to tim
                *
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01917: Óû§»ò½ÇÉ« 'TIM' ²»´æÔÚ


SQL> grant connect to Tim;
grant connect to Tim
      &nb


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oralce µÄÒ»¸öSQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÊÌâÌá³ö£º
Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ 
¼ÙÉèÓÐÒ»ÕÅ±í£¬AºÍB×ֶζ¼ÊÇNUMBER£¬
A B
1 2
2 3
3 4

ÓÐÕâÑùһЩÊý¾Ý
ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä£¬²éѯ³öÕâÑùµÄÊý¾Ý
COLA COL1 COL3 COL2 COL1
4 4 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ