22020 подписчиков
28 видео
Foreign Key Constraint in Oracle SQL
Select and Insert in Oracle SQL
Oracle Database 19c with SQL Developer Installation
Alter Table in Oracle SQL
PL/SQL Exception | Predefined Exception | User Defined Exception
PLSQL Cursor with For Loop
Parameterized Cursor in PLSQL
Update and Delete in Oracle SQL
Inline View in Oracle SQL
Oracle SQL Query to Fetch Person Email Domain and Domain Extension
OIC Integration to Create Supplier in Oracle ERP using FBDI Process
Pivot in Oracle SQL
Nested Table Stored as a Column in Table and Database Object
Primary Key Constraint in Oracle SQL
Filtering Data and Operators in Oracle SQL
PL/SQL Function with Example | Function Vs Procedure | Call Function
OIC Integration to Read Fixed Length Text File and Create CSV File
OIC Integration to Call BIP Report | Write Report File to SFTP
OIC Integration to Create Fixed Length Text File from CSV FIle
Download FIle from SFTP and Send Through Email in OIC
Row_Number, Rank and Dense_Rank Function in Oracle SQL
Inner and Outer Join in Oracle SQL
PL/SQL Package with Example | Package Spec and Body
Aggregate Functions, Group By and Having in Oracle SQL
OIC Integration to Get Import Employee HDL Status and Output in Email
OIC Integration to demonstrate Read File In Segments to update Bulk AP Invoices using Rest API
Over and Partition by in Oracle SQL
Self Join in Oracle SQL
Order by and Distinct in Oracle SQL
Truncate and Drop in Oracle SQL
Transform the Source File Data in OIC using ATP Database - Part 1
Convert CSV File to XML File in OIC | Read and Write File
OIC Integration to Create AP Invoices using Rest API From ATP Table Data
LISTAGG Function in Oracle SQL
OIC Integration to Create Employees using HDL Process in Oracle Cloud
Call OIC Integration from BIP Report and ESS Job using HTTP Connection
List and Download Files from SFTP in OIC | Stage File Zip Action |Notification Action
OIC Integration to Call BIP Report with more than 1000 Comma Separated Values
Set Operators in Oracle SQL|Union|Union All|Intersect|Minus
OIC Integration to Get Suppliers using Rest API | Set Limit and Filter Data with API Query Parameter
Cursor in PLSQL|Explicit Cursor
PLSQL Collections - Nested Table | Bulk Collect
OIC Integration to Access Local System File using OIC Agent and File Adaptor
Global Variables and Data Stitch in OIC | Array of Objects | Supplier Rest API
PL/SQL Procedure| Parameter Types with Examples
OIC Integration to Populate the Excel File Data into ATP Table
%Type and %Rowtype in PLSQL
OIC Integration to Implement FTP Polling and Populate Data into ATP Table
OIC Integration to Upload File to Oracle UCM from SFTP
INSTR and SUBSTR Function in Oracle SQL
