var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Creating sql files taking data from oracle tables
I want to create .sql files taking data from oracle tables through VB.
Re: Creating sql files taking data from oracle tables
You should specify what a .sql file is, since we can use that extension for files containing a single command, a series of commands, or environment variable SET instructions in SQL*Plus.
Supposing you want a file that has commands in it, you can do something like this ...
SET TRIMSPOOL ON FEEDBACK OFF VERIFY OFF;
SELECT col1 [|| separator text || colN] FROM tab1 [, tabN];
SELECT 'ALTER TABLESPACE ' || tablespace_name || ' BEGIN BACKUP;'
WHERE TABLESPACE_NAME LIKE 'MYAPP%';
Actually, i want to copy data of some oracle tables into text files each of a particular size.
I have to write code in vb6.0... ..
After that i've to convert data from those text files into or say copy them to MySql tables.
For all this, the first step is to convert data from say 2-3 tables into text files. Now, how should i go about it. Any code samples.