| Author: vipul 28 Aug 2008 | Member Level: Diamond | Rating:  Points: 3 |
hi,
please specify that you want to create a view or you want to get data from the view if you wnat to data from the view you used same as geting data from the table
select * from viewname
vipul,
http://dongavipul.blogspot.com
|
| Author: Amalraj Irudayamani 28 Aug 2008 | Member Level: Silver | Rating: Points: 3 |
in SQL Server use the following script:
create view tmpview as
select * from <yourtablename>
in Oracle,
create or replace view tmpview as
select * from <yourtablename>
this will create a view in your database schema.
you can join one or more tables in the select statement
and have the conditions in the where clause also.
to select the records from the created view, run
select * from <yourviewname>
|
| Author: kalyan kumar pasupuleti 28 Aug 2008 | Member Level: Gold | Rating: Points: 2 |
Hi Legend of Micro
Its a simple query
create view <view name> as
select * from <table name>
Regards
Kalyan Pasupuleti
|
| Author: Legend 29 Aug 2008 | Member Level: Silver | Rating: Points: 5 |
Thanks to all
|