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

pl/sql µ¼Èëuser objectsÎÊÌâ

±¾ÈËÊǸտªÊ¼ÓÃpl/sql developer£¬ÏÖÔÚÒª×öÕâÑùÒ»¼þÊÂÇé¡£
ÎÒÏÈʹÓÃtools->export user objects£¬µ¼³öÁËËùÓеÄÊý¾Ý¿âµ±Ç°Óû§Ä£Ê½ÏµĶÔÏó¡£
È»ºóÎÒÔÚÁíһ̨»úÆ÷ÉÏ´´½¨Í¬ÃûµÄÊý¾Ý¿â£¬Í¬ÃûµÄ±í¿Õ¼ä£¬Í¬ÃûµÄÓû§¡£
ÏÖÔÚÔõôÓÃpl/sql developerµ¼ÈëÓû§¶ÔÏóÄØ£¿
ÎÒÖ±½ÓÔÚÃüÁî´°¿ÚÖÐÖ±½ÓÔËÐе¼³öʱÉú³ÉµÄsqlÎļþʱ±¨´í¡£
»¹Çë¸ßÊÖÖ¸µã~~
ÄãÊÇÓõÄʲôÃüÁ±¨µÄÊÇʲôÑùµÄ´í

ÏÈÁ˽âһϵ¼Èëµ¼³öµÄÓ÷¨
http://www.inthirties.com/thread-42-1-1.html

»ØÂ¥ÉÏ£¬ÎÒÊÇÖ±½Ó°ÑÉú³ÉµÄsqlÎļþ·Åµ½ÃüÁîÐд°¿ÚÖ´Ðеġ£¡£¡£¡£

»ØÒ»Â¥£ºÒÔÏÂÊÇÎÒ±¨µÄµÚÒ»¸ö´íÎó¡£
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as ybjj

SQL>
SQL> ----------------------------------------------
SQL> -- Export file for user YBJJ                --
SQL> -- Created by dinghua on 2009-9-3, 10:17:56 --
SQL> ----------------------------------------------
SQL> spool user_objects.log
Started spooling to C:\Program Files\PLSQL Developer\user_objects.log
SQL> prompt

SQL> prompt Creating table DIM_COMPANY
Creating table DIM_COMPANY
SQL> prompt ==========================
==========================
SQL> prompt

SQL> create table YBJJ.DIM_COMPANY
  2  (
  3    COMPANY_KEY          NUMBER(10) not


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

²ËÄñÌáÎÊ£¬Çó¼òµ¥sql ?



±íA

Sup_code    st_sup_code    buy_code      buy_code1 
1001        400            &nbs ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ