Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\obj_views_browse.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Browsing a View</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:10:0Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Browsing a View" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12511-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface" title="Home" type="text/html" /> <link rel="up" href="obj_brows.htm" title="Managing Database Objects w..." type="text/html" /> <link rel="up" href="obj_views.htm" title="Managing Views" type="text/html" /> <link rel="up" href="obj_views_browse.htm" title="Browsing a View" type="text/html" /> <link rel="prev" href="obj_views_create.htm" title="Previous" type="text/html" /> <link rel="next" href="obj_views_edit.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="obj_brows.htm" title="Managing Database Objects w...">Managing Database Objects w...</a> > <a href="obj_views.htm" title="Managing Views">Managing Views</a> > Browsing a View</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="obj_views_create.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="obj_views_edit.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDDDEDF" name="CHDDDEDF"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL117" id="AEUTL117"></a>Browsing a <a id="sthref53" name="sthref53"></a>View</h1> <p>When you access a view in Object Browser, the Detail pane displays a report listing the columns in that view.</p> <p>To browse a view:</p> <ol> <li> <p>On the Workspace home page, click <span class="bold">SQL Workshop</span> and then <span class="bold">Object Browser</span>.</p> <p>Object Browser appears.</p> </li> <li> <p>From the Object list, select <span class="bold">Views</span>.</p> </li> <li> <p>From the Object Selection pane, select a view.</p> <p>The view definition appears displaying the appropriate columns.</p> </li> </ol> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref54" name="sthref54"></a> <h2><a name="AEUTL118" id="AEUTL118"></a>Summary of Available Views</h2> <p>Click the tabs at the top of the page to view different reports. <a href="#CHDFIIDD">Table: Available Views for Views</a> describes all available views.</p> <div class="tblformal"><a id="sthref55" name="sthref55"></a><a id="CHDFIIDD" name="CHDFIIDD"></a> <p class="titleintable">Available Views for Views</p> <table class="Formal" title="Available Views for Views" summary="This table describes the alternative views available when browsing a view in Object Browser." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t13">View</th> <th align="left" valign="bottom" id="r1c2-t13">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t13" headers="r1c1-t13"> <p>View</p> </td> <td align="left" headers="r2c1-t13 r1c2-t13"> <p>(Default) Displays the columns in the current view. Actions you can perform include:</p> <ul> <li> <p>Compile</p> </li> <li> <p>Drop</p> </li> </ul> <p><span class="bold">See Also:</span> <a href="obj_views_edit.htm#CHDHFEBF">"Editing a View"</a>, <a href="obj_views_compile.htm#BACBJHDI">"Compiling a View"</a>, and <a href="obj_views_drop.htm#CHDICEGI">"Dropping a View"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t13" headers="r1c1-t13"> <p>Data</p> </td> <td align="left" headers="r3c1-t13 r1c2-t13"> <p>Displays a <a id="sthref56" name="sthref56"></a>report of the data in the columns in the view. Actions you can perform include:</p> <ul> <li> <p><span class="bold">Query</span> - Enables you to sort by column. To restrict specific rows, enter a condition in the Column Condition field. Use the percent sign (%) for wildcards. From Order by, select the columns you want to review and click <span class="bold">Query</span>.</p> </li> <li> <p><span class="bold">Count Rows</span> - Enables you to count rows in the table.</p> </li> <li> <p><span class="bold">Insert Row</span> - Enables you to insert a row into the table.</p> </li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t13" headers="r1c1-t13"> <p>Grants</p> </td> <td align="left" headers="r4c1-t13 r1c2-t13"> <p>Displays a <a id="sthref57" name="sthref57"></a>list of grants associated with the columns in the view. Grant details include grantee, privilege, and grant options. Actions you can perform include <span class="bold">Grant</span> and <span class="bold">Revoke</span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t13" headers="r1c1-t13"> <p>UI Defaults</p> </td> <td align="left" headers="r5c1-t13 r1c2-t13"> <p>Displays <a id="sthref58" name="sthref58"></a>user interface defaults for forms and reports. User interface defaults enable developers to assign default user interface properties to a table, column, or view within a specified schema.</p> <p>Click <span class="bold">Edit</span> to edit existing user interface defaults. Click <span class="bold">Create</span> to initialize user interface defaults for views that do not currently have user interface defaults defined.</p> <p><span class="bold">See Also:</span> "<a href="../ui_default.htm">Managing User Interface Defaults" i</a>n <a href="../preface.htm"><span class="italic">Oracle Application Express Application Builder User's Guide</span>.</a>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t13" headers="r1c1-t13"> <p>Dependencies</p> </td> <td align="left" headers="r6c1-t13 r1c2-t13"> <p>Displays a report showing <a id="sthref59" name="sthref59"></a>objects referenced by this view, objects this view references, and synonyms for this view.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t13" headers="r1c1-t13"> <p>SQL</p> </td> <td align="left" headers="r7c1-t13 r1c2-t13"> <p>Displays the SQL necessary to re-create this view.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --></div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="obj_views_create.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="obj_views_edit.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de