Title: RE: SQL question
select *
from(select 'a' from dual union select 'b' from dual union select 'c' from dual ...)
minus
select distinct code
from table
/
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
Jonathan Gennick has an excellent article in Oracle magazine (sept./oct.),
which should help.
He demonstrates two approaches: with and without pivot table.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Title: RE: SQL question
Steve,
select 'select a.code ' || chr(10) || ' from(' ||
from dual
union
select distinct 'select ' || || code || || ' code from dual ' || chr(10) || 'union' ||
from my_code_table
union
select ')' || chr(10) || 'minus' from dual
/
select 'select distinct
: Any clod can have facts, but having an
opinion is an art!
-Original Message-
From: Steven Haas [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: SQL question
Dan (and Charlie),
Thanks.
Good suggestions
Sorry, forgot to provide a link:
http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 23, 2002 2:33 PM
Jonathan Gennick has an excellent
what are the 1700 values
if the are all alphabetic and not too long you could do something like the
below though it's all getting a bit long-winded
select
chr(65+(floor((rownum-1)/676)))||chr(65+(floor((mod(rownum-1,676))/26)))||ch
r(65+(mod(rownum-1,26)))
from addresses -- any table big
Title: RE: SQL question
Maybe I think differently, I usually let server think about size or the number of clauses ...
if you have codes in a table what's wrong with ...
select distinct code
from my_code_table
minus
select distinct code
from my_data_table
/
???
Raj
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
I have a question for from one of my developers related to PL/SQL and how
data is loaded.
I have a field (marketcode) that is defined as VARCHAR2(3).
I have a problem when I try to load the value of '20' into this field.
All values with three characters work fine. The problem is when
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
:
Sent by: Subject: PL/SQl question
[EMAIL PROTECTED]
m
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
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.
PL/SQL snippets
...snip...
marketingcodeVARCHAR2(3);
...snip...
FILELOCATION :=
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
um...just a thought but how about setting
marketingcode to char(3) in the PL/SQL code snippet.
I ran into this similar problem a couple days ago.
Had a var as varchar2 in PL/SQL but in the table it
was char. Changed my PL/SQL var to char, cursor in my
code worked with ltrim and rtrim functions
Geez, after re-reading my post, it seems that it
didn't make much sense to me, so to clarify...
I had a cursor in my procedure that took as an IN
param a varchar2 variable. The cursor failed to
return any rows because in my where clause I was
comparing a char field against a varchar2 variable.
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
Viktor wrote:
Hello All,
It looks as if I've hit a brick wall and I'd very much
appreciate if you can help.
desc Names
FIRST_INIT NOT NULL CHAR(4)
SECOND_INIT NOT NULL CHAR(1)
INIT_SEQUENCE NOT NULL NUMBER
LAST_NAMEVARCHAR2(30)
FIRST_NAME
Hello All,
It looks as if I've hit a brick wall and I'd very much
appreciate if you can help. I've got a query that has
to get some names and tie them to members. Name table
is the main table with and member table is child
table.
desc Names
FIRST_INIT NOT NULL CHAR(4)
SECOND_INIT NOT
Hello All,
It looks as if I've hit a brick wall and I'd very much
appreciate if you can help.
desc Names
FIRST_INIT NOT NULL CHAR(4)
SECOND_INIT NOT NULL CHAR(1)
INIT_SEQUENCE NOT NULL NUMBER
LAST_NAMEVARCHAR2(30)
FIRST_NAME VARCHAR2(20)
FLAG
Are you looking for something trivial like:
select n.first_name, 'E.' middle_initial,n.last_name,m.mem_init_sequence
from names n, member m
where n.first_init=m.mem_first_init and
n.second_init=m.mem_second_init
order by 1 desc, 2 asc;
On 2002.06.08 01:33 Viktor wrote:
Hello All,
Hi,
I have a table with 1 field and 2 dates: field1, date1, date2. I need to find the
max value of date2 for all the field1, date1 combinations. Then I want to join the
table to itself on field1 and find all the rows where field1 matches, date1 date1,
and max(date2) max(date2). I did
Try this
select a.f1, a.d1, a.d2
from
(select field1 f1,date1 d1,max(date2) d2 from temp group by field1,date1)
a,
(select field1 f1,date1 d1,max(date2) d2 from temp group by field1,date1)
b
where a.f1 = b.f1
and a.d1 b.d1
and a.d2 b.d2
-Original Message-
Sent: Friday, May 31,
I'm sure you're already aware of this, but the
substr/instr is not as complicated as it looks since
instr takes 4 parms, the 4th of which makes cycling
through fields 1=8 easy.
hth
connor
--- Deshpande, Kirti [EMAIL PROTECTED]
wrote: Stephane,
Thanks.
Nice idea :)
I will pass on this
Hi Conner,
Yes, I agree.
But its the 'green bean' developers that I am dealing with :)
Regards,
- Kirti
PS : Your BCHR enhancer code is coming extremely handy :) Great Job, you
did !!
-Original Message-
Sent: Thursday, May 30, 2002 4:23 AM
To: Multiple recipients of list
I need some help...
The database table has following structure.
commision_id number
com_text_msg varchar2(500)
The second column contains data fields that are delimited by ~ and
delimiter's position varies. But there are only eight data fields in the
column.
Is there a way in SQL, other
What about
select commission_id, replace(com_text_msg,'~',chr(9))
from tab1
which would work if going to a tab separated file for something like excel.
Whats wrong with substr/instr?
Iain Nicoll
-Original Message-
Sent: Wednesday, May 29, 2002 7:22 PM
To: Multiple recipients of list
Thanks.
Substr/instr was rejected because it was a bit difficult to read the code.
Also, they wanted to extract the fields in their own column headings (new
requirement). So 'replace' may not fly much !!
- Kirti
-Original Message-
Sent: Wednesday, May 29, 2002 1:45 PM
To: Multiple
Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Wednesday, May 29, 2002 2:45 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Question
What about
select
Kirti - We have a denormalized table like this in one database. An excellent
moral lesson for those who doubt the wisdom of normalization.
My first choice would be to lobby to redesign this table. The longer
it remains and the more programs are built around this design, the more
painful
Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Wednesday, May 29, 2002 2:45 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Question
What about
select commission_id, replace
Dennis,
Thanks for the ideas, but...
1. Not going to happen. It's a production system already in place (Vendor
designed? But, of course!!)
2. See above.
This is what happens when someone decides to write their own reports against
tables that were not designed by themselves. Damagement
if you are going to use a shadow table, how about a trigger on the
original table that parses the field into separate columns and does an
insert into the shadow table? Update if necessary (not all that
difficult, just replace all the parsed fields in case) and delete,
depending on the types of
An oversimplification no doubt... But what about creating a snapshot
table for reporting?
It would be much less painfull then revisiting the column names every
time a report is requested.
Now, getting a spec of reporting fields can be a challenge it its own
right but... The snapshots do work
Deshpande, Kirti wrote:
Thanks.
Substr/instr was rejected because it was a bit difficult to read the code.
Also, they wanted to extract the fields in their own column headings (new
requirement). So 'replace' may not fly much !!
- Kirti
-Original Message-
Sent: Wednesday,
Would they allow you to create a view with substr/instr and then just code off
of the view?
-Original Message-
Sent: Wednesday, May 29, 2002 3:30 PM
To: Multiple recipients of list ORACLE-L
Kirti - We have a denormalized table like this in one database. An excellent
moral lesson for
What about creating a view and hiding 'unreadable SQL' in view definition,
and granting 'select on' view instead of table.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 4:00 PM
Another nice idea !
I will pass it on.
Looks like instr/substr can not be avoided... :(
Thanks.
- Kirti
-Original Message-
Sent: Wednesday, May 29, 2002 3:32 PM
To: Multiple recipients of list ORACLE-L
Would they allow you to create a view with substr/instr and then just code
Stephane,
Thanks.
Nice idea :)
I will pass on this idea to them... Hope it flies..
Looks like either a function or a view around the 'ugly' code is the only
choice.
- Kirti
-Original Message-
Sent: Wednesday, May 29, 2002 3:32 PM
To: Multiple recipients of list ORACLE-L
Stephane,
comma_to_table converts it to a pl/sql table.
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: Any clod
Not sure if they would agree to snapshots, but I will suggest it anyway..
Thanks.
- Kirti
-Original Message-
Sent: Wednesday, May 29, 2002 3:26 PM
To: Multiple recipients of list ORACLE-L
An oversimplification no doubt... But what about creating a snapshot
table for reporting?
It
Kirti - My guess is that this application was not developed on Oracle
originally. My experience is that sometimes these transplanted applications
don't scale well at the enterprise level. Depending on your organization's
goals, this may be an issue to raise, whether it will support the
PROTECTED]
30-05-2002 04:22 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:SQL Question
I need some help...
The database table has following structure.
commision_id number
com_text_msg
Kirti,
my first thought and fwiw would be to write a PL/SQL routine.
Mike
-Original Message-
Sent: Wednesday, May 29, 2002 11:22 AM
To: Multiple recipients of list ORACLE-L
I need some help...
The database table has following structure.
commision_id number
com_text_msg
Mike,
They were looking for a SQL solution first.
Now a view (hiding substr/instr) looks like an acceptable thing :)
Thanks.
- Kirti
-Original Message-
Sent: Wednesday, May 29, 2002 9:38 PM
To: Multiple recipients of list ORACLE-L
Kirti,
my first thought and fwiw would be to
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
30-05-2002 04:22 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:SQL Question
I need some help...
The database table has following structure
Thanx Stephane . I did the same
STAARSHIP TECHNOLOGIES
www.staarship.com
Kranti Pushkarna
Project Leader
Tel: +91-22-6931557
__
Failure to prepare is preparing to
-From: kranti pushkarna
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 30,
2002 3:48 AMTo: Multiple recipients of list
ORACLE-LSubject: Sql Question
Hi
List,
Can someone give a SQL query to retuen all values in paricular column in comma
separed format.
e.g. suppose I
fire
Hi
List,
Can someone give a SQL query to retuen all values in paricular column in comma
separed format.
e.g. suppose I
fire "select deptno from dept" the output would be like
Deptno
10
20
30
40
I want the output
like 10,20,30,40.
I am just
wondering can it be done in a single query.
It cannot. You have to write a PL/SQL function which returns a VARCHAR for that.
- Original Message -
From: kranti pushkarna
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Mon, 29 Apr 2002 23:48:20
Hi List,
Can someone give a SQL query to
How do I list all user accounts created in a database? And how do I list
all user table indexes?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
-How do I list all user accounts created in a database?
SELECT * FROM DBA_USERS
-And how do I list all user table indexes?
SELECT INDEX_NAME FROM DBA_INDEXES WHERE OWNER = 'MY_LUSER'
Dave
-Original Message-
Sent: Wednesday, April 24, 2002 11:24 AM
To: Multiple recipients of list
David,
Look at DBA_USERS, DBA_TABLES, DBA_INDEXES and all other DBA_* views. All
the info you are asking about is provided in these views.
User: Select username from dba_users;
Indexes: select table_name,index_name from dba_indexes where owner not in
('SYS','SYSTEM')
Hope this helps.
Tom
David,
Basic sqlplus as the dba.
Select username from dba_users;
select owner,index_name from dba_indexes there owner not in
('SYS',SYSTEM');
Brush up on your reading skills.
ROR mô¿ôm
[EMAIL PROTECTED] 04/24/02 12:23PM
How do I list all user accounts created in a database? And how do I
list
Select * from all_users
Volker Schoen
INPLAN RUHR
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 24. April 2002 18:24
An: Multiple recipients of list ORACLE-L
Betreff: SQL question
:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 24. April 2002 18:24
An: Multiple recipients of list ORACLE-L
Betreff: SQL question
How do I list all user accounts created in a database? And how do I list
all user table indexes?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
anyone whom can tell me why this statement fails in a pl/sqll code:
I get this error message
PLS-00103: Encountered the symbol ||AvdNr|| when expecting one of the following:
. ( * @ % = - + / at in mod not rem then
an exponent (**) or != or ~= = = and or like
betwe
when i run
PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Pl/sql question - if
statement
: Pl/sql question - if statement
om
Yes but then it fails onthe word borttags_flagg, thi serrormessage :
PLS-00103: Encountered the symbol BORTTAGS_FLAGG when expecting one of the following:
. ( * @ % = - + / at in mod not rem then
an exponent (**) or != or ~= = = and or like
I reallydont see what the error is:
To: [EMAIL PROTECTED] (E-mail); [EMAIL PROTECTED] (E-mail);
oralist@lists (E-mail)
Subject: a PL/SQL question - how to catch errors without going
into
exceptions block
Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside a PL/SQL
proc) without jumping
Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside a PL/SQL proc)
without jumping to the EXCEPTION block
OR
is there a way to jump back to the body of the proc from the EXCEPTION block
(i know that GOTO can not do it).
For example , assume i have users with IDs 1,2,5,6 in
PROTECTED] (E-mail);
oralist@lists (E-mail)
Subject: a PL/SQL question - how to catch errors without going into
exceptions block
Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside a PL/SQL
proc) without jumping to the EXCEPTION block
OR
is there a way to jump back
: Thursday, April 04, 2002 1:44 PM
To: Multiple recipients of list ORACLE-L
Subject: a PL/SQL question - how to catch errors without going into
except
Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside a PL/SQL
proc)
without jumping to the EXCEPTION block
many ways to do that ,
you can put begin .. end block around select .. inside while condition
i := 1;
while i 10 loop
Begin
select the_name from the_table into myvar where the_id = 1;
Exception
when no data found then
null;
End ;
end loop;
or
) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: a PL/SQL question - how to catch errors without going
into ex
)
Subject: a PL/SQL question - how to catch errors without going into
exceptions block
Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside a PL/SQL
proc) without jumping to the EXCEPTION block
OR
is there a way to jump back to the body of the proc from the EXCEPTION
block
Bronfin
Sent: Thu, April 04, 2002 9:50 PM
To: [EMAIL PROTECTED] (E-mail); [EMAIL PROTECTED] (E-mail);
oralist@lists (E-mail)
Subject: a PL/SQL question - how to catch errors without going into
exceptions block
Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside
-
From: Andrey Bronfin
Sent: Thu, April 04, 2002 9:50 PM
To: [EMAIL PROTECTED] (E-mail); [EMAIL PROTECTED] (E-mail);
oralist@lists (E-mail)
Subject: a PL/SQL question - how to catch errors without going
into
exceptions block
Dear gurus !
I'm wondering whtether i can catch
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 2:44 AM
To: Multiple recipients of list ORACLE-L
Subject:a PL/SQL question - how to catch errors without
going into except
Dear gurus
create a function getSoftwares(p_licence_id ) which returns varchar2
string of softwares and then simply run query on licence table
select licence_id , getSoftware(licenceid)
from licence ;
I hope you know what to write in getSoftwares .
-ak
- Original Message -
To: Multiple
Hi all,
i have 2 tables software and licence. 1 licence can have many softwares.
softwares
name platform Licence_id
abc NT1
def WIN2K1
ghi all 2
i want to
You could use a user function. For example,
create or replace function lic_format (id in number) return varchar2
as
tmp varchar2(4000);
hold_tmp varchar2(50);
cursor c1 is
select name from software
where license_id = id;
begin
open c1;
loop
fetch c1 into hold_tmp;
exit when c1%notfound;
tmp :=
Write a PL/SQL function which takes the licence_id as argument and returns a
varchar2(... what you deem sufficient, up to 32K).
In the function, loop on the appropriate table and concatenate.
When you run
select licence_id, my_ugly_func(licence_id) softwares
from ...
you more or less
recipients of list ORACLE-L
Subject: sql question
Hi all,
I have a SQL question. Suppose I have a table called RANGE looks like
this:
begin end
1 9
1019
2029
Then I have a table NUMBERS that's full of bunch of numbers like this:
num
1
2
3
4
You are right that the range aren't necessarily contigous.
I'd probably have to write it in PL/SQL, I just want to see
if one can do this with SQL.
Thanks.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: sql question
]
Subject: Re: sql question
Date: Thu, 21 Feb 2002 21:33:20 -0800
Rich,
Are you sure that that is what you want ?
Suppose your range values were something like :
begin end
1 9
1519
2329
ie, the RANGE table shows that 10-14 and 20-22 are invalid (not allowed
probably have to write it in PL/SQL, I just want to see
if one can do this with SQL.
Thanks.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: sql question
Date: Thu, 21 Feb 2002 21:33:20 -0800
Rich,
Are you sure
Thanks Paul,
That worked.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: sql question
Date: Fri, 22 Feb 2002 07:53:39 -0800
How about :
select num
from NUMBERS,
( select begin, end from RANGE)
where num between
Hi all,
I have a SQL question. Suppose I have a table called RANGE looks like
this:
begin end
1 9
1019
2029
Then I have a table NUMBERS that's full of bunch of numbers like this:
num
1
2
3
4
...
98
99
100
I want to write a SQL that returns the number
To use your example column names:
select num from numbers where num between
(select min(begin) from range) and (select max(end) from range);
--- oracle dba [EMAIL PROTECTED] wrote:
Hi all,
I have a SQL question. Suppose I have a table called RANGE looks
like
this:
begin end
1
Krishnarao/IT/CHRT/ST Group)
Subject: Re: sql question
PROTECTED]]
Verzonden: dinsdag 12 februari 2002 14:28
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: Sql question
Zsolt,
Try:
select a.something
,c.searchvalue
from a,
b,
c
where a.a= b.a
and b.b1= c.b1
and b.b2= c.b2
and c.searchvalue
: Multiple recipients of list ORACLE-L
Onderwerp: Sql question
Hi,
I have the following sql:
select a.something
,c.searchvalue
from a,
b,
c
where a.a= b.a
and b.b1= c.b1
and b.b2= c.b2
and c.searchvalue= 'first one' and
c.searchvalue 'second one
Zsolt,
Try:
select a.something
,c.searchvalue
from a,
b,
c
where a.a= b.a
and b.b1= c.b1
and b.b2= c.b2
and c.searchvalue= 'first one' and
and not exists(select 1 from c c1
where c1.b1 = c.b1
Thomas,
NOT EXISTS and equals must be at least one
Right ?
That's not what Zsolt wants ... :-)
-Oorspronkelijk bericht-
Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 12 februari 2002 14:28
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: Sql
and equals must be at least one
Right ?
That's not what Zsolt wants ... :-)
-Oorspronkelijk bericht-
Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 12 februari 2002 14:28
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: Sql question
Zsolt,
Try:
select
wants ... :-)
-Oorspronkelijk bericht-
Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 12 februari 2002 14:28
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: Sql question
Zsolt,
Try:
select a.something
,c.searchvalue
from a,
b,
c
... :-)
-Oorspronkelijk bericht-
Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 12 februari 2002 14:28
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: Sql question
Zsolt,
Try:
select a.something
,c.searchvalue
from a,
b,
c
where a.a= b.a
Hallo,
anyone who canhelp me with this?
I have PL/sql procedure and if something goes wrong I would like the following things
to occur. Please help me with them
If some errors occur I want this to happen.
- pick out the name of the procedure thatis currently running,
-pick out the start_time
- pick out the name of the procedure thatis currently running,
check http://osi.oracle.com/~tkyte/who_called_me/index.html,
dbms_utility.get_call_stack, dbms_utility.get_error_stack
-pick out the start_time of the procedure
discussed some days ago
- pick outthe end_time of the procedure when it
Hi Roland,
Best way to do this is just set some variables at the start of your code:
l_proc_start := sysdate;
l_proc_name := 'proc_name';
begin
...commands...
exception
when exception then
l_proc_end := sysdate;
SELECT count(*)
INTO l_ins_count
Hi,
Not much experience with pl/sql but..
[EMAIL PROTECTED]@fatcity.com on 28-01-2002 09:40:20
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hallo,
:
Sent by:Subject: RE: Pl/sql question
[EMAIL PROTECTED
[EMAIL PROTECTED]
anais.com cc:
Sent by:Subject: RE: Pl/sql question
[EMAIL PROTECTED]
2002.01.28 11:20
Please respond to
ORACLE-L
Hi
by:Subject: RE: Pl/sql question
[EMAIL PROTECTED]
2002.01.28 11:20
Please respond to
ORACLE-L
Hi Roland,
Best way to do this is just set some variables at the start of your code:
l_proc_start
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 28, 2002 14:05
Oki thanks for info can you please show me an example with autonoumus
transactions? Please.
perhaps u could just go to http://technet.oracle.com and do some research
201 - 300 of 421 matches
Mail list logo