The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.
This
> y
> y
> y
> y
Continue to repair or build a new filesystem-
Do you want to build a new filesystem (y/n)?
> y
Oops ;-)
> ..
>
> On Fri, 2003-09-19 at 22:09, Tim Gorman wrote:
> > Great idea, Mark!
> >
> > By the way, does anyone remember the "yes" command in UNIX? Same
concept.
> > I think it
de new ways to crash Oracle I guess, with
> queries like "select rownum the_row from infinite_dual order by the_row".
> Hmm, perhaps this idea needs some additional thought? I'm sure it would be
> practical to create something which works eff
y
y
y
y
y
..
On Fri, 2003-09-19 at 22:09, Tim Gorman wrote:
> Great idea, Mark!
>
> By the way, does anyone remember the "yes" command in UNIX? Same concept.
> I think it was invented to answer ³yes² to any program which mindlessly
> prompt for ³yes/no² responses in situations where only ³yes² m
Tim Gorman wrote:
>
> Great idea, Mark!
>
> By the way, does anyone remember the "yes" command in UNIX? Same concept.
> I think it was invented to answer ³yes² to any program which mindlessly
> prompt for ³yes/no² responses in situations where only ³yes² makes sense.
> Case in point: ³fsck². A
Sorry for the last response in this thread which was truncated. Very
annoying! The full response looks as follows (hope this goes through in
it¹s entirety)...
-- Forwarded Message
Date: Fri, 19 Sep 2003 22:05:19 -0700
To: <[EMAIL PROTECTED]>
Great idea, Mark!
By the way, does anyone rememb
Great idea, Mark!
By the way, does anyone remember the "yes" command in UNIX? Same concept.
I think it was invented to answer ³yes² to any program which mindlessly
prompt for ³yes/no² responses in situations where only ³yes² makes sense.
Case in point: ³fsck². As in: ³Do you want to repair thi
> You raise an interesting idea in my mind...
>
> How useful would it be for us if Oracle created an INFINITE_DUAL table -
> One where you could select as many rows as you wished. I guess it might
be
> dangerous but it would at least be very efficient if Oracle coded it as a
> special table. Then
e recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]cc:
o
veloper (my wife, that is :)
>
> After posting my question to the list last night, I was told that the
query will be run against
> an Informix database :)
> Typical Developers !!! ;)
>
>
> Cheers!
>
> - Kirti
>
>
> --- Kirtikumar Deshpande <[EMAIL PROTECTED]> w
Describes a method for Oracle 9i where you don't have to worry that the table you are
using to generate sequential numbers does not have enough rows for your query.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Kirtikumar Deshpande
>
&g
--- Kirtikumar Deshpande <[EMAIL PROTECTED]> wrote:
> Hello Listers,
>
> I need some SQL help.
> Not sure if this is possible in plain SQL or not, but here it is:
> I have a table with two columns:
> EMPNBR LINENBR
> -- ---
>100 1
>200
Hi!
> This one is a very interesting consideration. The use of 'pivot' tables,
as in this case, without being something you meet daily is fairly frequent
(completing series like here is one usage, otherwise I commonly use them to
generate test data). It should be some standard feature, a kind of '
Hi Stephane,
I commiserate with you 8-)
Regards,
Guido
>>> [EMAIL PROTECTED] 17.09.2003 10.44 Uhr >>>
create viex xdual
as select rownum ID
from sys.col$;
Cannot have a column named rownum ... Going to be a difficult day. And we are only
half-week.
Regards,
Stephane Faroult
Oriole
--
Plea
create viex xdual
as select rownum ID
from sys.col$;
Cannot have a column named rownum ... Going to be a difficult day. And we are only
half-week.
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTEC
>- --- Original Message --- -
>From: "Mark Richard" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Tue, 16 Sep 2003 19:59:41
>
>
>I guess I should have added some criteria like:
>
>1) user_objects must have enough rows in it to
>cover the
value for max: 14
>
>LINENBR
>--
> 5
> 6
> 7
> 10
> 11
> 12
> 13
>
>7 rows selected.
>
>pollux.stats.scott> undef min
>pollux.stats.scott> undef max
>pollux.stats.scott> selec
You would require something like this:
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:504432994857
HTH
GovindanK
> Hello Listers,
>
> I need some SQL help.
> Not sure if this is possible in plain SQL or not, but here it is:
> I have a table with two co
rom dba_objects where rownum < (&&max-&&min)
2 minus select linenbr from kirti where linenbr > &&min and linenbr <
&&max)
3 /
Enter value for min: 4
Enter value for max: 10
LINENBR
--
5
6
7
3 rows selected
Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
ban.com.au> cc:
Sent by:
m too tired to start digging. Good luck. If anybody can find a solution,
you can.
On 2003.09.16 23:29, Kirtikumar Deshpande wrote:
Hello Listers,
I need some SQL help.
Not sure if this is possible in plain SQL or not, but here it is:
I have a table with two columns:
EMPNBR LINENBR
-- ---
rtikumar Deshpande
@yahoo.com> cc:
Sent by: Subj
Hello Listers,
I need some SQL help.
Not sure if this is possible in plain SQL or not, but here it is:
I have a table with two columns:
EMPNBR LINENBR
-- ---
100 1
200 4
300 8
400 9
50014
How would I find out the missing
t 28, 2003 3:45 PM
To: Multiple recipients of list
ORACLE-L
Subject: SQL HELP.
I have a table with the following columns:
- item
- carton_number -à(min)
- carton_number -à(max)
- qty -à(sum)
- weight -à(sum)
Item A has qty of 4515 and present in cartons 1 to 1129
Item B
3 5
and so on?
RegardsNaveen
-Original Message-From: Cabansay, Yoyong
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 3:45
PMTo: Multiple recipients of list ORACLE-LSubject: SQL
HELP.
I have a table with the following
columns:
-
item
- car
De-aggregating aggregated values is an endeavour comparable to putting the toothpaste
back into the tube. You can't.
If you have the detail somewhere, read about MINUS and INTERSECT, or possibly NOT
EXISTS.
>- --- Original Message --- -
>From: "Cabansay, Yoyong" <[EMAIL PROTECTED
I have a table with the following columns:
- item
- carton_number -à(min)
- carton_number -à(max)
- qty -à(sum)
- weight -à(sum)
Item A has qty of 4515 and present in cartons 1 to 1129
Item B has qty of 7255 and present in cartons 1 to 1129
Item C has qty of 400 and pre
"Mladen Gogala" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/27/2003 12:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: [Q] SQL Help!! How to make sele
AIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 3:00
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
[Q] SQL Help!! How to make select left justify and fill
space??LOL!
"Mladen Gog
LOL!
"Mladen Gogala" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/27/2003 10:04 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: [Q] SQL Help!! H
Use something like
FORMAT STDOUT=
@ @>
$id, $empname
->To: Multiple recipients of list ORACLE-L
:->Subject: [Q] SQL Help!! How to make select left justify and
:->fill space??
:->
:->
:->Can anyone tell me on select how can make it left
:->justify and fill space?
:->
:->example:
:->
:-> IDnumber(8)
:->
:->o
Title: RE: [Q] SQL Help!! How to make select left justify and fill space??
select rpad(to_char(id),8,' ')
from your_table
/
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this
:00 PMTo: Multiple recipients of list ORACLE-LSubject: SQL HELP!!!
Hello,
I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:
for a given date range, i..e. start_date - end_date ('01/01/2003', '12/31/
Can anyone tell me on select how can make it left
justify and fill space?
example:
IDnumber(8)
output:
12345 Emplyeename
^
|--- fill space
Thanks.
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://
can have facts, having an opinion is an art !
-Original Message-From: Viktor
[mailto:[EMAIL PROTECTED]Sent: Tuesday, August 26, 2003 5:00
PMTo: Multiple recipients of list ORACLE-LSubject: SQL
HELP!!!
Hello,
I was wondering if someone can help me with a report. I a
Viktor,
By using an inline view, count_web does indeed become a column.
Did you try the query?
Jared
Viktor <[EMAIL PROTECTED]>
08/26/2003 01:29 PM
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
cc:
Subject: Re: SQL HELP!!!
id||yr||seq_no||ck
)
group by received_date, msno, hardcopy
/
Viktor <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/26/2003 01:59 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]
nks again![EMAIL PROTECTED] wrote:
Viktor, By using an inline view, count_web does indeed become a column. Did you try the query? Jared
Viktor <[EMAIL PROTECTED]>
08/26/2003 01:29 PM
To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject:
een '01/01/2003' and '12/31/2003'
> group by id,
> &nbs! p; to_char(received_date, '-mm'),
> sequence_no,
> id||yr||seq_no||ck
> )
> group by received_date, msno, hardcopy
> /
>
>
>
ved_date between '01/01/2003' and '12/31/2003'> group by id,> &nbs! p; to_char(received_date, '-mm'),>
sequence_no,> id||yr||seq_no||ck> )> group by received_date, msno, hardcopy> /> > > > > Viktor <[EMAIL PROTECTED]>>
s!
p;
to_char(received_date, '-mm'), sequence_no, id||yr||seq_no||ck ) group by received_date, msno, hardcopy /
Viktor <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
08/26/2003 01:59 PM Please respond to ORACLE-L
To: Multiple recipients of list
_no,
id||yr||seq_no||ck
)
group by received_date, msno, hardcopy
/
Viktor <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/26/2003 01:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Hello,
I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:
for a given date range, i..e. start_date - end_date ('01/01/2003', '12/31/2003'), I need to count all "web", and "non-web" records. If seq_no > 4000, th
Good morning List,
Please bare with me, this is somewhat long with
the DDL and DML included.
I have two tables that are populated by triggers
to be used to audit data changes.
The source and target tables are identical in
structure with the addition of the DML and
sequence columns iin the target.
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 sear
28 AMcc:
Please respond toSubject: RE: PL/SQL help
in the sql; something
like: -
c_sql := 'select col1 from atable where col2 = :1 and :2 is null and :3 is
null';
--
David Lord
> -Original Message-
> From: Ron Thomas [mailto:[EMAIL PROTECTED]]
> Sent: 19 September 2002 19:53
> To: Multiple recipients of list ORACLE-L
>
I am building a dynamic sql statement which will contain varying number of bind
variables depending
on user selection criteria. As an example, the sql statement may be:
c_sql := 'select col1 from atable where col2 = :1' ;
or it may be
c_sql := 'select col1 from atable where col2 = :1 and c
lkins"
.net>cc:
Sent by: Subject:
1=1) x ) y
9* where y.cnt > 1
SQL> /
X
-
x
y
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: Thursday, September 12, 2002 4:48 PM
> To: Mu
Title: RE: SQL help
Rick,
Is this in SQL*Plus? If so, use the COLUMN command to
populate the column headings with the information you want. You can populate a
variable with SYSDATE and use that in the column heading.
Dan
-Original Message-From: Jamadagni, Rajendra
[mailto
Title: RE: SQL help
Not tested but
select sysdate, 'test1','test2'
from dual
where exists ( your union clause)
union
your_union_clause
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamad
Hi DBAs,
I have a query something like
SELECT sysdate,'txt1','txt2'
FROM dual
UNION
SELECT date1,txtfield1,txtfield2
FROM t1,t2,...,tn
WHERE
... ;
The output would be one header record from the first select then the data
from the second select.
If there are no records selected in second sel
I got it.Thank you Gurus for your reply.
Regards
syed
> > sultan wrote:
> >
> > Hi gurus
> >
> > I have two tables like this
> >
> >
> > SQL> select * from bb;
> >
> > ID AMOUNT DT
> > -- -- --
> > 1 1000
will also try without using view .
Regards
Sreeraman
- Original Message -
From:
sultan
To: Multiple recipients of list ORACLE-L
Sent: Monday, May 13, 2002 10:53 AM
Subject: SQL Help Urgent!
Hi gurus
I have two tables like this
SQL>
> sultan wrote:
>
> Hi gurus
>
> I have two tables like this
>
>
> SQL> select * from bb;
>
> ID AMOUNT DT
> -- -- --
> 1 1000 10-MAY-02
>
>
>
>
> SQL> select * from cc;
>
> ID AMOUNT
> --
: sultan
[mailto:[EMAIL PROTECTED]]Sent: Monday, May 13, 2002 10:53
AMTo: Multiple recipients of list ORACLE-LSubject: SQL
Help Urgent!
Hi gurus
I have two tables like this
SQL> select * from bb;
ID AMOUNT
Hi gurus
I have two tables like this
SQL> select * from bb;
ID AMOUNT
DT-- --
--
1
1000
10-MAY-02
SQL> select * from cc;
ID AMOUNT--
---
Hi gurus
I have two tables like this
SQL> select * from bb;
ID AMOUNT
DT-- --
--
1
1000
10-MAY-02
SQL> select * from cc;
ID AMOUNT--
---
1
based
on your business rules which should be deleted.
SQL> select * from junk where rowid in
2 (select row_id from exceptions e where e.table_name='JUNK');
ID COM CO STATUS
--- -- --
5521 ABC US 1
5521 ABC US -1
8877 DEF UK 0
887
k k wrote:
>
> Hello all,
>
> I need some SQL help .. I have a table with containing duplicate records but
> because they have differents status they really are duplicate .. i need to
> find these .. here is an example of what the table contains :
>
> IDCompany
t; Hello all,
>
> I need some SQL help .. I have a table with containing duplicate records
but
> because they have differents status they really are duplicate .. i need to
> find these .. here is an example of what the table contains :
>
> IDCompany Country Status
>
sq.Company AND
t.Country = sq.Country
Maybe that would suit?
HTH,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Monday, April 29, 2002 3:12 PM
To: Multiple recipients of list ORACLE-L
Hello all,
I need some SQL help ..
Hello all,
I need some SQL help .. I have a table with containing duplicate records but
because they have differents status they really are duplicate .. i need to
find these .. here is an example of what the table contains :
IDCompany Country Status
5521 ABC US 1
Hallo,
I have some trouble to get this pl/sql code right. Anyone whpom could help me with
this. It is important.
Hallo,
I have some trouble with this pl/sql procedure. I would like
that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in
the if statement, what
E-L
> Subject: Re: PL/SQL help
>
> 1. there isn't a host command in PL/SQL. Read up on external
> procedures for this. You need to be painfully aware of the
> security implications of this. You need to ask yourself if this
> is really necessary. If so, you can wr
>
Sent by: [EMAIL PROTECTED]
02/22/02 04:33 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: PL/SQL help
I do not know a way to enable DBMS from within a procedure either. The
second item Jar
ocs for it. there's a
built in procedure for this, dbms_output.enable.
Jared
"k k" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/22/02 01:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
util/debug_pipe/debug_pipe.html
Jared
Jonathan Gennick <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/22/02 02:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: PL/SQL help
You can
You can't SET SERVEROUTPUT ON from within a PL/SQL block,
because that's a SQL*Plus command, not a PL/SQL function.
You *can* invoke dbms_output.enable(), but that still
doesn't set the flag within SQL*Plus that tells SQL*Plus to
fetch and display the output.
If you tend to forget a lot, you coul
ple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:PL/SQL help
Hello,
How I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ??
Also is there a way to issue set serveroutput on from within a stored
procedure so that when someone run the st
Hello,
I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ??
Also is there a way to issue set serveroutput on from within a stored
procedure so that when someone run the stored procedure, the stored
procedure output will be seen even if the person forgot to set serveroutput
on
Hello,
How I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ??
Also is there a way to issue set serveroutput on from within a stored
procedure so that when someone run the stored procedure, the stored
procedure output will be seen even if the person forgot to set serveroutput
I suggest you go buy yourself a good PL/SQL manual. Nothing that
you are asking for here is all that complicated. I recommend the
O'Reilly book "The Oracle PL/SQL CD Bookshelf".
-Original Message-
[EMAIL PROTECTED]
Sent: Sunday, January 27, 2002 9:15 PM
To: Multiple recipients of list O
PROCEDURE A as
stack_info VARCHAR2(4096);
BEGIN
lv_time:=lv_time:= to_char(sysdate,'DD/MON/ HH:MI:SS AM');
dbms_output.put_line('Start-B -'||lv_time);
B;
lv_time:=lv_time:= to_char(sysdate,'DD/MON/ HH:MI:SS AM');
dbms_output.put_line('End-B -'||lv_time);
EXCEPTION
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
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_tim
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
I want to show all the available leave types in table "a" even if there are no records
in table "l"
-- Original Message --
Reply-To: [EMAIL PROTECTED]
Date: Wed, 12 Dec 2001 10:15:33 -0800
>SELECT a.LEAVE_CATEG_ID,
>a.LEAVE_TYPE_CD,
>a.LPE
SELECT a.LEAVE_CATEG_ID,
a.LEAVE_TYPE_CD,
a.LPET_LONG_DD,
Sum(l.ORIGINAL_INPUT_AM)
FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
WHERE a.LEAVE_TYPE_CD(+) = l.evnt_type_cd
AND l.INTERNAL_EMPL_ID='000357'
AND l.EFFECTIVE_DT Between TO_DATE('01/01/2001','M
Steve,
Generally, Sum and Group by functions do not prevent data from being
returned.
I'm not sure what you mean by not giving you the rows you expect. I would
look closely at the where clause to be sure you are selecting all the
records you want to get.
Select the rows without the group by t
This sql doesn't give me the additional rows I'm expecting.. Is this because of the
sum and group by expressions? Is there a way around this behaviour?
Oracle 8.1.6
SELECT
a.LEAVE_CATEG_ID,
a.LEAVE_TYPE_CD,
a.LPET_LONG_DD,
Sum(l.ORIGINAL_INPUT_AM)
FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_T
select distinct segment_type, owner, segment_name, tablespace_name from
dba_segments
This will get them all in one simple query.
-Original Message-
Sent: Saturday, July 21, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L
hi dba's
how to find out a users all objects+the tabl
Hi,
Try this query :- SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME IN (SELECT
SEGMENT_NAME FROM DBA_SEGMENTS);
Regards,
Anand.
-Original Message-
sreenivasa
Sent: Saturday, July 21, 2001 9:15 PM
To: Multiple recipients of list ORACLE-L
hi dba's
how to find out a users all objects+t
nvoyé : samedi 21 juillet 2001 15:45
À : Multiple recipients of list ORACLE-L
Objet : sql help
hi dba's
how to find out a users all objects+the tablespaces
in which they reside.
i tried using the flwng way:
select tablespacename,table_name from dba_tables
where obj in (select obj_nm from d
Srinivas:
Try this:
break on "TYPE"
SELECT 'TABLE' AS "TYPE"
, table_name AS object_name
FROM sys.dba_tables
WHERE owner = 'SCOTT'
UNION
SELECT 'INDEX'
, index_name
FROM sys.dba_indexes
WHERE owner = 'SCOTT'
UNION
SELECT 'CLUSTER'
, cluster_name
FROM
hi dba's
how to find out a users all objects+the tablespaces
in which they reside.
i tried using the flwng way:
select tablespacename,table_name from dba_tables
where obj in (select obj_nm from dba_objects where
obj_type ='table' and owner='xyz')
union
select for indexes
union
select for
Hi,
Select a, decode(sign(a), -1, 0, a-1) from
For summing up : sum(decode(sign(a), -1, 0, a-1))
Hope this helps
Bye
Sundar
Ravindra Basavaraja wrote:
> I have a table with a number column(Col A).I want to display A-1.There could
> be some negative values in
> this A-1 column.But I want t
select sum(column) where column > 0
or try a decode
-Original Message-
Basavaraja
Sent: Friday, July 20, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L
I have a table with a number column(Col A).I want to display A-1.There could
be some negative values in
this A-1 column.But I w
root@fatcity. Subject: sql help --urgent
I have a table with a number column(Col A).I want to display A-1.There could
be some negative values in
this A-1 column.But I want to display 0 whereever negative value appears.I
can use the ROUND(A-1) but this
will round the other positive value to the next positve integer which I
don't want to h
The MINUS operation is prety straight forward.
The result set from query 1 is compared to the result set of query 2 and any
records that exist in both are removed.
With this in mind, if your first query and your second query result sets
have NO RECORDS IN COMMON then you will ONLY get the record
Rivandra,
The minus operator is a set operator. It subtracts one
result set from another. That is, the rows from the second
result set that exist in the first result set are removed from
the first result set, and the remaining rows are returned.
To substract one sql numeric result from another,
I am writing a SQL query using the MINUS operator.Both the select statements
return a number result and I
am trying to get the o/p with the difference of both the queries using the
MINUS
between the two select statements.But I am getting the o/p of the first
query only
and the displayed result is
Use the function SUBSTR( TO_CHAR ( date_column, 'DAY' ),3) = 'FRI' in your
where clause
HTH!
Aleem
-Original Message-
Sent: Wednesday, March 14, 2001 6:11 AM
To: Multiple recipients of list ORACLE-L
Subject:SQL HELP
Hello,
Now I know this must have
Hello,
Now I know this must have been discussed here before,
but how do you construct SQL to get all the fridays
between 2 dates:
Sort of like:
SELECT some_date_column (want to see only fridays)
FROM some_table
WHERE...?
Thanks a lot.
__
Do You
97 matches
Mail list logo