Topic profile page for SQL script.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: SQL script.
Topic "Sql script" was discussed 2,160 times on 190 sites in last 3 months
Started 5 days, 2 hours ago (2009-11-26 00:00:00)
by Katrien
Hi, Apologies if this question has been posed previously, I cannot find it via "Search" but simply point me to the solution if so ... I am desparately looking for a solution for the following problem. 1. In the Install I run a few SQL Scripts that create a database 2. In the uninstall I want to run a script that will Drop this database using another SQL script. 3. I tried ...
Started 5 days, 20 hours ago (2009-11-25 06:33:00)
by user784520
Hi, I need to call a sql script file from a user defined function. Currently i am trying to do this in Oracle SQL Developer. i tried calling with @ {filename}, EXECUTE IMMEDIATE etc, but nothing worked. I get the Compiler error. Basically my need is to call catldap.sql file so that DBMS_LDAP package gets loaded and then I can call the API functions...
Started 6 days, 13 hours ago (2009-11-24 12:52:00)
by gatorcb
Our DBA ran the supplied script to setup the sql database and received the below messages. Are the below critical to have fixed? If so, what is the procedure? Thanks Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.GenUIReports_sp'. The stored procedure will still be created; however, it cannot be successfully executed until ...
Started 1 week, 1 day ago (2009-11-22 11:45:00)
by faramarz
Dear all, I would like to ask a question about new line characters inside SQL file scripts. I have a very long SQL query saved in a txt file (ANSI coding). Because the query statements are very long (many table joins and WHERE conditions) I tried to separate the FROM, WHERE and ORDER BY clauses by inserting several new line characters (just hitting the Enter) among them to improve the ...
Started 1 week, 1 day ago (2009-11-22 08:28:00)
by dariyoosh
Dear all, I would like to ask a question about new line characters inside SQL file scripts. I have a very long SQL query saved in a txt file (ANSI coding). Because the query statements are very long (many table joins and WHERE conditions) I tried to separate the FROM, WHERE and ORDER BY clauses by inserting several new lines characters (just hitting the ...
Started 1 week, 2 days ago (2009-11-21 14:34:00)
by hanct
Can visio 2010 generate data dictionary and generate sql script??? In the past, u need special edition of visio to do these 2 tasks...but not sure if current version can do that? If not, then I don't see any improvement between visio 2010 and visio 2007 in terms of database diagram drawing.
Started 1 week, 4 days ago (2009-11-19 12:19:00)
by MarGur
Hi all, This one just drives me nuts.. I have a shell script that works OK while I am running it manually. It runs OK via cron up to the point where sql script should be executed: /u01/app/sghe/dw/dwprod/app/scripts/dapstart /u01/app/sghe/dw/dwprod/app/scripts/webstart /u01/app/oracle/product/bin/sqlplus dwmgr/u_pick_it@pds1_PURPLE @/home/...
Started 1 week, 6 days ago (2009-11-17 09:40:00)
by GEThomas
Is it possible to run an SQL script from Excel with VBA Does anybody know if it is possible to run an SQL script (.sql) rather than single SQL statements in Excel VBA? The SQL script is held locally on my C Drive and needs to be run against an oracle database to spool a text file in a specific format...
Hi and welcome to the forum! Perhaps you mean the DBMS_METADATA package? Do a search on DBMS_METADATA on this forum to find examples. Also check the Oracle Documentation @ http://tahiti.oracle.com
Started 1 week, 1 day ago (2009-11-22 17:08:00)
by faramarz
QUOTE (HAL9000 @ Nov 22 2009, 10:51 PM) ... If you mean a "blank" line, then yes, SQL*Plus does not support blank lines. ... Well, actually I'm not really sure about that, I added the following to the first line of my script file CODE SET SQLBLANKLINES ON And it works pretty well now, no matter how many blank lines are there. Thank you very much for your ...
Started 1 week, 1 day ago (2009-11-22 13:59:00)
by dariyoosh
Frank Kulash wrote: Hi, In SQL*Plus 9 (and up) you can say SET SQLBLANKLINES ON to allow completely empty lines within a SQL statement. Dear Frank, This is what I call a nice and brilliant solution! Thank you very much it works pretty well!!! This is exactly what I was looking for. Kind Regards, Dariyoosh...
Started 4 days, 17 hours ago (2009-11-26 09:15:00)
by Dale Qiao
Hi, It seems to be more of SQL, I kindly recommend you to post your question in SQL Forum for a better assistance. Best Regards Dale Marked As Answer by Dale Qiao MSFT , Moderator Thursday, November 26, 2009 9:15 AM
Started 6 days, 13 hours ago (2009-11-24 13:42:00)
by SQLpro
Citation: Envoyé par centenaire Il s'agit d'un ERP et en bck de base ouverte, on rencontre des soucis avec certains data, le problème est connu aec d'autres db. Pourriez vous nous donner une référence de ce problème connu, parce que en 15 ans d'expérience et en tant qu'expert ayant accès aux ressources internes de ...
Started 3 days, 12 hours ago (2009-11-27 14:30:00)
by John Bell
Hi If your script requires interaction then it will not work, also if this file is on a mapped drive the drive may not exist in the context in which the process is executes. John > Hello Jonas, > [quoted text clipped - 175 lines] > Xcompress - IIS HTTP Compression > http://www.eggheadcafe.com/tutorials/aspnet/c5a74a 2e-01b5-4b6c-95c7-861a0909f404 /xcompress--iis-http-comp.aspx
Started 1 week ago (2009-11-23 06:51:00)
by Patrick Seidl
Good Morning! I checked a few machines with that problem but can't find any schedule or any bottleneck at the moment. But it seems that I've found a machine that is the most noisy one so maybe I can find anything if problem is occurring near every run... Also I'm going to test Marios approach for my scenario. Thanks for your reply, Patrick EDIT1: after a clean reboot of the noisy one the ...