Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8" ?>
- <displays>
- <display id="acaa1214-0148-1000-8001-0a0b0f1666b5" type="" style="Table" enable="true">
- <name><![CDATA[SEARCH_VIEWS]]></name>
- <description><![CDATA[]]></description>
- <tooltip><![CDATA[]]></tooltip>
- <drillclass><![CDATA[null]]></drillclass>
- <CustomValues>
- <TYPE>horizontal</TYPE>
- </CustomValues>
- <query>
- <sql><![CDATA[with q as (
- select owner, view_name, text, upper(DBMS_METADATA.get_ddl('VIEW',view_name, owner)) md from all_views
- where owner like nvl(:owner, '%')
- )
- select owner, view_name, text from q
- /*Skip CREATE OR REPLACE FORCE VIEW "<schema>"."<view>" part*/
- where dbms_lob.instr(md, upper(:search_text) )>=length('CREATE OR REPLACE FORCE VIEW "'||
- owner||
- '"."'||
- view_name||
- '"')]]></sql>
- <binds>
- <bind id="owner">
- <prompt><![CDATA[owner]]></prompt>
- <tooltip><![CDATA[owner]]></tooltip>
- <value><![CDATA[schema]]></value>
- <bracket><![CDATA[null]]></bracket>
- </bind>
- <bind id="search_text">
- <prompt><![CDATA[Enter search text]]></prompt>
- <tooltip><![CDATA[Enter search text]]></tooltip>
- <value><![CDATA[search string]]></value>
- <bracket><![CDATA[null]]></bracket>
- </bind>
- </binds>
- </query>
- <pdf version="VERSION_1_7" compression="CONTENT">
- <docproperty title="" author="" subject="" keywords="" />
- <cell toppadding="2" bottompadding="2" leftpadding="2" rightpadding="2" horizontalalign="LEFT" verticalalign="TOP" wrap="true" />
- <column>
- <heading font="Andale Mono" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="FIRST_PAGE" />
- <footing font="Andale Mono" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="NONE" />
- <blob blob="NONE" zip="false" />
- </column>
- <table font="Andale Mono" size="10" style="NORMAL" color="-16777216" userowshading="false" oddrowshading="-1" evenrowshading="-1" showborders="true" spacingbefore="12" spacingafter="12" horizontalalign="LEFT" />
- <header enable="false" generatedate="false">
- <data>
- null </data>
- </header>
- <footer enable="false" generatedate="false">
- <data value="null" />
- </footer>
- <security enable="false" useopenpassword="false" openpassword="" encryption="EXCLUDE_METADATA">
- <permission enable="false" permissionpassword="" allowcopying="true" allowprinting="true" allowupdating="false" allowaccessdevices="true" />
- </security>
- <pagesetup papersize="LETTER" orientation="1" measurement="in" margintop="1.0" marginbottom="1.0" marginleft="1.0" marginright="1.0" />
- </pdf>
- <display id="null" type="" style="Code" enable="true">
- <name><![CDATA[Text]]></name>
- <description><![CDATA[]]></description>
- <tooltip><![CDATA[]]></tooltip>
- <drillclass><![CDATA[null]]></drillclass>
- <CustomValues>
- </CustomValues>
- <query>
- <sql><![CDATA[select text from all_views
- where view_name = :VIEW_NAME
- and owner = :OWNER]]></sql>
- <binds>
- <bind id="VIEW_NAME">
- <prompt><![CDATA[VIEW_NAME]]></prompt>
- <tooltip><![CDATA[VIEW_NAME]]></tooltip>
- <value><![CDATA[NULL_VALUE]]></value>
- <bracket><![CDATA[null]]></bracket>
- </bind>
- <bind id="OWNER">
- <prompt><![CDATA[OWNER]]></prompt>
- <tooltip><![CDATA[OWNER]]></tooltip>
- <value><![CDATA[NULL_VALUE]]></value>
- <bracket><![CDATA[null]]></bracket>
- </bind>
- </binds>
- </query>
- <pdf version="VERSION_1_7" compression="CONTENT">
- <docproperty title="" author="" subject="" keywords="" />
- <cell toppadding="2" bottompadding="2" leftpadding="2" rightpadding="2" horizontalalign="LEFT" verticalalign="TOP" wrap="true" />
- <column>
- <heading font="Andale Mono" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="FIRST_PAGE" />
- <footing font="Andale Mono" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="NONE" />
- <blob blob="NONE" zip="false" />
- </column>
- <table font="Andale Mono" size="10" style="NORMAL" color="-16777216" userowshading="false" oddrowshading="-1" evenrowshading="-1" showborders="true" spacingbefore="12" spacingafter="12" horizontalalign="LEFT" />
- <header enable="false" generatedate="false">
- <data>
- null </data>
- </header>
- <footer enable="false" generatedate="false">
- <data value="null" />
- </footer>
- <security enable="false" useopenpassword="false" openpassword="" encryption="EXCLUDE_METADATA">
- <permission enable="false" permissionpassword="" allowcopying="true" allowprinting="true" allowupdating="false" allowaccessdevices="true" />
- </security>
- <pagesetup papersize="LETTER" orientation="1" measurement="in" margintop="1.0" marginbottom="1.0" marginleft="1.0" marginright="1.0" />
- </pdf>
- </display>
- </display>
- </displays>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement