The sample queries provided below are only applicable if Synchronization Service is connected to the target Oracle Database through the Oracle Database Connector.
Example: Adding a new entry
This SQL query illustrates how to add a new entry to the table named SQLConnTest1 in Oracle Database to which you want to provision data from another connected system.
Database table structure | Sample query |
CREATE TABLE "SQLConnTest1"("Id" number,"attr1" nchar(64), "attr2" nchar(64)) | Insert into SQLConnTest1(attr1) values(:attr1) returning Id into :Id |
In this sample query, Id stands for the attribute that uniquely identifies each object in the Oracle Database.
Example: Creating a new user
This SQL query illustrates how to create a new user in the Oracle Database:
call dbms_utility.exec_ddl_statement('CREATE USER ' || :USERNAME || ' IDENTIFIED BY ' || :newPassword)
In this sample query:
-
USERNAME refers to the name of the attribute that uniquely identifies the user in the Oracle Database.
-
newPassword refers to the name of the attribute that will store the initial password you want to set for the new Oracle Database user.