Jared,
Point taken. I should do some testing instead of publish an opinion. I
still do not like the constraction, but that's a matter of
taste.
I have done some testing as well, because I think you were somehow
comparing apples and oranges: function a uses an implicit cursor, whereas
function b
There are times when running a test harness
through a single pl/sql is going to give you
a spurious result because of extra pinning
(of data blocks and library cache material)
may confuse the issue.
Technically, if the implicit code and the explicit
code were written to do exactly the same
.
Jared
Jonathan Lewis [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/30/2003 03:29 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: pl/sql open cursor question
There are times when running a test harness
I wasn't thinking of the boundary conditions,
I was thinking of the totally different mechanisms
that appear because you are running pl/sql rather
than (say) a loop in Pro*C that sends a pure
SQL statement 1,000 times to the database.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The
:29 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject: Re: pl/sql open cursor question
There are times when running a test harness
through a single pl/sql is going to give you
a spurious result because of extra pinning
(of data blocks
cursor for loops automatically close cursors.
dont use when others then null on code you are putting in an application. if
you have a bug you will have a hard time finding it. Its a fundamental flaw.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Hi
if we assume it is implements this way (see below) there will only be
one cursor since c_gid
is a bind variable and there for the cursor will be sharded from call
to call of the function.
create or replace function XYZ (gid in number) return varchar2 is
cursor cur1(c_gid number) is
To: Multiple recipients of list ORACLE-L
Sent: Sunday, December 28, 2003 12:39
PM
Subject: Re: pl/sql open cursor
question
Hi if we assume it is implements this way
(see below) there will only be one cursor since c_gidis a bind variable
and there for the cursor
Hi:
I thought in the orginal code (cursor cur1 is select C1 from tab1 where ID
= gid;), gid is a parameter passed in so it is already a bind variable. I
don't see any difference to what you proposed. Your method is just make
cur1 take a paramter? Am I wrong here?
Also what happens when your
What I don't understand is the loop construction:
Actually only one (row) is read form the cursor, and then the function is
left with a return. Because it's an unconditional return, the code within
the loop will either execute once, or never. When no data is found
NULL is returned. When an error
dont use when others then null on code you are putting in an
application.
if
you have a bug you will have a hard time finding it. Its a fundamental
flaw.
One place where I have found it justified, is in logon trigger where users
must be able to log on, despite any errors which occur in a
dont use when others then null on code you are putting in an application.
if
you have a bug you will have a hard time finding it. Its a fundamental
flaw.
One place where I have found it justified, is in logon trigger where users
must be able to log on, despite any errors which occur in a logon
Carel,
It might seem that the loop construct would be more expensive, but
it didn't appear that way on my test system. ( 9.2.0.4, RH 8.0 )
function a:
create or replace function a return varchar2
is
begin
for srec in (select dummy from ctest)
loop
return srec.dummy;
end loop;
Guang,
I agree with your analysis, looping on characters is not the faster you can do,
simply because there is a significant overhead (compared to C code for instance) in a
language such as PL/SQL - which might be perfectly acceptable in some circumstances,
much less so in very repetitive
Hi Stephane:
Thanks for your good suggestion. I compared the method you suggested and the orginal
one and it indeed boosted the performance (in my simple test). However the ONLY
problem I am having is that by doing TRANSLATE, I lost the original delimits. The new
method (you suggested)
Perl is a good tool for text processing. But our program is already written
in pl/sql long time ago and there are intensive db calls in this pl/sql
program. (text processing is only part of it). So I can not change that.
BTW I did a comparison study a while ago for some of our pl/sql packages
Guang,
Well you are almost there ... you need fifo structure namely a pl/sql array
1. create a local pl/sql array to store the delimiter (store the ascii value of the
delimiter to be safe) my_array (varchar2(5))
2. as you find a delimiter insert into the first position in the array and
PL/SQL is the fastest thing of them all when it comes to executing
SQL commands, but there are things which simply aren't practical
in 9.2 PL/SQL. Regular expression processing is one of those things.
Fortunately, you can mix the two. Without DBI, perl scripts simply
woudn't be very useful. Of
Would extproc_perl fit well enough, though, until 10g is here?
On Fri, 21 Nov 2003, Mladen Gogala wrote:
PL/SQL is the fastest thing of them all when it comes to executing
SQL commands, but there are things which simply aren't practical
in 9.2 PL/SQL. Regular expression processing is one of
I don't know about PL/SQL but here is how I would get separate words from a big string:
#!/usr/bin/perl -w
use strict;
my (@ARR);
while () {
chomp;
@ARR = split(/[^0-9a-zA-Z_\.,]/);
foreach (@ARR) {
print $_\n;
}
}
There is something called DBI and it can be used to
RTFM
RTFM
RTFM
RTFM
Do your homework! Read the oracle documents, buy a book from Amazon/Bookpool/Softpro
and put in a little effort.
If has_done_homework = 'Y'
then
list_answer = 'Y';
else
list_answer = 'NO!';
end if;
[EMAIL PROTECTED] wrote:
Hallo,
I would like to do the
[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
Hallo,
I would like to do the following with an sql( pl/sql) statement.
the answer to your question can be found by reading either the manuals or
any pl/sql book, with examples. this is the same thing as all the other
questions
begin
select 'y' into dummy
where table3.column = table1.column;
insert into table3 blah blah;
exception
when no_data_found then
begin
select 'y' into dummy
where table2.column = table1.column;
insert into table2 blah blah;
exception
when no_data_found then
Hello Roland,
Do you even need PL/SQL for what you want to do?
rsis I want to check whether field1 in table1 exists in
rsis table3. If so then I want an insert statement to be
rsis run...insert into table3
If the field *is* in table 3, you want to insert it into
table 3 again? I find that an
If you already have shell script front end, would it be acceptable to prompt
for the input in the shell script rather than in the procedure?
#!/bin/ksh
echo ENTER LOGIN
read USER
echo ENTER PASSWORD
stty -echo
read PASS
stty echo
echo ENTER WHAT IT IS
read INPUT
sqlplus -s -XXX
This should get you started
HTH
Jared
SQLPATH=''
USER_INPUT=''
while [ -z $USER_INPUT ]
do
echo Please enter a table owner:
read USER_INPUT
done
echo $USER_INPUT
sqlplus /nolog EOF
set echo on
connect scott/tiger
select
Thank you all. Your suggestions have clarified A LOT
of grey areas for me. I'm not an expert shell
programmer but I can certainly get by on these
suggestions!
Thanks again.
Saira
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Saira Somani
INET: [EMAIL PROTECTED]
. -- Kernighan
[EMAIL PROTECTED]
e.ny.us To:
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: PL/SQL
Question:Eliminate duplicate rows
by: cc:
[EMAIL PROTECTED]Subject: RE: PL/SQL
Question:Eliminate duplicate rows
.com
09/19/2003 01:54
PM
Please respond
Johann,
how about the following. what this does is, using the inner begin/end
block, catches when an insert would fail because of the PK failure and
ignores the error.
This is very quick and dirty - it will work fine if you are not working with
a huge amount of data.
declare
cursor c1 is
Easy way:
delete from table where rowid not in (select max(rowid) from table group by
PK);
Complicated way:
Alter table mytab enable constraint PK exceptions into exceptions;
Then, you should see how many rows are duplicated and use the method 1
on that set of rowids. If the table in question is
]
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: PL/SQL Question:Eliminate
duplicate rows
PROTECTED]
e.ny.us To:
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: PL/SQL
Question:Eliminate duplicate rows
.com
09/19/2003 01
Check SQL Reference for exception_clause when creating Primary Key.
Could help to do what you need just using SQL (no PL/SQL).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mercadante, Thomas F
Sent: Friday, September 19, 2003 2:55 PM
To: Multiple recipients of list
:
[EMAIL PROTECTED]Subject: RE: PL/SQL Question:Eliminate
duplicate rows
.com
Title: Message
quantity is neither a column name or a valid column alias. That's
what your error is telling you.
Allan
-Original Message-From: Milton C.
Craighead, Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday,
July 24, 2003 11:39 AMTo: Multiple recipients of list
Milton, do yourself a favor and sign up for OTN(http://otn.oracle.com)
you got access to full oracle docs online.
joe
Milton C. Craighead, Jr. wrote:
I'm having no luck resolving the following PL/SQL errors for a final
exam class project. We do not have access to metalink nor do we have
For the error: SP2-0158: unknown COLUMN option "line", "column total line" must be one word.. no spaces allowed. Can be total_line or just total.
Shamita
Shamita "Nelson, Allan" [EMAIL PROTECTED] wrote:
quantity is neither a column name or a valid column alias. That's what your error is
Kurt:
It appears that you are committing inside the loop in the same inner block
that the update is in. The commit is freeing up the rows. I find it a good
practice sometimes to do commits inside the inner block like that, on long
transactions.
Title: PL/SQL- cursors and commits
As the
book says, it fails with following error(9.2.0.1 on
Win2k).
declare*ERROR at line
1:ORA-01002: fetch out of sequenceORA-06512: at line 12
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Wiegand,
-8413HP :
+65-9067-8474
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of AshishSent: Saturday,
April 05, 2003 12:19 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: PL/SQL- cursors and
commits
As
the book says, it fails with following
Let me throw some shade onto the issue:
a) PL/SQL engine does not execute SQL statements - ever. It passes them
over to the SQL Executor engine.
b) PL/SQL is just a procedural enclosure of the SQL language. There is
another one: it's called Java.
c) Procedural part can be parsed either by
PL/SQL can be seen as a stand-alone interpreted language and can as such
exist in various environments. "Various envrionments" does in real life
mean the PL/SQL engine is found in both the Oracle server and in the Oracle
Forms tool. If an application needs to execute some PL/SQL it should (at
Janet,
Try the forums at http://java.sun.com or inquire at http://devtrends.oracle.com
Darrell
[EMAIL PROTECTED] 03/13/03 10:59AM
Hi,
Our app is strange. :-( We use pl/sql(9i) package to
create all the html and java script. I have two drop
down boxes on a form, the values for the second
You can enter them directly at the SQL prompt or you can store them in
database or keep them in files and run them with the @ command.
The choice is yours :O)
K.
-Original Message-
Sent: 05 March 2003 08:50
To: Multiple recipients of list ORACLE-L
Hello all,
I wanted to know
Use keyboard!
:-)
Use any text editor like vim or scite (synatax coloring is better) to write
you script and save it to the file.
Then run your script from sqlplus prompt
(sqlplus:@/home/...path and name of your file).
JP
On Wednesday 05 March 2003 09:49, you wrote:
Hello all,
I
Aside from docs at technet.oracle.com, a perfect book for you is Beginning Oracle
Programming, authored by Sean Dillon, Christopher Beck, and Tom Kyte. (ISBN #
1-861006-90-X)
This book sells for around $50.00 in the U.S., but it is one of the most useful books
I ever purchased.
Darrell
Santosh - I went to http://www.google.com http://www.google.com and
searched for the terms PL/SQL tutorial. I received several
interesting-looking sites.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 05, 2003 2:50
Title: RE: PL/SQL output on Client machine
Options:
1. You could use utl_file and write it to server and then
1.1 manually or automagicall FTP it to client
1.2 use UTL_TCP to ftp it to client.
2. On the server side, create a [global] temp table and load all the data into it.
2.1 then use
Dan,
Look
at the TO_DATE function. You can easily change your procedure to the
following:
PROCEDURE
set_expire_date ( p_user_group_id IN NUMBER DEFAULT
NULL,
p_product_id IN VARCHAR2 DEFAULT
NULL,
p_expire_date IN VARCHAR2 DEFAULT NULL)IS
local_date
date;
== added this
BEGIN
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: PL/SQL Date Format
Not good, Jared. Try this:
SQL select df1('01-JAN-03') from dual;
DF1('01-J
-
03-JAN-01
Oops! I don't know how you could do this other than
Jared,
SELECT df1('2002-13-01') FROM dual; -- :)
CREATE OR REPLACE PROCEDURE set_expire_date (
p_user_group_id IN NUMBER DEFAULT NULL,
p_product_id IN VARCHAR2 DEFAULT NULL,
p_expire_dateIN VARCHAR2 DEFAULT NULL
)
IS
ld_dummy
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: PL/SQL Date Format
Jared,
SELECT df1('2002-13-01') FROM dual; -- :)
CREATE OR REPLACE PROCEDURE set_expire_date (
p_user_group_id IN NUMBER DEFAULT NULL,
p_product_id IN VARCHAR2
How about:
create or replace function df1
( date_in varchar2 )
return date
is
v_test_date date;
x_date exception;
pragma exception_init(x_date, -1830);
v_source_date_format varchar2(20) := '-mm-dd';
begin
begin
v_test_date := to_date(date_in, v_source_date_format);
Title: RE: PL/SQL Date Format
Not good, Jared. Try this:
SQL select df1('01-JAN-03') from dual;
DF1('01-J
-
03-JAN-01
Oops! I don't know how you could do this other than to parse the string like you did and look for invalid_num exceptions. Or force the app software to handle
:
Please respond toSubject: RE: PL/SQL help
ORACLE-L
Title: RE: PL/SQL help
Go to Tom Kyte's sight and look for contexts - he explains a way to build sql statements using native dynamic sql and refcursors and contexts where the select statement and predicate is variable and the output might also be variable. I get there by searching
Ron
We've run into this problem and haven't really found a satisfactory answer.
It sounds like a job for dbms_sql, but the docs say its slower than native
dynamic sql. Has anyone tested this? One other alternative I can think of
(but have never tried) is to use dummy conditions in the sql;
We are using TOAD for the DBA team.
For the developers we got PlSqlDeveloper and it works fine.
You can check also www.quest.com for the new sql editor that they developed
recently.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Asunto: RE: PL/SQL Editor
Try free Toad at http://www.toadsoft.com/downld.html
regards
Ofer Harel
DBA team
Barak ITC
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L
Hi All,
which
Title: RE: PL/SQL Editor
I hate to seem like I don't have a sense of humour, but wouldn't a more ethical way be to pay for the full version of the product?
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
You said One note about the Freeware version
PL/SQL Developer.
http://www.allroundautomations.nl/plsqldev.html
very very good.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel
Enviado el: miércoles, 28 de agosto de 2002 9:13
Para: Multiple recipients of list ORACLE-L
Asunto: RE: PL/SQL
I really like Emace with PL/SQL+SQLplus mode.
It is KISS. :=)
mvh
HEnrik
--- [EMAIL PROTECTED] wrote:
Hi All,
which is the best PL/SQL editor available
as a trial version .
the editor should support Oracle sql,PL/SQL
and may or may not
support debugging.
The tool
of list ORACLE-L
Asunto: RE: PL/SQL Editor
Try free Toad at http://www.toadsoft.com/downld.html
regards
Ofer Harel
DBA team
Barak ITC
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L
Hi
/plsqldev.html
very very good.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel
Enviado el: miércoles, 28 de agosto de 2002 9:13
Para: Multiple recipients of list ORACLE-L
Asunto: RE: PL/SQL Editor
Try free Toad at http://www.toadsoft.com
://www.allroundautomations.nl/plsqldev.html
very very good.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel
Enviado el: miércoles, 28 de agosto de 2002 9:13
Para: Multiple recipients of list ORACLE-L
Asunto: RE: PL/SQL Editor
Try free Toad at http://www.toadsoft.com
can you please post URL for this program?
thx
bill
-Original Message-
Sent: Wednesday, August 28, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
I really like Emace with PL/SQL+SQLplus mode.
It is KISS. :=)
mvh
HEnrik
--- [EMAIL PROTECTED] wrote:
Hi All,
which is
.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel
Enviado el: miércoles, 28 de agosto de 2002 9:13
Para: Multiple recipients of list ORACLE-L
Asunto: RE: PL/SQL Editor
Try free Toad at http://www.toadsoft.com/downld.html
regards
Ofer Harel
DBA team
Barak ITC
Beware ... TORA is not free on Windows platform ... it is free however on
Linux ... Funny no once has mentioned Oracle's built-in editor that comes
with Forms ...
My preferences are
1. Vi
2. Vim
Raj
__
Rajendra Jamadagni MIS,
PROTECTED]
Subject: RE: PL/SQL Editor
Date: Wed, 28 Aug 2002 06:18:24 -0800
we're currently looking into this, too
Our developers like TOAD, but the licensing cost is pretty steep - $700 a
pop for the most pared down version. Quest was willing to offer us a
one-time half-price offer, but for the 50
I think, he's talking about Emacs - huge and powerful OS without text editor
:-)))
JP
On Wednesday 28 August 2002 17:43, you wrote:
can you please post URL for this program?
thx
bill
-Original Message-
Sent: Wednesday, August 28, 2002 9:53 AM
To: Multiple recipients of list
but if you are just doing PL/SQL Development they
work great.
From: Magaliff, Bill [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: PL/SQL Editor
Date: Wed, 28 Aug 2002 06:18:24 -0800
we're currently looking into this, too
Our
haven't looked at that in a while, but don't you have to install Developer
to use that? (It's not available standalone, is it?)
-Original Message-
Sent: Wednesday, August 28, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
Well, since someone else cares to mention it, I do use
PL/SQL Developer.
http://www.allroundautomations.nl/plsqldev.html
very very good.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel
Enviado el: miércoles, 28 de agosto de 2002 9:13
Para: Multiple recipients of list ORACLE-L
Asunto: RE: PL/SQL
Nope ... actually Procedure builder is a deprecated (sp?) product.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD:
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: PL/SQL Editor
Date: Wed, 28 Aug 2002 06:18:24 -0800
we're currently looking into this, too
Our developers like TOAD, but the licensing cost is pretty steep - $700 a
pop for the most pared down version. Quest was willing to offer us a
one-time
. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Wednesday, August 28, 2002 12:52 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: PL/SQL Editor
Hi,
Mail me and I will send it you.
Beest Regards
Henrik
--- Magaliff, Bill [EMAIL PROTECTED]
wrote:
can you please post URL for this program?
thx
bill
-Original Message-
Sent: Wednesday, August 28, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
I really like
they
work great.
From: Magaliff, Bill [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: PL/SQL Editor
Date: Wed, 28 Aug 2002 06:18:24 -0800
we're currently looking into this, too
Our developers like TOAD, but the licensing cost
Try free Toad at http://www.toadsoft.com/downld.html
regards
Ofer Harel
DBA team
Barak ITC
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L
Hi All,
which is the best PL/SQL
Dennis,
I'd guess that the developer did not try it correctly. Ask to see the code.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, August 21, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L
Tom - The developer reports that he tried this but
Tom - Thanks to you and everyone else for the great suggestions. He and I
are sitting down tomorrow to straighten this out. I was concerned that there
might be some PL/SQL oddity that I wasn't aware of (he is a pretty good
PL/SQL programmer). I appreciate your ruling that out.
Dennis Williams
Sounds like in the table the field c.marketcode is a char(3) instead of
varchar2(3).
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of
Is the field in question in table C defined as CHAR or VARCHAR2? If CHAR
that is why it is blank padded. Check datatype of variables
in pl/sql
Rick
Dennis,
In your PL/SQL program, did you try the RTRIM(date_field,' ') command?
I know that TRIM is new, but I thought it needed additional parameters to
tell it what to trim.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
Check the definition of table C. It sounds like it is defined as CHAR(3) instead of
VARCHAR2(3). I would also check the PL/SQL for using CHAR instead of VARCHAR2 for
storing the value -- the trim should have eliminated this problem if it was put in the
right place.
Kevin Kennedy
First Point
:www.compuware.com
-Original Message-
Sent: Wednesday, August 21, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: PL/SQl question
Dennis,
In your PL/SQL program, did you try the RTRIM(date_field,' ') command?
I know that TRIM is new, but I thought it needed
Dennis,
Try changing your insert statement to:
insert into JOBOFFERFACT_LOAD
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
MARKETINGCODE,
TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
PACKAGEPRICE,
Tom - The developer reports that he tried this but it didn't work. The third
position is still a space value. Thanks to everyone for the good replies.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 21, 2002 3:13 PM
To: '[EMAIL
Title: RE: pl/sql exception and whenever sqlerror
(see answer below - What a difference, a raise makes!)
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
I have a command procedure running a sql*plus script that
then runs a stored
procedure. (This is VMS
-Original Message-
Sent: Thursday, August 15, 2002 11:09 AM
I need a nice PL/SQL editor any advice ?
I prefer vi myself but your probably looking for something like
http://www.indus-soft.com/winsql/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farrell,
Free OraEdit
http://www.dkgadvancedsolutions.com/oraedit.htm
JP
On Thursday 15 August 2002 17:09, you wrote:
Hello,
I need a nice PL/SQL editor any advice ?
Thx for any advice
Regards
W.B
__
Do You Yahoo!?
HotJobs - Search Thousands
vi or vim.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Place for oracle [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: PL/SQL Editor.
Hello,
I need a nice PL/SQL editor any
I like RapidSQL from Embarcadero - but it's a bit pricy
for a pretty good and less expensive alternative try PL/SQL Developer from
allroundautomations
-bill
-Original Message-
Sent: Thursday, August 15, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
Hello,
I need a nice
Title: RE: PL/SQL Editor.
Hi,
I use Emacs with PL/SQL module and Sqlplus.el
Really nice and easy to use.
Best Regards
Henrik
-Original Message-
From: Place for oracle
To: Multiple recipients of list ORACLE-L
Sent: 8/15/2002 5:09 PM
Subject: PL/SQL Editor.
Hello,
I need
TOAD is a very good one with a lot of useful options
like commands configuration:
you type: crbl ctrlspace
you get:
DECLARE
CURSOR c1 IS
SELECT FROM WHERE;
c1rec c1%ROWTYPE;
BEGIN
OPEN c1;
LOOP
FETCH c1 INTO c1rec;
EXIT WHEN c1%NOTFOUND;
END LOOP;
CLOSE
recipients of list
ORACLE-L
Subject: Re:RE: PL/SQL Editor.
Scott,
vi, your dinosaur side is showing!! *-)
Dick Goulet
Reply Separator
Subject:RE: PL/SQL Editor.
Author: [EMAIL PROTECTED]
Date: 8/15/2002 8:38 AM
vi or vim
-Original Message-
Scott,
vi, your dinosaur side is showing!! *-)
Oh come on. He included vim. ;
Cheers,
Thom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farrell, Thomas M.Mr. NGB-ARNG
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Reply Separator
Subject:RE: PL/SQL Editor.
Author: [EMAIL PROTECTED]
Date: 8/15/2002 8:38 AM
vi or vim.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Place for oracle [SMTP:[EMAIL PROTECTED]]
Sent
, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: PL/SQL Editor.
I like RapidSQL from Embarcadero - but it's a bit pricy
for a pretty good and less expensive alternative try PL/SQL Developer from
allroundautomations
-bill
-Original Message-
Sent: Thursday
1 - 100 of 385 matches
Mail list logo