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,169 times on 189 sites in last 3 months
Started 2 days, 11 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 3 days, 4 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 5 days, 23 hours 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 6 days, 2 hours 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 6 days, 20 hours 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, 1 day 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, 4 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...
Started 1 week, 4 days ago (2009-11-17 07:45:00)
by Oskar92
Hi i need to change alot of SQL coding to work with an Microsoft Access Database, was hoping that some blessed soul could write the whole code for me. It an script to an Calandar. The link:http://aspnet.4guysfromrolla.com/articles/041 603-1.2.aspx At the buttom under attachment Download the complete source code (in zip-format) Best regards Oskar ...
Started 1 week, 1 day ago (2009-11-19 14:15:00)
by Patrick Seidl
Hi forum! On some of our SQL servers I'm getting the following alert (Event ID 4001) from time to time: Script : Failed to login GetSQL2005BlockingSPIDs.vbs : Cannot login to database [][MSSQLSERVER:master] I've checked serverl posts but they did not match to my problem because: * alert occours not always, just sometimes * most of the time from diff. servers * no essential SQL configuration ...
Started 5 days, 18 hours 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 5 days, 21 hours 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...
