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Êý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......