Spool file sqlplus

Say you have a table like this: create table yourTable loc number, item varchar2 10 ; insert into yourTable values 1, 'one' ; insert into yourTable values 2, 'two' ; insert into yourTable values 3, 'three' ; With a script test. Aleksej Aleksej It worked, thank you! Maybe you know how to pass parametres into spooled filename?

What i want is to run everything using only one script. You can use the parameter quite the same way; just edited to show you an example — Aleksej. Sign up or log in Sign up using Google. Sign up using Facebook.

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.

I will be running it as a separate file for the expiring users. To turn that off, use set heading off. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 3 years, 3 months ago. Active 3 years, 3 months ago. Viewed times. I use Solaris SunOS sintscdldmu 5.

Improve this question. The full contents of our example script can be found below. To execute the script, simply use the symbol followed by the file name:. Your script should be executed and the. There are many database diagramming tools that are not only incredibly useful but also free. After launching and connecting to SQL Server Management Studio, create a new login and select the database that is connected to Chartio.