RE: questions about views
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: skuhn@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 16 Jul 2007 08:21:25 -0500
Several answers:
1. Try looking at the documentation, its pretty well documented there.
2. To add a simple column key for a view, you can show the rownum, but for the
life of me I cant think why you would want to, since it wont be stored anywhere.
3. To show a combined column, use the concat function (||). Ok, some people
on the list will think I am too kind, but try looking at (1), and read the doc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Stefan Kuhn
Sent: Monday, July 16, 2007 4:00 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: questions about views
Hi all,
I am new to oracle and views and I have two questions:
1. How can I add a new integer columns, which can simply start with 1 and
count, as a primary key to a view I. e. i have have the select query, which
is fine, and I just want the new column as the first column in the table.
2. Can I put two queries in one view? I have a table, which has two columns,
the values of these columns are supposed to go in one column. No problem to
select one of them, but I have no idea how to do it with both columns.
Thanks for help
Stefan
--
Stefan Kuhn BSc MA
IPB Halle
AG Bioinformatik & Massenspektrometrie
Weinberg 3
06120 Halle
http://www.ipb-halle.de http://msbi.bic-gh.de
skuhn@xxxxxxxxxxxx Tel. +49 (0) 345 5582 1474 Fax.+49 (0) 345 5582 1409
--
//www.freelists.org/webpage/oracle-l
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts: