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

OracleÓÐshow databaseÂð

ÎÒÖªµÀMysqlÀïÓÐ show database ,show tables
ÎÒÔÚOracleÀïÊäÈëÎÞЧ£¬  ÇëÎÊOricalÕâ¸öÔõôд

ÎÒÒª²é¿´OracleÀïÃæµÄËùÓÐÊý¾Ý¿âÃû×Ö

ºÇºÇºÇ£¬ÕâÀïÊÇmysqlÀïµÄÓ÷¨

mysqlÀïµÄdatabaseÀàËÆoracleµÄschema
Äã¿ÉÒÔÓÃselect * from dba_user; ²é¿´


tables¿ÉÒԲ鿴dba_tables »òÕßuser_tablesÁ½¸öÊý¾Ý×Öµä±í¡£

desc tablename

ÒýÓÃ
ºÇºÇºÇ£¬ÕâÀïÊÇmysqlÀïµÄÓ÷¨

mysqlÀïµÄdatabaseÀàËÆoracleµÄschema
Äã¿ÉÒÔÓÃselect * from dba_user; ²é¿´


tables¿ÉÒԲ鿴dba_tables »òÕßuser_tablesÁ½¸öÊý¾Ý×Öµä±í¡£

Èç¹ûÄãÏë½øÒ»²½²é¿´schemaÏÂÓÐÄÄЩ±íµÄ»°
¿ÉÒÔÓøÃÓû§µÄÉí·ÝµÇ¼ ʹÓÃÈçÏÂÓï¾ä½øÐвéѯ
select table_name from user_tables;

ûÓÐ


ÒÔǰÀÏʦ²»ÊÇ˵ÿ¸öÊý¾Ý¿â¶¼´óͬСÒìÂð£¿ÕâÑùѧÁËmysql £¬¸úÕâ¸öOracleºÃÏñû¹ØÏµÁË£¬ºÜ¶àÓï·¨DDL¶¼²»Ò»Ñù£¬

ÊDz»ÊÇOracle ûÓÐ ÆäËûÊý¾Ý¿â£¬µ¥¸öÊý¾Ý¿âµÄ¸ÅÄMysql serverSQL ¶¼Êǵ¥¸öÊý¾Ý¿âÀïÃæ·Ö³ÉN¸ö±í¡£

OracleÓÐûÓÐÒ»¸öÒ»¸öµÄÊý¾ÝÄØ

ÒýÓÃ
ÊDz»ÊÇOracle ûÓÐ ÆäËûÊý¾Ý¿â£¬µ¥¸öÊý¾Ý¿âµÄ¸ÅÄMysql serverSQL ¶¼Êǵ¥¸öÊý¾Ý¿âÀïÃæ·Ö³ÉN¸ö±í¡£

OracleÓÐûÓÐÒ»¸öÒ»¸öµÄÊý¾ÝÄØ


mysqlÀïµÄdatabaseµÄ¸ÅÄî ¾ÍÊÇ oracleÀïµÄschemaµÄ¸ÅÄ

ËùÒÔÊDz»Í¬µÄ·½Ê½À´¿´£¬mysqlÀïshow databbases£¬ ÔÚoracleÀï¿ÉÒÔÓÃselect username from dba_users;¼´¿É
ÆäʵÔÚmysqlÀïshow d


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ