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

oracleÁ¬½Ó

ÔÚÍøÂçÉÏÓÐһ̨ORACLE·þÎñÆ÷£¨windows2003£¬ORACLE 10G£©
¿Í»§»úʹÓÃXP£¬°²×°ORACLE8I¿Í»§¶Ë
ʹÓÃSQLPLUS¿ÉÒÔÔ¶³ÌÁ¬½Óµ½ORACLE·þÎñÆ÷£¨ÒÔSYSDBAÉí·Ý£©
ͨ¹ýÃüÁîshutdown immediate¹Ø±ÕÊý¾Ý¿âºó£¬ÎÞ·¨Ê¹ÓÃstartupÆô¶¯Êý¾Ý¿â
ÌáʾÕÒ²»µ½³õʼ²ÎÊýÎļþ´íÎó

Íû¸ßÊÖÖ¸µã¡£¡£¡£¡£¡£
startupµÄʱºòÌáʾ´íÎóÊÇ?

ÒýÓÃ
startupµÄʱºòÌáʾ´íÎóÊÇ?


failure in processing system parmeter
??????????? "g:/oracle/....."

ÄãÕâÀï¿ÉÄÜÊÇspfileÎļþËð»µÁË£¬

ÄãÓÐûÓÐÊÖ¶¯Ð޸ĹýspfileµÄÎļþ¡£

ÒýÓÃ
ÄãÕâÀï¿ÉÄÜÊÇspfileÎļþËð»µÁË£¬

ÄãÓÐûÓÐÊÖ¶¯Ð޸ĹýspfileµÄÎļþ¡£

ÎÒÒÔǰ¾ÍÊÇʹÓÃVI ÊÖ¶¯ÐÞ¸ÄÁËSPFILE£¬½á¹ûÊý¾Ý¿âÆð²»À´¡£

ORACLE¶¼ÊÇÔËÐÐÔÚLinuxÉϵÄ.........

΢ÈíÒ»ÏòÊÇÒÔ¢¶ÏΪ·¢Õ¹·½Ïò,ÎÒÃÇÔÚÒÔǰ֪µÀ,JavaÔÚWindowsÉϵÄÔËÐÐÐÔÄÜÔ¶Ô¶²îÓÚLinuxµÈOS,ÓÐʱÔÚWindowsÉÏ»¹

»á³öÏÖһЩÕâÑù»òÄÇÑùµÄÎÊÌâ.....
ÏÖÔÚÓÐЩ´óµÄÈí¼þ²úÆ·¶¼Ç¿µ÷ÔÚLunixµÈÆäËü²Ù×÷ϵͳÉϵÄÐÔÄÜÓëÎȶ¨,ÈçOracle,Sybase,DB2....Ì«¶àµÄ²úÆ·Ö§³Ö

Linux ÁË.......ËäÈ»ÓеIJúÆ·Ò²·¢ÏÖÁËWindows°æ,µ«ÊÇÐí¶àÆóÒµÒ²²»¸ÒÔÚWindowsÉÏÅÜËüÃǵĺËÐÄÒµÎñ.......
ÀëÁË΢ÈíµÄÕóÓª,ÍâÃæµÄÊÀ½çºÜ¾«²Ê............
ͨ¹ýÒÔÉÏ˵Ã÷...Èç¹ûÄãÓÃ΢ÈíµÄ²úÆ·,ÈçÂ¥Ö÷µÄC#+.NET,SQL Serverµ±È»ÊÇ×îºÃµÄ...ΪÁ˲úÉú²»±ØÒªµÄÂé·³ÀË·ÑÄãµÄ

Çà´º...Äã×îºÃ¾ÍÓÃ΢ÈíµÄ²úÆ·.....Èç¹ûÄãϲ»¶Mysql¾ÍÓÃLinux....
Õâ¸öÊÀ½çÊǾºÕùµ


Ïà¹ØÎÊ´ð£º

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

OracleÈçºÎʹÓô°¿Úº¯ÊýʵÏÖÕâÑùµÄ²éѯ

±í¼Ç¼
======================================
name        date        score
Fei Zhang  1          100
Fei Zhang  ......

¹úÇìËÍ·Ö3 ÇóoracleÓï·¨Îĵµ(chm)

ÇóoracleÓï·¨Îĵµ(chm)

kennth@126.com

Ô½ÐÂÔ½ºÃ
ÎÒÀ´½Ó·Ö£¬Ã»ÓÐеÄ
×Ô¼ºÈ¥ÏÂ

ÒýÓÃ
ÎÒÀ´½Ó·Ö£¬Ã»ÓÐеÄ
×Ô¼ºÈ¥ÏÂ


µ¹..ÄãÊÇרÃÅËÑË÷ËÍ·ÖµÄÎÄÕÂ?..ÄÄÀï¶¼¼ûµ½Äã,,

........ ......

oracleµÄµ¥ÒýºÅ ºÍË«ÒýºÅµÄÎÊÌâ ÒÉ»ó¡£

RT

×Ö·û´®Óõ¥ÒýºÅ
Ë«ÒýºÅ±íʾ±í, ×Ö¶ÎÃûµÈ¶ÔÏó¡£

ÀýÈç
select * from table_name where id=1;ÕâÖÖ´ú±í²éѯµÄÊÇÊý×Ö
select * from table_name where id='1';ÕâÖÖ´ú±í²éѯµÄÊÇ×Ö·û
Èç ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ