oracle8i [message #372263] |
Tue, 23 January 2001 10:52 |
alon
Messages: 2 Registered: January 2001
|
Junior Member |
|
|
Can you send me any presentation of oracle 8i(Different from oracle7, Tips and others) ?
Thanks
|
|
|
Re: oracle8i [message #372264 is a reply to message #372263] |
Tue, 23 January 2001 12:37 |
Vinod
Messages: 76 Registered: April 1999
|
Member |
|
|
Hi,
I have a table "product" with fields prod_id, price, price_type. price_type = "1" for market price and = "2" for special price.
How will I write a query to print prod_id, mkt. price, spc. price in one row. For each price_type "2" there will be a price_type "1" but not vice versa.
Thanks.
-Vinod.
|
|
|
Re: oracle8i [message #372266 is a reply to message #372264] |
Tue, 23 January 2001 14:14 |
me
Messages: 66 Registered: August 2000
|
Member |
|
|
select p1.prod_id, p1.price mkt_price, p2.price spcl_price
from product p1, product p2
where p1.price_type = '1'
and p1.prod_id = p2.prod_id(+)
and p2.price_type(+) = '2'
|
|
|
Re: oracle8i [message #372285 is a reply to message #372263] |
Mon, 29 January 2001 07:05 |
K.SREENIVASAN
Messages: 110 Registered: January 2001 Location: banglore
|
Senior Member |
|
|
1.YOU CAN DROP ANY COLUMN IN THE TABLE.
2.A LOT OF TRIGGERS ARE THER IN THE ORACLE 8I LIKE
AFTER OR BEFORE
LOGON,LOGOFF,STARTUP,SHUTDOWN,CREATE ,ALTER,DROP,
SERVERERROR
3.MATERIALISED VIEW
|
|
|