Advertisement
Guest User

Search Views report for SQL Developer

a guest
Oct 9th, 2014
284
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 4.75 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <displays>
  3. <display id="acaa1214-0148-1000-8001-0a0b0f1666b5" type="" style="Table" enable="true">
  4.     <name><![CDATA[SEARCH_VIEWS]]></name>
  5.     <description><![CDATA[]]></description>
  6.     <tooltip><![CDATA[]]></tooltip>
  7.     <drillclass><![CDATA[null]]></drillclass>
  8.     <CustomValues>
  9.         <TYPE>horizontal</TYPE>
  10.     </CustomValues>
  11.     <query>
  12.         <sql><![CDATA[with q as (
  13. select owner, view_name, text, upper(DBMS_METADATA.get_ddl('VIEW',view_name, owner)) md from all_views
  14. where owner like nvl(:owner, '%')
  15. )
  16.  
  17. select owner, view_name, text from q
  18. /*Skip CREATE OR REPLACE FORCE VIEW "<schema>"."<view>" part*/
  19. where dbms_lob.instr(md, upper(:search_text) )>=length('CREATE OR REPLACE FORCE VIEW "'||
  20. owner||
  21. '"."'||
  22. view_name||
  23. '"')]]></sql>
  24.         <binds>
  25.             <bind id="owner">
  26.                 <prompt><![CDATA[owner]]></prompt>
  27.                 <tooltip><![CDATA[owner]]></tooltip>
  28.                 <value><![CDATA[schema]]></value>
  29.                 <bracket><![CDATA[null]]></bracket>
  30.             </bind>
  31.             <bind id="search_text">
  32.                 <prompt><![CDATA[Enter search text]]></prompt>
  33.                 <tooltip><![CDATA[Enter search text]]></tooltip>
  34.                 <value><![CDATA[search string]]></value>
  35.                 <bracket><![CDATA[null]]></bracket>
  36.             </bind>
  37.         </binds>
  38.     </query>
  39.         <pdf version="VERSION_1_7" compression="CONTENT">
  40.             <docproperty title="" author="" subject="" keywords="" />
  41.             <cell toppadding="2" bottompadding="2" leftpadding="2" rightpadding="2" horizontalalign="LEFT" verticalalign="TOP" wrap="true" />
  42.             <column>
  43.                 <heading font="Andale Mono" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="FIRST_PAGE" />
  44.                 <footing font="Andale Mono" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="NONE" />
  45.                 <blob blob="NONE" zip="false" />
  46.             </column>
  47.             <table font="Andale Mono" size="10" style="NORMAL" color="-16777216" userowshading="false" oddrowshading="-1" evenrowshading="-1" showborders="true" spacingbefore="12" spacingafter="12" horizontalalign="LEFT" />
  48.             <header enable="false" generatedate="false">
  49.                 <data>
  50.                
  51.                 null                                </data>
  52.             </header>
  53.             <footer enable="false" generatedate="false">
  54.                 <data value="null" />
  55.             </footer>
  56.             <security enable="false" useopenpassword="false" openpassword="" encryption="EXCLUDE_METADATA">
  57.                 <permission enable="false" permissionpassword="" allowcopying="true" allowprinting="true" allowupdating="false" allowaccessdevices="true" />
  58.             </security>
  59.             <pagesetup papersize="LETTER" orientation="1" measurement="in" margintop="1.0" marginbottom="1.0" marginleft="1.0" marginright="1.0" />
  60.         </pdf>
  61.     <display id="null" type="" style="Code" enable="true">
  62.         <name><![CDATA[Text]]></name>
  63.         <description><![CDATA[]]></description>
  64.         <tooltip><![CDATA[]]></tooltip>
  65.         <drillclass><![CDATA[null]]></drillclass>
  66.         <CustomValues>
  67.         </CustomValues>
  68.         <query>
  69.             <sql><![CDATA[select text from all_views
  70. where view_name = :VIEW_NAME
  71. and owner = :OWNER]]></sql>
  72.             <binds>
  73.                 <bind id="VIEW_NAME">
  74.                     <prompt><![CDATA[VIEW_NAME]]></prompt>
  75.                     <tooltip><![CDATA[VIEW_NAME]]></tooltip>
  76.                     <value><![CDATA[NULL_VALUE]]></value>
  77.                     <bracket><![CDATA[null]]></bracket>
  78.                 </bind>
  79.                 <bind id="OWNER">
  80.                     <prompt><![CDATA[OWNER]]></prompt>
  81.                     <tooltip><![CDATA[OWNER]]></tooltip>
  82.                     <value><![CDATA[NULL_VALUE]]></value>
  83.                     <bracket><![CDATA[null]]></bracket>
  84.                 </bind>
  85.             </binds>
  86.         </query>
  87.             <pdf version="VERSION_1_7" compression="CONTENT">
  88.                 <docproperty title="" author="" subject="" keywords="" />
  89.                 <cell toppadding="2" bottompadding="2" leftpadding="2" rightpadding="2" horizontalalign="LEFT" verticalalign="TOP" wrap="true" />
  90.                 <column>
  91.                     <heading font="Andale Mono" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="FIRST_PAGE" />
  92.                     <footing font="Andale Mono" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="NONE" />
  93.                     <blob blob="NONE" zip="false" />
  94.                 </column>
  95.                 <table font="Andale Mono" size="10" style="NORMAL" color="-16777216" userowshading="false" oddrowshading="-1" evenrowshading="-1" showborders="true" spacingbefore="12" spacingafter="12" horizontalalign="LEFT" />
  96.                 <header enable="false" generatedate="false">
  97.                     <data>
  98.                    
  99.                     null                                        </data>
  100.                 </header>
  101.                 <footer enable="false" generatedate="false">
  102.                     <data value="null" />
  103.                 </footer>
  104.                 <security enable="false" useopenpassword="false" openpassword="" encryption="EXCLUDE_METADATA">
  105.                     <permission enable="false" permissionpassword="" allowcopying="true" allowprinting="true" allowupdating="false" allowaccessdevices="true" />
  106.                 </security>
  107.                 <pagesetup papersize="LETTER" orientation="1" measurement="in" margintop="1.0" marginbottom="1.0" marginleft="1.0" marginright="1.0" />
  108.             </pdf>
  109.     </display>
  110. </display>
  111. </displays>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement