Need advice about which tool to choose?Ask the StackShare community!

Oracle PL/SQL

+ 1

+ 1
Add tool

Oracle PL/SQL vs Prisma: What are the differences?

Oracle PL/SQL: It is a combination of SQL along with the procedural features of programming languages. It is available in Oracle Database, TimesTen in-memory database, and IBM DB2. Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database; Prisma: Prisma makes working with databases easy. Prisma is a powerful database tool used for data access, migrations and visual data management. It replaces traditional ORMs and removes friction from complicated database workflows.

Oracle PL/SQL and Prisma can be categorized as "Query Languages" tools.

Prisma is an open source tool with 15.2K GitHub stars and 886 GitHub forks. Here's a link to Prisma's open source repository on GitHub.

Powersports Auction, Seistreinta, and AnkaWorld are some of the popular companies that use Prisma, whereas Oracle PL/SQL is used by Matrix Absence Management Inc, Pre2000, and CUBE. Prisma has a broader approval, being mentioned in 21 company stacks & 73 developers stacks; compared to Oracle PL/SQL, which is listed in 12 company stacks and 31 developer stacks.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Oracle PL/SQL
Pros of Prisma
  • 2
    Multiple ways to accomplish the same end
  • 2
  • 1
    Not mysql
  • 1
    Massive, continuous investment by Oracle Corp
  • 1
    Extensible to external langiages
  • 1
  • 11
    Type-safe database access
  • 10
    Open Source
  • 8
    Auto-generated query builder
  • 6
    Supports multible database systems
  • 6
    Increases confidence during development
  • 4
    Productive application development
  • 4
    Built specifically for Postgres and TypeScript
  • 2
    Supports multible RDBMSs
  • 1
    Robust migrations system

Sign up to add or upvote prosMake informed product decisions

Cons of Oracle PL/SQL
Cons of Prisma
  • 2
    High commercial license cost
  • 2
    Doesn't support downward/back migrations
  • 1
    Doesn't support JSONB
  • 1
    Do not support JSONB
  • 1
    Mutation of JSON is really confusing
  • 1
    Do not support JSONB
  • 0

Sign up to add or upvote consMake informed product decisions

- No public GitHub repository available -

What is Oracle PL/SQL?

It is a powerful, yet straightforward database programming language. It is easy to both write and read, and comes packed with lots of out-of-the-box optimizations and security features.

What is Prisma?

Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.

Need advice about which tool to choose?Ask the StackShare community!

What companies use Oracle PL/SQL?
What companies use Prisma?
See which teams inside your own company are using Oracle PL/SQL or Prisma.
Sign up for StackShare EnterpriseLearn More

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Oracle PL/SQL?
What tools integrate with Prisma?

Sign up to get full access to all the tool integrationsMake informed product decisions

What are some alternatives to Oracle PL/SQL and Prisma?
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
GraphQL is a data query language and runtime designed and used at Facebook to request and deliver data to mobile and web apps since 2012.
See all alternatives