Skip to content
DCodeMan
  • Home
  • Resources
    • Documentation
      • Oracle 19c SQL
      • Oracle 19c PL/SQL
      • Oracle to PostgreSQL Migration
      • RDBMS
    • Q & A
    • Courses
  • Blogs
  • Login
Menu Close
  • Home
  • Resources
    • Documentation
      • Oracle 19c SQL
      • Oracle 19c PL/SQL
      • Oracle to PostgreSQL Migration
      • RDBMS
    • Q & A
    • Courses
  • Blogs
  • Login

3.3 Dissimilar Functions

  1. Home>
  2. Documentation>
  3. Oracle to PostgreSQL Migration>
  4. 3 Built-in Functions>
  5. 3.3 Dissimilar Functions

Oracle to PostgreSQL Migration

  • 1 Database Migration Basics
    • 1.1 Introduction to Database Migration
    • 1.2 Database Migration Outline
    • 1.3 SQL Statements
    • 1.4 SQL Clauses
    • 1.5 Data types
    • 1.6 Most Common SQL Differences
    • 1.7 Type Casting
  • 2 Migrate Tables
    • 2.1 Migrating Oracle SCOTT user tables
  • 3 Built-in Functions
    • 3.1 Functions Overview
    • 3.2 Similar Functions
    • 3.3 Dissimilar Functions
    • 3.4 Inconsistent Functions
  • 4 NULL Handling
    • 4.1 Facts with NULL
    • 4.2 Converting pipe “||” operator
    • 4.3 NULL in Unique Constraints
  • 5 SQL Commands
    • 5.1 CREATE TABLE
    • 5.2 ALTER TABLE
  • 6 SQL – Oracle vs PG
    • 6.1 Migrate Joins
    • 6.2 Migrate Subqueries
    • 6.3 Migrate Hierarchical Queries
  • 7 Database Objects
  • 8 Transaction Handling
    • 8.1 Transaction Overview
    • 8.2 Transaction with DDL
  • 9 PLSQL vs plpgsql
    • 9.1 Anonymous Block
    • 9.2 Migrating DBMS_OUTPUT.PUT_LINE
    • Migrate User defined types
  • Migrating Oracle Collections
    • Convert Associative Array
    • Convert PL/SQL table
    • Convert Varray
  • Miscellaneous Migration Queries
    • Constraints disable and drop
  1. Home
  2. Docs
  3. Oracle to PostgreSQL Migration
  4. 3 Built-in Functions
  5. 3.3 Dissimilar Functions

3.3 Dissimilar Functions

Still stuck? How can we help?
Updated on October 6, 2020

Doc navigation

← 3.2 Similar Functions3.4 Inconsistent Functions →
Was this article helpful to you? Yes No

How can we help?

DCODEMAN

  • About Us
  • Contact Us
  • Privacy Policy
  • Terms of use

Resource Hub

  • Q & A
  • Documentation
  • Blogs
  • Courses

What’s Fascinating!

  • Donate
  • Oracle SQL Q&A
  • Oracle PL/SQL Q&A
  • Interesting Facts
Copyright © 2020 DCODEMAN, All rights reserved.

Login

Continue with Google

Forgot Password?

Create a new account

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.