Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

oracle views Expand / Collapse
oracle database already create views examples, how to see views sysntex in oracle
Poll ResultsVotes
j haven't answers
0%
0
Member Votes: 0, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Wednesday, June 6, 2012 5:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 28, 2013 1:38 AM
Points: 7, Visits: 27
i haven't answers
Post #1311748
Posted Wednesday, June 6, 2012 5:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:30 PM
Points: 12,918, Visits: 32,089
did you have a question? you can edit your post to provide the missing info so we can help.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1311760
Posted Wednesday, June 6, 2012 6:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 28, 2013 1:38 AM
Points: 7, Visits: 27
yes i have question how i find the after make views in oracle, how i can see main view sysntex in oracle?
pls help me.
Post #1311780
Posted Wednesday, June 6, 2012 6:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:30 PM
Points: 12,918, Visits: 32,089
alpeshchauhan (6/6/2012)
yes i have question how i find the after make views in oracle, how i can see main view sysntex in oracle?
pls help me.

the DESC (DESCRIBE) command is what you are looking for, i think:

DESC VIEWNAME; will show you the

CREATE OR REPLACE FORCE VIEW(ColumnList)
AS SELECT ColumnList....

is that what you are after?


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1311793
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse