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@(protected)
--
http://www.freelists.org/webpage/oracle-l