# F4 Script Tab displaying code not related to current view

**URL:** <https://forums.toadworld.com/t/f4-script-tab-displaying-code-not-related-to-current-view/32621>\
**Category:** Toad for Oracle - Beta\
**Created:** [February 17, 2015, 7:23am UTC](https://forums.toadworld.com/t/f4-script-tab-displaying-code-not-related-to-current-view/32621 "2015-02-17T07:23:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![phyllis.helton\_1150](https://avatars.discourse-cdn.com/v4/letter/p/ac8455/32.png) [@phyllis.helton\_1150](https://forums.toadworld.com/u/phyllis.helton_1150)\
**Post date:** [February 17, 2015, 7:23am UTC](https://forums.toadworld.com/t/f4-script-tab-displaying-code-not-related-to-current-view/32621/1 "2015-02-17T07:23:18Z")

</div>

I just described a view and went to the script tab and was surprised to see some constraint code that doesn’t belong to this view at all. In fact, each of the 3 alter table statements is for a different table. 🙂

Here is the script as it was created and the Spool SQL code below it. What is especially interesting is that when I run the code from the Spool SQL with the variables it says it is using, I don’t get any results for those constraints.

CREATE OR REPLACE VIEW ANT.WV\_ADDR\_F\_GEOCODE

AS

SELECT “ADDRESS\_STRING”,

“PARENT\_ROW\_WID”,

“TABLE\_NAME”,

“GEOCODE\_WID”,

“LATITUDE”,

“LONGITUDE”,

“CREATED\_DT”,

“UPDATE\_DT”,

“CONFIDENCE\_LEVEL”

FROM siebel.wc\_addr\_with\_geocoding

WHERE 1 = 1

AND table\_name = ‘WC\_ADDR\_F’;

ALTER TABLE ANT.TAB\_INSERTS ADD (

CONSTRAINT TI\_NUM\_INSERT\_TABLES\_CHK

CHECK (ti\_num\_insert\_tables IN (1, 2)),

CONSTRAINT TI\_REQ\_FIELDS\_CHK

CHECK (

(ti\_update\_type = ‘PROCEDURE’ AND ti\_procedure\_name IS NOT NULL) OR

ti\_num\_insert\_tables = 1 OR

(ti\_num\_insert\_tables = 2

AND ti\_row\_wid\_name IS NOT NULL

AND ti\_insert\_view IS NOT NULL

AND ti\_increment\_value IS NOT NULL

AND ti\_view\_name IS NOT NULL)

));

ALTER TABLE ANT.VALIDATION\_DEF ADD (

CONSTRAINT VDEF\_NO\_FAIL\_CHK

CHECK (vdef\_no\_fail IN (‘Y’, ‘N’)));

ALTER TABLE ANT.VALIDATION\_RESULTS ADD (

CONSTRAINT VRES\_RESULT\_CHK

CHECK (vres\_result IN (‘Success’, ‘Warning’, ‘Error’, ‘Under Threshhold’)));

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.483

Select v.view\_name, v.text\_length, v.text, ‘VALID’ status

,trim(v.type\_text) type\_text, v.oid\_text, v.view\_type\_owner, v.view\_type

, superview\_name

, editioning\_view

from SYS.user\_views v

where 1=1

and v.view\_name = :OneObjectName

order by view\_name

:OneObjectName(VARCHAR[17],IN)=‘WV\_ADDR\_F\_GEOCODE’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.493

Select object\_name

from sys.DBA\_OBJECTS

where owner = :own

and object\_type = ‘VIEW’

and status = ‘INVALID’

and object\_name = :OneObjectName

order by object\_name

:own(Unknown)=

:OneObjectName(Unknown)=

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.497

Select TABLE\_NAME, CONSTRAINT\_NAME

from SYS.DBA\_CONSTRAINTS

where owner = :own

AND constraint\_type in (‘V’, ‘O’)

AND generated = ‘USER NAME’

and TABLE\_NAME = :OneObjectName

order by table\_name

:own(VARCHAR[3],IN)=‘ANT’

:OneObjectName(VARCHAR[17],IN)=‘WV\_ADDR\_F\_GEOCODE’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.509

Select t.\*

from SYS.DBA\_TRIGGERS t

where t.table\_owner = :own

and t.table\_name = :OneObjectName

order by t.trigger\_name

:own(VARCHAR[3],IN)=‘ANT’

:OneObjectName(VARCHAR[17],IN)=‘WV\_ADDR\_F\_GEOCODE’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.521

Select c.TABLE\_NAME, NULL COLUMN\_NAME, c.COMMENTS

FROM SYS.DBA\_TAB\_COMMENTS c

WHERE c.OWNER = :own

AND c.COMMENTS IS NOT NULL

and C.TABLE\_NAME = :OneObjectName

order by c.table\_name

:own(VARCHAR[3],IN)=‘ANT’

:OneObjectName(VARCHAR[17],IN)=‘WV\_ADDR\_F\_GEOCODE’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.527

Select c.TABLE\_NAME, c.COLUMN\_NAME, c.COMMENTS

FROM SYS.DBA\_COL\_COMMENTS c

WHERE c.OWNER = :own

AND c.COMMENTS IS NOT NULL

and C.TABLE\_NAME = :OneObjectName

order by c.table\_name

:own(VARCHAR[3],IN)=‘ANT’

:OneObjectName(VARCHAR[17],IN)=‘WV\_ADDR\_F\_GEOCODE’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.532

Select constraint\_type, count (\*) cnt

from SYS.DBA\_CONSTRAINTS

where owner = :own

and not ((length(CONSTRAINT\_NAME) = 30) and

(substr(CONSTRAINT\_NAME, 1, 4) = ‘BIN$’) and

(substr(CONSTRAINT\_NAME, 27, 4) = ‘==$0’))

group by constraint\_type

:own(VARCHAR[3],IN)=‘ANT’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.626

Select C.CONSTRAINT\_NAME, CC.COLUMN\_NAME, C.SEARCH\_CONDITION, C.GENERATED, C.TABLE\_NAME

from SYS.DBA\_CONS\_COLUMNS cc , SYS.DBA\_CONSTRAINTS c

where c.OWNER = cc.OWNER

and c.CONSTRAINT\_NAME = cc.CONSTRAINT\_NAME

and c.TABLE\_NAME = cc.TABLE\_NAME

and c.OWNER = :own

and not ((length(C.CONSTRAINT\_NAME) = 30) and

(substr(C.CONSTRAINT\_NAME, 1, 4) = ‘BIN$’) and

(substr(C.CONSTRAINT\_NAME, 27, 4) = ‘==$0’))

AND C.CONSTRAINT\_TYPE in (‘C’, ‘?’, ‘F’)

order by table\_name, constraint\_name, column\_name

:own(VARCHAR[3],IN)=‘ANT’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.671

Select CONSTRAINT\_NAME, OWNER, TABLE\_NAME, CONSTRAINT\_TYPE, SUBSTRB(STATUS, 1, 1) STATUS

, SEARCH\_CONDITION

, SUBSTRB(DEFERRABLE, 1, 1) deferrable, SUBSTRB(DEFERRED, 1, 1) deferred, SUBSTRB(GENERATED, 1, 1) generated

, VALIDATED

, RELY

, VIEW\_RELATED

FROM SYS.user\_constraints

where 1=1

AND CONSTRAINT\_TYPE in (:ct, ‘?’, ‘F’)

AND Constraint\_name in (‘TI\_NUM\_INSERT\_TABLES\_CHK’,‘TI\_REQ\_FIELDS\_CHK’,‘VDEF\_NO\_FAIL\_CHK’,‘VRES\_RESULT\_CHK’)

and not ((length(CONSTRAINT\_NAME) = 30) and

(substr(CONSTRAINT\_NAME, 1, 4) = ‘BIN$’) and

(substr(CONSTRAINT\_NAME, 27, 4) = ‘==$0’))

order by table\_name, constraint\_name

:ct(VARCHAR[1],IN/OUT)=‘C’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.792

Select CONSTRAINT\_NAME, OWNER, TABLE\_NAME, CONSTRAINT\_TYPE, SUBSTRB(STATUS, 1, 1) STATUS

, SUBSTRB(DEFERRABLE, 1, 1) deferrable, SUBSTRB(DEFERRED, 1, 1) deferred, SUBSTRB(GENERATED, 1, 1) generated

, VALIDATED

, RELY

, VIEW\_RELATED

, INDEX\_NAME, INDEX\_OWNER

FROM SYS.user\_constraints

where 1=1

AND CONSTRAINT\_TYPE = :ct

and TABLE\_NAME = :OneObjectName

and not ((length(CONSTRAINT\_NAME) = 30) and

(substr(CONSTRAINT\_NAME, 1, 4) = ‘BIN$’) and

(substr(CONSTRAINT\_NAME, 27, 4) = ‘==$0’))

order by table\_name, constraint\_name

:ct(VARCHAR[1],IN/OUT)=‘P’

:OneObjectName(VARCHAR[17],IN)=‘WV\_ADDR\_F\_GEOCODE’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.799

Select CONSTRAINT\_NAME, OWNER, TABLE\_NAME, CONSTRAINT\_TYPE, SUBSTRB(STATUS, 1, 1) STATUS

, R\_OWNER, R\_CONSTRAINT\_NAME, SUBSTRB(DELETE\_RULE, 1, 1) delete\_rule

, SUBSTRB(DEFERRABLE, 1, 1) deferrable, SUBSTRB(DEFERRED, 1, 1) deferred, SUBSTRB(GENERATED, 1, 1) generated

, VALIDATED

, RELY

, VIEW\_RELATED

FROM SYS.user\_constraints

where 1=1

AND CONSTRAINT\_TYPE = :ct

and TABLE\_NAME = :OneObjectName

and not ((length(CONSTRAINT\_NAME) = 30) and

(substr(CONSTRAINT\_NAME, 1, 4) = ‘BIN$’) and

(substr(CONSTRAINT\_NAME, 27, 4) = ‘==$0’))

order by table\_name, constraint\_name

:ct(VARCHAR[1],IN/OUT)=‘R’

:OneObjectName(VARCHAR[17],IN)=‘WV\_ADDR\_F\_GEOCODE’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.804

Select CONSTRAINT\_NAME, TABLE\_NAME, COLUMN\_NAME

FROM SYS.USER\_CONS\_COLUMNS A

WHERE 1=1

and TABLE\_NAME = :OneObjectName

ORDER BY TABLE\_NAME, CONSTRAINT\_NAME, POSITION, COLUMN\_NAME

:OneObjectName(VARCHAR[17],IN)=‘WV\_ADDR\_F\_GEOCODE’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.821

select [ue.name](http://ue.name) GRANTEE, [u.name](http://u.name) OWNER, [o.name](http://o.name) TABLE\_NAME, [ur.name](http://ur.name) GRANTOR, [tpm.name](http://tpm.name) PRIVILEGE,

decode(mod(oa.option$,2), 1, ‘YES’, ‘NO’) GRANTABLE,

decode(bitand(oa.option$,2), 2, ‘YES’, ‘NO’) HIERARCHY,

decode(o.TYPE#, 2, ‘TABLE’, 4, ‘VIEW’,

6, ‘SEQUENCE’, 7, ‘PROCEDURE’,

8, ‘FUNCTION’, 9, ‘PACKAGE’,

13, ‘TYPE’, 22, ‘LIBRARY’,

23, ‘DIRECTORY’, 24, ‘QUEUE’,

66, ‘JOB’, 67, ‘PROGRAM’, 74, ‘SCHEDULE’,

28, ‘JAVA SOURCE’, 29, ‘JAVA CLASS’, 30, ‘JAVA RESOURCE’,

32, ‘INDEXTYPE’, 33, ‘OPERATOR’,

42, ‘MATERIALIZED VIEW’, 90, ‘CREDENTIAL’, ‘UNDEFINED’) object\_type

from sys.objauth$ oa, SYS."\_CURRENT\_EDITION\_OBJ" o, sys.user$ u, sys.user$ ur, sys.user$ ue,

sys.table\_privilege\_map tpm

where oa.obj# = o.obj#

and oa.grantor# = ur.user#

and oa.grantee# = ue.user#

and oa.col# is null

and oa.privilege# = tpm.privilege

and u.user# = o.owner#

and o.TYPE# in (4)

and [u.name](http://u.name) = :own

and [o.name](http://o.name) = :OneObjectName

and bitand(o.flags, 128) \<\> 128

ORDER BY 1, 2, 3, 5

:own(VARCHAR[3],IN)=‘ANT’

:OneObjectName(VARCHAR[17],IN)=‘WV\_ADDR\_F\_GEOCODE’

* * *

Session: [ANT@SBLDWP.CCCI.ORG](mailto:ANT@SBLDWP.CCCI.ORG)

Timestamp: 10:16:56.828

Select \* from SYS.DBA\_COL\_PRIVS where OWNER = :own

and not ((length(TABLE\_NAME) = 30) and

(substr(TABLE\_NAME, 1, 4) = ‘BIN$’) and

(substr(TABLE\_NAME, 27, 4) = ‘==$0’))

ORDER BY grantee, OWNER, table\_name, column\_name, privilege

:own(VARCHAR[3],IN)=‘ANT’

–  
**Phyllis Helton**

Data Magician  
Digital Strategies, Cru | Data Sciences & Analytics  
Office ☎ 407-515-4452

[phyllis.helton@cru.org](mailto:phyllis.helton@cru.org)  
 ![](http://emailassets.cru.org/cdn-crumail/cru.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 17, 2015, 7:43am UTC](https://forums.toadworld.com/t/f4-script-tab-displaying-code-not-related-to-current-view/32621/2 "2015-02-17T07:43:09Z")

</div>

Thanks Phyllis. It’s fixed for next beta

---

<div class="post-metadata">

**Author:** ![phyllis.helton\_1150](https://avatars.discourse-cdn.com/v4/letter/p/ac8455/32.png) [@phyllis.helton\_1150](https://forums.toadworld.com/u/phyllis.helton_1150)\
**Post date:** [February 17, 2015, 8:12am UTC](https://forums.toadworld.com/t/f4-script-tab-displaying-code-not-related-to-current-view/32621/3 "2015-02-17T08:12:21Z")

</div>

Thank you, John! I'm glad I happened to look.

On Tue, Feb 17, 2015 at 10:47 AM, John Dorlon [bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com) wrote:

> **[RE: F4 Script Tab displaying code not related to current view](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/23861/52087.aspx#52087)**

> Reply by John Dorlon  
> Thanks Phyllis. It's fixed for next beta

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/23861.aspx?subscribe=false) on this subject.
> 
> Or [Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/23861/52087.aspx?AbuseContentId=56174690-3648-4be0-a6ae-f18f97c912e2&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

--  
**Phyllis Helton**

Data Magician  
Digital Strategies, Cru | Data Sciences & Analytics  
Office ☎ 407-515-4452

[phyllis.helton@cru.org](mailto:phyllis.helton@cru.org)  
 ![](https://global.discourse-cdn.com/quest/original/3X/9/4/94bf0c4f5e9dec7932932b0cb0b94169a403b1fd.png)