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

½ô¼±ÇóÎÊ´óϺ »áÓÃoracleºÍmysqlµÄ½ø

ÒÔǰÓÃmysqlÓùßÁË£¬Ò»°ã²éѯÊý¾Ý¿â¾ÍÓÃshow databases£¬ÄÜÏÔʾÊý¾Ý¿â³öÀ´£¬oracle²»ÖªµÀÔõô²éѯ£¬
»¹ÓÐdatabaseÀïµÄËùÓбíÏÔʾ³öÀ´£¬oracleÓï¾äÈçºÎд

´´½¨±íʱ£¬ÎªÊ²Ã´²»Óà use databaseÃû×Ö £¬ÕâÌõÓï¾ä£¬¶øÇÒ¿ÉÒÔÖ±½Ó´´½¨±í£¬ÇëÎÊÏÂoracleºÍmysql·½ÃæµÄÇø±ð

ÎÒÏëÓÃmyeclipseµÄDB Brower Á¬½Óoracle£¬thinºÍociµÄÇø±ð
ÔÚÌîдDB Brower ÃÜÂëºÍÓû§µÄʱºò£¬ÎÒÊÇÌîдÔÚÃüÁî·ûµÇ½½øÀ´µÄÓû§ºÍÃÜÂëÊÇÕýÈ·µÄ°É£¡
url£ºjdbc:oracle:thin:@127.0.0.1:1521:ORACLE10£¨ÒòΪ²»ÖªµÀÔõô²éoracleµÄdatabase£¬ÎÒÌîдORACLE10£¬²»ÖªµÀÊDz»ÊÇÀïÃæÓÐÕâ¸ödatabase£©
jar°üºÍÆäËûµÄ¶¼ÌîдºÃÁË
µ«Êǻᱨ³öIo Exception:Connection rujused.....һЩ¶«Î÷¿´²»¶®

ÍøÉÏÓÐʲôºÃµãµÄoracleµç×ÓÊé»òÕßÊÓÆµÄܽéÉÜÒ»ÏÂÂð£¿

ÎÊÌâ±È½Ï¶à£¬Ï£ÍûÄÄλÅóÓÑÄÜÄÍÐĻش𣡣¡ÄܻشðÆäÖÐÒ»¸öÎÊÌâÒ²¸ø·Ö£¡£¡¶à´ð¶à·Ö

²éѯÊý¾Ý¿â£¿
select * from v$database

´´½¨±í
create table TABLENAME(
  COLNAME1 TYPE,
  COLNAME2 TYPE,
...);
²»»ámysql

--sqlµÄÓï·¨ÊÇͨÓõÄ!

--oracle²é¿´ËùÓбí:

SQL code:
select * from dba_all_tables



--Á¬½ÓµÄÎÊÌâ¿ÉÒÔÈ¥:

www.connectionstrings.com



ËùÓÐÎÊÌâ¶¼¿ÉÒÔ´ÓgoogleÇáËɵõ½´ð°¸£¬×ÔѧҲÊÇÒ»ÖÖÄÜÁ¦µÄ£¬oracleºÍmysql²îºÜ¶à£¬²»¹âÓï¾äÉÏ£¬ÀýÈçoracleûÓжÔÿ¸öÊý¾Ý¿âµÄ¶¨Òå¶øÊÇʹÓÃÃüÃû


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

MYSQL ÈçºÎÐÞ¸ÄBLOBÀàÐ͵ÄÊý¾Ý?

ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿

¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ