10-21-2004
All you need to write PL/SQL is vi
Any editor will do.
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to substituted a variable to a file using sed. However, the value of that variable is not being substituted. Here is an example of my code.
lf='
'
v_whole="${1} ${2} ${3} $lf"
cp ${IPPDIR}/ctl/fax_sub_text_a.${4}.${5}.txt... (1 Reply)
Discussion started by: supercbw
1 Replies
2. UNIX for Dummies Questions & Answers
In a file I want to globally change a "|" charater by a new line character.
I am using the command
1,$s/\|/??/g
Can anybody say what should I put in place of ?? in the above command? (3 Replies)
Discussion started by: uLearner
3 Replies
3. Shell Programming and Scripting
Hi,
What is the actual difference between these two? Why the following code works for process substitution and fails for command substitution?
while IFS= read -r line; do echo $line; done < <(cat file)executes successfully and display the contents of the file
But,
while IFS='\n' read -r... (3 Replies)
Discussion started by: royalibrahim
3 Replies
4. Shell Programming and Scripting
All,
I have this text document that contains a listing(See below).
What i would like to ask is how i could extract just the information i need which is the files name (CWS*****.***.gz)
If anyone has any suggestions i would be very grateful. I am sure its relatively simple but i just... (6 Replies)
Discussion started by: Andyp2704
6 Replies
5. UNIX for Dummies Questions & Answers
Hello, I have a file with 10,000+ records which look like this:
Image3992170.tif 4/21/200811:42:09AM 3,373.13KB
Image3993265.tif 4/11/20087:17:58PM 2,369.72KB
Image3996764.tif 5/2/200811:01:28AM 2,155.87KB
Image3997700.tif ... (4 Replies)
Discussion started by: lotusdeva
4 Replies
6. Shell Programming and Scripting
How do i substitute ' with space in a file using sed or awk
i am getting the following two scenarios
1) xyz'd with xyz d
if i use
sed 's/xyz\\\'d/xy z/g'
it is taking ' after \ as closing expr for substitution
2) xyz';d with xyz d
please advice (8 Replies)
Discussion started by: mad_man12
8 Replies
7. UNIX for Dummies Questions & Answers
Hi experts,
Could someone help me how to figure out the following substitution?
I copied and pasted a column of names from an Excel file into another file in vi. The column of data has last names with dash (hyphens) and apostrophes. My goal is to do the following:
1) remove the apostrophes... (10 Replies)
Discussion started by: onlinelearner02
10 Replies
8. Shell Programming and Scripting
I am trying to do some substitutions using the substitution operator (:%s) in a text file.
I want to replace all A1, A2, A3.......A100 in my text file.
I used :%s/A2/SAE/g successfully until A9 but when I use A1, all the A11 to A19 is changed. How do I specify the exact match here? (8 Replies)
Discussion started by: Kanja
8 Replies
LEARN ABOUT DEBIAN
sql::translator::schema::procedure
SQL::Translator::Schema::Procedure(3pm) User Contributed Perl Documentation SQL::Translator::Schema::Procedure(3pm)
NAME
SQL::Translator::Schema::Procedure - SQL::Translator procedure object
SYNOPSIS
use SQL::Translator::Schema::Procedure;
my $procedure = SQL::Translator::Schema::Procedure->new(
name => 'foo',
sql => 'CREATE PROC foo AS SELECT * FROM bar',
parameters => 'foo,bar',
owner => 'nomar',
comments => 'blah blah blah',
schema => $schema,
);
DESCRIPTION
"SQL::Translator::Schema::Procedure" is a class for dealing with stored procedures (and possibly other pieces of nameable SQL code?).
METHODS
new
Object constructor.
my $schema = SQL::Translator::Schema::Procedure->new;
parameters
Gets and set the parameters of the stored procedure.
$procedure->parameters('id');
$procedure->parameters('id', 'name');
$procedure->parameters( 'id, name' );
$procedure->parameters( [ 'id', 'name' ] );
$procedure->parameters( qw[ id name ] );
my @parameters = $procedure->parameters;
name
Get or set the procedure's name.
$procedure->name('foo');
my $name = $procedure->name;
sql
Get or set the procedure's SQL.
$procedure->sql('select * from foo');
my $sql = $procedure->sql;
order
Get or set the order of the procedure.
$procedure->order( 3 );
my $order = $procedure->order;
owner
Get or set the owner of the procedure.
$procedure->owner('nomar');
my $sql = $procedure->owner;
comments
Get or set the comments on a procedure.
$procedure->comments('foo');
$procedure->comments('bar');
print join( ', ', $procedure->comments ); # prints "foo, bar"
schema
Get or set the procedures's schema object.
$procedure->schema( $schema );
my $schema = $procedure->schema;
equals
Determines if this procedure is the same as another
my $isIdentical = $procedure1->equals( $procedure2 );
AUTHORS
Ken Youens-Clark <kclark@cshl.org>, Paul Harrington <Paul-Harrington@deshaw.com>.
perl v5.14.2 2012-01-18 SQL::Translator::Schema::Procedure(3pm)