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

ResultSetMetaData»ñÈ¡ÆäËûoracleÓû§Ïµıí½á¹¹

±ÈÈç˵ÎÒÓÃUSER_AÓû§½¨Á¢µÄconnection£¬µ«ÎÒÏëÔÚjavaÀïÃæ»ñµÃUSER_BÓû§ÏµÄtable½á¹¹£¬
ÓÃResultSetMetaData·½Ê½ºÃÏñ²»ÐУ¬ÓÐÆäËû½â¾ö;¾¶Âð£¿
²»¿ÉÄܰɣ¬³ý·ÇUSER_A¾ß±¸dbaµÄȨÏÞ


Óû§BÏȽ«±íµÄµÄ·ÃÎÊȨÏÞ¸³Óè¸øÓû§A£¬Ó¦¸Ã¾Í¿ÉÒÔÁË£¡


Òª¸øuser_A¸³Óè·ÃÎÊuser_BµÄȨÏÞ  Ï൱ÓÚDBAÁË

oracleÀïÃædesc tableName;¾Í¿ÉÒÔÁË


Ïà¹ØÎÊ´ð£º

ÀÏÎÊÌ⣺OracleÐÐתÁУ¨×Ö·û´®²ð·Ö£©

ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

ÇóÖúÒ»¸ö¶¨Ê±Ö´ÐÐoracle´æ´¢¹ý³ÌµÄÎÊÌ⣬Çë´óÏÀ°ïæ

ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......

¹ØÓÚoracle 10gµÄsqlplus

ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390

×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ

×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ