Home » RDBMS Server » Server Administration » create view with parameters (11.2.0.1.0 Windos XP)
create view with parameters [message #528602] Wed, 26 October 2011 00:32 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I created a view with parameters l_id and l_name, how can i find them in oracle view?

Create Table tb_test
(
 Id Number,
 Name Varchar2(64)
);

Create Or Replace View vw_tb_test(l_id,l_name)
As
Select Id,Name From tb_test;

Re: create view with parameters [message #528606 is a reply to message #528602] Wed, 26 October 2011 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
user/all/dba_tab_columns.

Regards
Michel
Re: create view with parameters [message #528636 is a reply to message #528606] Wed, 26 October 2011 03:49 Go to previous messageGo to next message
cookiemonster
Messages: 11074
Registered: September 2008
Location: Rainy Manchester
Senior Member
Those aren't parameters. They're column aliases.
Re: create view with parameters [message #528637 is a reply to message #528636] Wed, 26 October 2011 03:58 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks Michel,

SQL> Select
  2   table_name,
  3   column_name
  4  From dba_tab_columns a
  5  Where table_name='VW_TB_TEST'
  6    Order By column_id;

TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------
VW_TB_TEST                     L_ID
VW_TB_TEST                     L_NAME
Previous Topic: How to compress index
Next Topic: rowid type and varchar2 type issue
Goto Forum:
  


Current Time: Thu Oct 23 11:05:20 CDT 2014

Total time taken to generate the page: 0.20009 seconds