Home » SQL & PL/SQL » SQL & PL/SQL » run a script
run a script [message #223633] Fri, 09 March 2007 19:52 Go to next message
SUSAN1
Messages: 36
Registered: March 2007
Member
how can I run a script to add some information(query) at the same time to a database and uppdate it (I have another file which name is Oracle_Movie_add-on.sql with a lote of insert query)?

[Updated on: Fri, 09 March 2007 22:51]

Report message to a moderator

Re: run a script [message #223639 is a reply to message #223633] Fri, 09 March 2007 22:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Question is a little confusing?

I'm not sure if you are looking for MERGE functionality ??
Re: run a script [message #223640 is a reply to message #223639] Fri, 09 March 2007 23:01 Go to previous messageGo to next message
SUSAN1
Messages: 36
Registered: March 2007
Member
I have allredy a table full av information, but I need to copy a lote of information from another database to the table which name is Movie. those data that I have is saved as
Oracle_Movie_add-on.sql under some catalog in my computer look at the code that I write on DOS prompt, I am preety sure that is wrong way and dont know what should I do.

C:\6B4074\6B4074+Projektfiler+Oracle+10g>dir
Volume in drive C is PRESARIO
Volume Serial Number is F8CE-2339

Directory of C:\6B4074\6B4074+Projektfiler+Oracle+10g

03/09/2007 06:23 PM <DIR> .
03/09/2007 06:23 PM <DIR> ..
03/09/2007 06:23 PM 109,211 Oracle_Movie_add-on.sql
02/26/2007 12:43 PM 24,576 Video.dmp
2 File(s) 133,787 bytes
2 Dir(s) 217,811,861,504 bytes free

C:\6B4074\6B4074+Projektfiler+Oracle+10g>Oracle_Movie_add-on.sql sys@orcl as sys
dba

C:\6B4074\6B4074+Projektfiler+Oracle+10g>
Re: run a script [message #223654 is a reply to message #223639] Sat, 10 March 2007 02:25 Go to previous messageGo to next message
SUSAN1
Messages: 36
Registered: March 2007
Member
hej,
no, it is not Merge that I am asking about.
Re: run a script [message #223696 is a reply to message #223640] Sat, 10 March 2007 08:58 Go to previous messageGo to next message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
SUSAN1 wrote on Sat, 10 March 2007 05:01

C:\6B4074\6B4074+Projektfiler+Oracle+10g>Oracle_Movie_add-on.sql sys@orcl as sys
dba


To run a SQL*Plus script you have to run sqlplus:

sqlplus username/password@wherever @Oracle_Movie_add-on.sql
Re: run a script [message #223731 is a reply to message #223696] Sat, 10 March 2007 15:55 Go to previous message
SUSAN1
Messages: 36
Registered: March 2007
Member
thanks Razz
Previous Topic: How to know the status of sql batch processing trhough pl/sql?
Next Topic: Query Help!
Goto Forum:
  


Current Time: Sat Dec 10 12:33:14 CST 2016

Total time taken to generate the page: 0.08995 seconds