Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Extracting all table names from a given server Post 302226505 by vidyadhar85 on Tuesday 19th of August 2008 06:37:06 AM
Old 08-19-2008
it depends on your database setup..
because dba_tables has been created by youe DBA's..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extracting Table names from a Select Stament

Hi, I am working on a code to extract the table names out of a select statement. Is there anybody who has worked on something similar? May be you could provide me with the regular expression for the same. Regards. Silas (2 Replies)
Discussion started by: silas.john
2 Replies

2. UNIX for Dummies Questions & Answers

Extracting column names from a table.. SQL with UNIX

:rolleyes: hi there everybody, i need help,... thanks anyway! i am working on a very huge table with the name table1. the problem is that i know only one field name in this table..., working with a ksh environment i don't know how to view the table to check out the field names :confused:. ... (4 Replies)
Discussion started by: fmina
4 Replies

3. Shell Programming and Scripting

extracting table with awk

Hi, I am new to awk and want to create a script that finds a string of text then prints the following table to a seperate file. I thought of using the / / identifier, but how do I retrieve the next 15 lines? gavin (6 Replies)
Discussion started by: gav2251
6 Replies

4. Shell Programming and Scripting

Show column names when access a table using perl

Hi all, I am using the following code in order to access the data of a table: my $sql = qq{ SELECT * FROM cc_test_cases}; $sth = $dbh->prepare( $sql ); $sth->execute( ); while(@row1 = $sth->fetchrow_array()) { # print "$row1: $row1\n"; print "@row1\n"; #print("THE VALUE... (1 Reply)
Discussion started by: chriss_58
1 Replies

5. Shell Programming and Scripting

extracting domain names out of a text file

I am needing to extract and list domain names out of a very large text file. The text file contains tlds .com .net .org and others as well as third level domains e.g. host1.domain.com and the names are placed within paragraphs of text. Domains do not have a http:// prefix so I'm thinking the... (6 Replies)
Discussion started by: totus
6 Replies

6. UNIX for Advanced & Expert Users

extracting the component names from SVN changes xml file

Hi All, The following is the sample xml which is generated by a tool called HUDSON when ever change occurs in SVN(Sub version namespace). In the given XML , path/paths tags ll be vary depends on no.of changes. now , my requirement is, need a script which can extract the payment and... (1 Reply)
Discussion started by: geervani
1 Replies

7. Web Development

MYSQL: Creating Dynamic Table Names 5.1

Hey everyone. Thanks for looking at this. I'm trying to create a table with the dynamic name of TableName + today's date. My variables are all happily created but the system chokes when I try to create the new table name example: Set @BFBW = CONCAT("BFBW", CURDATE()); Select @BFBW; ... (2 Replies)
Discussion started by: Astrocloud
2 Replies

8. Shell Programming and Scripting

Script to generate sheet with control-m table names

hi , i have control-m tool where i can schedule my unix script jobs to run automatically by created them in a table.. now i want a script to generate the sheet with table names that are created in cotrol-m tool... i dont know whether it possible or not.. thanks in advance. hemanth saikumar (6 Replies)
Discussion started by: hemanthsaikumar
6 Replies

9. Shell Programming and Scripting

URGENT HELP!!! Extracting db table into flat file

Hi All, I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far. 1. Table.txt ==> database extract file 2. flat.txt ==> pipe delimited after some manipulation of the original db... (0 Replies)
Discussion started by: express14
0 Replies

10. UNIX and Linux Applications

UNIX spool command not extracting complete record from the Oracle table

Hello All, I'm trying to spool an oracle table data into a csv file on unix server but the complete record is not being extracted. The record is almost 1000 characters but only 100 characters are being extracted and rest of the data getting truncated. I'm setting below options : SET... (4 Replies)
Discussion started by: venkat_reddy
4 Replies
Bio::Tools::Run::Alignment::DBA(3pm)			User Contributed Perl Documentation		      Bio::Tools::Run::Alignment::DBA(3pm)

NAME
Bio::Tools::Run::Alignment::DBA - Object for the alignment of two sequences using the DNA Block Aligner program. SYNOPSIS
use Bio::Tools::Run::Alignment::DBA; # Build a dba alignment factory my @params = ('matchA' => 0.75, 'matchB' => '0.55', 'dymem' =>'linear'); my $factory = Bio::Tools::Run::Alignment::DBA->new(@params); # Pass the factory a filename with 2 sequences to be aligned. $inputfilename = 't/data/dbaseq.fa'; # @hsps is an array of GenericHSP objects my @hsps = $factory->align($inputfilename); # or my @files = ('t/data/dbaseq1.fa','t/data/dbaseq2.fa'); my @hsps = $factory->align(@files); # or where @seq_array is an array of Bio::Seq objects $seq_array_ref = @seq_array; my @hsps = $factory->align($seq_array_ref); DESCRIPTION
DNA Block Aligner program (DBA) was developed by Ewan Birney. DBA is part of the Wise package available at <http://www.sanger.ac.uk/software/wise2>. You will need to enable dba to find the dba program. This can be done in a few different ways: 1. Define an environmental variable WISEDIR: export WISEDIR =/usr/local/share/wise2.2.0 2. Include a definition of an environmental variable WISEDIR in every script that will use DBA.pm: $ENV{WISEDIR} = '/usr/local/share/wise2.2.20'; 3. Make sure that the dba application is in your PATH. FEEDBACK
Mailing Lists User feedback is an integral part of the evolution of this and other Bioperl modules. Send your comments and suggestions preferably to one of the Bioperl mailing lists. Your participation is much appreciated. bioperl-l@bioperl.org - General discussion http://bioperl.org/wiki/Mailing_lists - About the mailing lists Support Please direct usage questions or support issues to the mailing list: bioperl-l@bioperl.org rather than to the module maintainer directly. Many experienced and reponsive experts will be able look at the problem and quickly address it. Please include a thorough description of the problem with code and data examples if at all possible. Reporting Bugs Report bugs to the Bioperl bug tracking system to help us keep track the bugs and their resolution. Bug reports can be submitted via the web: http://redmine.open-bio.org/projects/bioperl/ AUTHOR - Shawn Hoon Email shawnh@fugu-sg.org APPENDIX
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _ program_name Title : program_name Usage : $factory>program_name() Function: holds the program name Returns: string Args : None program_dir Title : program_dir Usage : $factory->program_dir(@params) Function: returns the program directory, obtained from ENV variable. Returns: string Args : version Title : version Usage : exit if $prog->version() < 1.8 Function: Determine the version number of the program Example : Returns : float or undef Args : none align Title : align Usage : $inputfilename = 't/data/seq.fa'; @hsps = $factory->align($inputfilename); or #@seq_array is array of Seq objs $seq_array_ref = @seq_array; @hsps = $factory->align($seq_array_ref); or my @files = ('t/data/seq1.fa','t/data/seq2.fa'); @hsps = $factory->align(@files); Function: Perform a DBA alignment Returns : An array of Bio::Search::HSP::GenericHSP objects Args : Name of a file containing a set of 2 fasta sequences or else a reference to an array to 2 Bio::Seq objects. or else a reference to an array of 2 file names containing 1 fasta sequence each Throws an exception if argument is not either a string (eg a filename) or a reference to an array of 2 Bio::Seq objects. If argument is string, throws exception if file corresponding to string name can not be found. If argument is Bio::Seq array, throws exception if less than two sequence objects are in array. _run Title : _run Usage : Internal function, not to be called directly Function: makes actual system call to dba program Example : Returns : nothing; dba output is written to a temp file Args : Name of a file containing a set of unaligned fasta sequences and hash of parameters to be passed to dba _parse_results Title : __parse_results Usage : Internal function, not to be called directly Function: Parses dba output Example : Returns : an reference to an array of GenericHSPs Args : the name of the output file _setinput() Title : _setinput Usage : Internal function, not to be called directly Function: Create input file for dba program Example : Returns : name of file containing dba data input Args : Seq or Align object reference or input file name _setparams() Title : _setparams Usage : Internal function, not to be called directly Function: Create parameter inputs for dba program Example : Returns : parameter string to be passed to dba during align or profile_align Args : name of calling object _query_seq() Title : _query_seq Usage : Internal function, not to be called directly Function: get/set for the query sequence Example : Returns : Args : _subject_seq() Title : _subject_seq Usage : Internal function, not to be called directly Function: get/set for the subject sequence Example : Returns : Args : perl v5.12.3 2011-06-18 Bio::Tools::Run::Alignment::DBA(3pm)
All times are GMT -4. The time now is 12:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy