Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

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

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ