Toggle navigation
Toggle navigation
Home
Products
About us
Support
Contact
Try it free
order
Register
Log In
Forums
Products
PL/SQL Developer
Compiling scripts containing additional SQL commands
Search
Advanced Forum Search
Forums
Active Threads
Print Thread
Re: Compiling scripts containing additional SQL commands
#25488
03/27/07
06:42 PM
Joined:
Feb 2006
Posts: 14
Plano, Texas USA
C
Clever Idea Consulting
Member
Clever Idea Consulting
Member
C
Joined:
Feb 2006
Posts: 14
Plano, Texas USA
Your company's standard of wholesale public synonyming and grants is a little scary - but here's a cool tip, use:
CREATE OR REPLACE PUBLIC SYNONYM syn FOR obj;
It let's bypass at least on error the first time you are executing your boilerplate.
Copy Link to Clipboard
Entire Thread
Subject
Posted By
Posted
Compiling scripts containing additional SQL commands
lvanek
03/27/07
06:21 PM
Re: Compiling scripts containing additional SQL commands
Clever Idea Consulting
03/27/07
06:42 PM
Moderated by
support
Hop To
Products ------
Plyxon
PL/SQL Developer
Direct Oracle Access
Query Reporter
Alpha / Beta releases ------
Plyxon Alpha / Beta
PL/SQL Developer 15.0 Beta
Print Thread
Switch to Flat Mode
Show Likes
Link Copied to Clipboard
View Profile
Private Message
Website
Follow User
Forum Posts
Privacy Policy
·
Forum Rules
·
Mark All Read
Contact Us
·
Forum Help
·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:
PHP:
7.1.33
Page Time:
0.118s
Queries:
13 (0.090s)
Memory:
2.5281 MB (Peak: 3.0470 MB)
Data Comp:
Off
Server Time:
2024-05-15 00:25:42 UTC
Valid HTML 5
and
Valid CSS