-
Notifications
You must be signed in to change notification settings - Fork 72
Expand file tree
/
Copy pathcreate_synonyms.sql
More file actions
22 lines (17 loc) · 1.04 KB
/
Copy pathcreate_synonyms.sql
File metadata and controls
22 lines (17 loc) · 1.04 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-- Creates synonyms from defined user for OOS Utils objects
-- Use this if storing OOS Utils in its own schema and other schemas reference it.
-- Parameters
define from_user = '&1' -- This is the user to reference OOS Utils objects
whenever sqlerror exit sql.sqlcode
-- Do not modify code under this line as it is auto generated
-- AUTOREPLACE_START
create or replace synonym oos_util for &from_user..oos_util;
create or replace synonym oos_util_apex for &from_user..oos_util_apex;
create or replace synonym oos_util_bit for &from_user..oos_util_bit;
create or replace synonym oos_util_crypto for &from_user..oos_util_crypto;
create or replace synonym oos_util_date for &from_user..oos_util_date;
create or replace synonym oos_util_lob for &from_user..oos_util_lob;
create or replace synonym oos_util_string for &from_user..oos_util_string;
create or replace synonym oos_util_totp for &from_user..oos_util_totp;
create or replace synonym oos_util_validation for &from_user..oos_util_validation;
create or replace synonym oos_util_web for &from_user..oos_util_web;