| Buddhu |
Posted: May 08, 2007 02:07:38 AM |
Total Post: 4
Joined: Dec, 2006
|
Hi
I am working as SE and i need one help. Can i create a view with the data from another view.When i was trying to do that it is showing error as "column ambiguously defined"
Please help..its urgent.
Bharathi. |
|
|
 Rush |
| Posted: May 08, 2007 02:58:13 AM |  |
|
Total Post: 127
Joined: Jan, 2007
|
hi Bharathi,
you can create view from another view smoothly.however always use
"OR REPLACE" key word when creating view.column ambiguosly defined is prolmen of selecting same column name from more than one source.so specify <NAME OF TABLE/VIEW>.<COLUMN NAME>.you can create alias of table or view also if table or view is long.
thanks and regads
RUPESH
|
|
|
|
|
| Buddhu |
| Posted: May 08, 2007 03:04:40 AM | |
|
Total Post: 4
Joined: Dec, 2006
|
Hi
I tried to create like that but it is showing error.
|
|
|
|
|
| Rush |
| Posted: May 08, 2007 03:07:09 AM | |
|
Total Post: 127
Joined: Jan, 2007
|
you r creating view from another view???have create view privilage??
plz give your work step wise.what are you doing and where is the error message.
|
|
|
|
|
| Oracle Virus |
| Posted: May 09, 2007 05:06:13 AM | |
|
Total Post: 50
Joined: Jan, 2007
|
Hi Buddhu,
Column ambiguosly defined is very common error. May be in your view you had taken 2 or 3 tables/views and gave aliases to those. Am I right?? Now you are pointing the columns like the following.
1. select a.qty, b.unit_price from orders a, bom b where a.doc=b.doc;
The following query will throw the exact error what you got. This is because I forgot to give alias to unit_price column.
select a.qty, unit_price from orders a, bom b where a.doc=b.doc;
Just check your view and give the alias.
With Best Regads,
Aneel Kanuri
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
