08-24-2013
Thank you for your response. So how do I then execute the generated SELECT statements?
8 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I want to collect the database tables(Ex: Emp,Sal,Bonus...etc)
in a file & give this file at the command prompt, when prompted for the tables list at command prompt. How can i do that ?
Ex:- Import jason/jason1 tables=emp,sal,bonus log=j1.log
i want to change this into
Ex:- Import... (3 Replies)
Discussion started by: dreams5617
3 Replies
2. Shell Programming and Scripting
Hi all, i would like to set a cronjob to back up my db tables.
I have written the par file, i would like to know how can i execute a exp command in a shell script.
my par file userid=admin/password
file=backup.dmp
log=backupLOG.log
tables=
(Tables 1,
Tables 2)My cron job script will be... (1 Reply)
Discussion started by: new2ss
1 Replies
3. Shell Programming and Scripting
I am coding shell script.
I need to connect to different databases like DB2, Oracle and Sybase.
I would then need to query tables where it has all the groups, users for that database.
I would also need who has what kind of permissions.
EG: I know for DB2 some TABAUTH table needs to be... (0 Replies)
Discussion started by: pinnacle
0 Replies
4. Programming
I'm pretty new to the database world and I've run into a mental block of sorts. I've been unable to find the answer anywhere. Here's my problem: I have several tables and everything is as normalized as possible (as I've been lead to understand normalization.) Normalization has lead to some... (1 Reply)
Discussion started by: flakblas
1 Replies
5. Shell Programming and Scripting
Hi all,
I am executing shell script in which I am using SQLLDR
In this SQLLDR I am passing text file having PL/SQL script. This script will produce some formated output, this output I have to spool in another text file. Currently I have given this in script file as following
Spool... (2 Replies)
Discussion started by: shekharjchandra
2 Replies
6. Programming
Hi,
I have 2 tables.
Table1
name map_code data_code id
aaa 2732C 3333B 10
bbb 1223F 2545v 11
ccc 12
Table2
name map_code data_code id text_description
aaa 2732C 3333B 10 description 1
bbb 1223F 2545v 11 ... (3 Replies)
Discussion started by: vanitham
3 Replies
7. Shell Programming and Scripting
I haven't coded in ksh in forever and this script is proving me not a great coder. I keep getting unexpected end of file when I try to execute this...Line 94 is the last line of the code..
#!/usr/bin/ksh
. /home/oraprod/.bash_profile
DBSID=prod # Database sid
CONNECTSTR=apps/xxxxxxxx@prod #... (6 Replies)
Discussion started by: kirkladb
6 Replies
8. UNIX for Advanced & Expert Users
Hi,
Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out... (1 Reply)
Discussion started by: techmoris
1 Replies
LEARN ABOUT DEBIAN
sql::translator::filter::globals
SQL::Translator::Filter::Globals(3pm) User Contributed Perl Documentation SQL::Translator::Filter::Globals(3pm)
NAME
SQL::Translator::Filter::Globals - Add global fields and indices to all tables.
SYNOPSIS
# e.g. Add timestamp field to all tables.
use SQL::Translator;
my $sqlt = SQL::Translator->new(
from => 'MySQL',
to => 'MySQL',
filters => [
Globals => {
fields => [
{
name => 'modified'
data_type => 'TIMESTAMP'
}
],
indices => [
{
fields => 'modifed',
},
]
constraints => [
{
}
]
},
],
) || die "SQLFairy error : ".SQL::Translator->error;
my $sql = $sqlt->translate || die "SQLFairy error : ".$sqlt->error;
DESCRIPTION
Adds global fields, indices and constraints to all tables in the schema. The globals to add can either be defined in the filter args or
using a _GLOBAL_ table (see below).
If a table already contains a field with the same name as a global then it is skipped for that table.
The _GLOBAL_ Table
An alternative to using the args is to add a table called "_GLOBAL_" to the schema and then just use the filter. Any fields and indices
defined on this table will be added to all the tables in the schema and the _GLOBAL_ table removed.
The name of the global can be changed using a "global_table" arg to the filter.
SEE ALSO
perl(1), SQL::Translator
BUGS
Will generate duplicate indices if an index already exists on a table the same as one added globally.
Will generate duplicate constraints if a constraint already exists on a table the same as one added globally.
TODO
Some extra data values that can be used to control the global addition. e.g. 'skip_global'.
AUTHOR
Mark Addison <grommit@users.sourceforge.net>
perl v5.14.2 2012-01-18 SQL::Translator::Filter::Globals(3pm)