Top "Sql-scripts" questions

SQL Scripts are lists of SQL sentences written in a single file, meant to be executed sequentially.

Export specific rows from a PostgreSQL table as INSERT SQL script

I have a database schema named: nyummy and a table named cimory: create table nyummy.cimory ( id numeric(10,0) not null, …

postgresql insert export sql-scripts postgresql-copy
How to create a oracle sql script spool file

I have a question about spooling the the results of my program. My sample sql script looks like this. whenever …

oracle plsql sql-scripts spool
How to Execute SQL Script File in Java?

I want to execute an SQL script file in Java without reading the entire file content into a big query …

java sql-scripts
T-SQL STOP or ABORT command in SQL Server

Is there a command in Microsoft SQL Server T-SQL to tell the script to stop processing? I have a script …

sql sql-server tsql sql-scripts
How can I describe a table in Oracle without using the DESCRIBE command?

I'm having a hard time with a class I am taking. We need to write an Oracle script that will …

oracle oracle11g sql-scripts data-dictionary
SQL Server database last updated date time

Is there any sql script to find out when the database in SQL server is last updated? I want to …

sql sql-server database sql-scripts
executing a .sql file in sql plus terminal

I have written couple of sql scripts in a text file and saved them with a .sql extension. I want …

sqlplus sql-scripts
Execute scripts by relative path in Oracle SQL Developer

First, this question relates to Oracle SQL Developer 3.2, not SQL*Plus or iSQL, etc. I've done a bunch of searching …

sql oracle oracle-sqldeveloper relative-path sql-scripts
Executing script file in h2 database

First of all I would like to say am new to h2 database. I need to execute a sql script …

h2 sql-scripts
SQL Server - Running large script files

I have a database table on a development server that is now fully populated after I set it running with …

sql-server sql-scripts