10-28-2013
Quote:
Originally Posted by
mvalonso
Just the name of the tables separated by , or any other delimiter or one table name per line in the output. No preference. Just want to know the tables involved without having to look deeply in the source program.
Thks.
You want field name also ??
show output sample for given input.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I have sql query as follows. Please write a pro*c program for the following query.
select
sp1.cost_change
||','|| sp1.cost_change_desc
||','|| sp1.reason
||','|| to_char(sp1.active_date,'DD-MON-YYYY HH24:MI:SS')
||','|| sp1.status
||','|| sp1.cost_change_origin... (0 Replies)
Discussion started by: user71408
0 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
I have written 4 SQL queries. I want to write PRO*C program for this. I want to put these 4 queries in a single PR*C program using threading concept. Please guide me to write the pogram.
the queries are as follows.
1. select * from head;
2. select * from details;
3. delete from head... (0 Replies)
Discussion started by: user71408
0 Replies
3. Programming
In a pro*C program, I use query follow:
INSERT INTO radacct_wk
SELECT (select psid from cscterminfo where cscterminfo.TELNO = username), nasipaddress, acctstarttime, acctstoptime,
acctsessiontime, acctinputoctets, acctoutputoctets, acctterminatecause, framedipaddress
FROM radacct@DBSV_B;... (7 Replies)
Discussion started by: quynhtrang
7 Replies
4. Shell Programming and Scripting
I am trying to parse two files and get data that does not match in one of the columns ( column 3 in my case )
Data for two files are as follows
A.txt
=====
abc 10 5 0 1 16
xyz 16 1 1 0 18
efg 30 8 0 2 40
ijk 22 2 0 1 25
B.txt
=====
abc... (6 Replies)
Discussion started by: roger67
6 Replies
5. Programming
hi,
I have pro*c program running on sunsolaris 5.9.Currently the same program has been migrated to solaris 5.10.But the program is not giving the desired output.Do i need to recomplie the source code again.
Regards,
Megh (4 Replies)
Discussion started by: megh
4 Replies
6. Shell Programming and Scripting
Hello all, I tried searching for something similiar before posting but couldn't come up with anything that fit what I need.
In Linux, I'm trying to parse through a number of files and take the info in them and put it into mysql. My file is a dump from an expect script:
---filename... (3 Replies)
Discussion started by: hamanjam
3 Replies
7. Programming
Hi,
Can any one help me how to write a sql procedure in a pro *c file for selecting the data from a database and inserting the rows into a queue in a .pc file.
thanx in advance. (1 Reply)
Discussion started by: jhon1257
1 Replies
8. Shell Programming and Scripting
Hi Unix gurus..
I have a file which has below data, It has several MQ Queue statistics;
QueueName= 'TEST1'
CreateDate= '2009-10-30'
CreateTime= '13.45.40'
QueueType= Predefined
QueueDefinitionType= Local
QMinDepth= 0
QMaxDepth= 0
QueueName= 'TEST2'
CreateDate= '2009-10-30'... (6 Replies)
Discussion started by: dd_psg
6 Replies
9. Shell Programming and Scripting
I have an XML tag like this:
<property name="agent" value="/var/tmp/root/eclipse" />
Is there way using awk that i can get the value from the above tag. So the output should be:
/var/tmp/root/eclipse
Help will be appreciated.
Regards,
Adi (6 Replies)
Discussion started by: asirohi
6 Replies
LEARN ABOUT DEBIAN
sqlt-diagram
SQLT-DIAGRAM(1p) User Contributed Perl Documentation SQLT-DIAGRAM(1p)
NAME
sqlt-diagram - Automatically create a diagram from a database schema
SYNOPSIS
./sqlt-diagram -d|-f|--from|--db=db_parser [options] schema.sql
Options:
-o|--output Output file name (default STDOUT)
-i|--image Output image type ("png" or "jpeg," default "png")
-t|--title Title to give schema
-c|--cols Number of columns
-n|--no-lines Don't draw lines
--font-size Font size ("small," "medium," "large," or "huge,"
default "medium")
--gutter Gutter size between tables
--color Add colors
--show-fk-only Only show fields that act as primary
or foreign keys
--natural-join Perform natural joins
--natural-join-pk Perform natural joins from primary keys only
-s|--skip Fields to skip in natural joins
--skip-tables Comma-separated list of table names to exclude
--skip-tables-like Comma-separated list of regexen to exclude tables
--debug Print debugging information
DESCRIPTION
This script will create a picture of your schema. Only the database driver argument (for SQL::Translator) is required. If no output file
name is given, then image will be printed to STDOUT, so you should redirect the output into a file.
The default action is to assume the presence of foreign key relationships defined via "REFERENCES" or "FOREIGN KEY" constraints on the
tables. If you are parsing the schema of a file that does not have these, you will find the natural join options helpful. With natural
joins, like-named fields will be considered foreign keys. This can prove too permissive, however, as you probably don't want a field
called "name" to be considered a foreign key, so you could include it in the "skip" option, and all fields called "name" will be excluded
from natural joins. A more efficient method, however, might be to simply deduce the foriegn keys from primary keys to other fields named
the same in other tables. Use the "natural-join-pk" option to achieve this.
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
perl v5.14.2 2012-01-18 SQLT-DIAGRAM(1p)