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

Oracle PL/SQL

747
589
+ 1
8
Python

245.3K
200.1K
+ 1
6.9K
Add tool
Manage your open source components, licenses, and vulnerabilities
Learn More
Pros of Oracle PL/SQL
Pros of Python
  • 2
    Multiple ways to accomplish the same end
  • 2
    Powerful
  • 1
    Not mysql
  • 1
    Massive, continuous investment by Oracle Corp
  • 1
    Extensible to external langiages
  • 1
    Pl/sql
  • 1.2K
    Great libraries
  • 963
    Readable code
  • 847
    Beautiful code
  • 788
    Rapid development
  • 691
    Large community
  • 438
    Open source
  • 393
    Elegant
  • 282
    Great community
  • 273
    Object oriented
  • 221
    Dynamic typing
  • 77
    Great standard library
  • 60
    Very fast
  • 55
    Functional programming
  • 50
    Easy to learn
  • 46
    Scientific computing
  • 35
    Great documentation
  • 29
    Productivity
  • 28
    Matlab alternative
  • 28
    Easy to read
  • 24
    Simple is better than complex
  • 20
    It's the way I think
  • 19
    Imperative
  • 18
    Very programmer and non-programmer friendly
  • 18
    Free
  • 17
    Machine learning support
  • 17
    Powerfull language
  • 16
    Fast and simple
  • 14
    Scripting
  • 12
    Explicit is better than implicit
  • 11
    Ease of development
  • 10
    Clear and easy and powerfull
  • 9
    Unlimited power
  • 8
    Import antigravity
  • 8
    It's lean and fun to code
  • 7
    Print "life is short, use python"
  • 7
    Python has great libraries for data processing
  • 6
    High Documented language
  • 6
    I love snakes
  • 6
    Readability counts
  • 6
    Rapid Prototyping
  • 6
    Now is better than never
  • 6
    Although practicality beats purity
  • 6
    Flat is better than nested
  • 6
    Great for tooling
  • 6
    There should be one-- and preferably only one --obvious
  • 6
    Fast coding and good for competitions
  • 5
    Web scraping
  • 5
    Lists, tuples, dictionaries
  • 5
    Great for analytics
  • 4
    Beautiful is better than ugly
  • 4
    Easy to learn and use
  • 4
    Easy to setup and run smooth
  • 4
    Multiple Inheritence
  • 4
    CG industry needs
  • 4
    Socially engaged community
  • 4
    Complex is better than complicated
  • 4
    Plotting
  • 4
    Simple and easy to learn
  • 3
    List comprehensions
  • 3
    Powerful language for AI
  • 3
    Flexible and easy
  • 3
    It is Very easy , simple and will you be love programmi
  • 3
    Many types of collections
  • 3
    If the implementation is easy to explain, it may be a g
  • 3
    If the implementation is hard to explain, it's a bad id
  • 3
    Special cases aren't special enough to break the rules
  • 3
    Pip install everything
  • 3
    No cruft
  • 3
    Generators
  • 3
    Import this
  • 2
    Batteries included
  • 2
    Securit
  • 2
    Can understand easily who are new to programming
  • 2
    Should START with this but not STICK with This
  • 2
    A-to-Z
  • 2
    Because of Netflix
  • 2
    Only one way to do it
  • 2
    Better outcome
  • 2
    Good for hacking
  • 1
    Best friend for NLP
  • 1
    Sexy af
  • 1
    Procedural programming
  • 1
    Automation friendly
  • 1
    Slow
  • 0
    Keep it simple
  • 0
    Powerful
  • 0
    Ni

Sign up to add or upvote prosMake informed product decisions

Cons of Oracle PL/SQL
Cons of Python
  • 2
    High commercial license cost
  • 53
    Still divided between python 2 and python 3
  • 28
    Performance impact
  • 26
    Poor syntax for anonymous functions
  • 22
    GIL
  • 19
    Package management is a mess
  • 14
    Too imperative-oriented
  • 12
    Hard to understand
  • 12
    Dynamic typing
  • 12
    Very slow
  • 8
    Indentations matter a lot
  • 8
    Not everything is expression
  • 7
    Incredibly slow
  • 7
    Explicit self parameter in methods
  • 6
    Requires C functions for dynamic modules
  • 6
    Poor DSL capabilities
  • 6
    No anonymous functions
  • 5
    Fake object-oriented programming
  • 5
    Threading
  • 5
    The "lisp style" whitespaces
  • 5
    Official documentation is unclear.
  • 5
    Hard to obfuscate
  • 5
    Circular import
  • 4
    Lack of Syntax Sugar leads to "the pyramid of doom"
  • 4
    The benevolent-dictator-for-life quit
  • 4
    Not suitable for autocomplete
  • 2
    Meta classes
  • 1
    Training wheels (forced indentation)

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 Python?

Python is a general purpose programming language created by Guido Van Rossum. Python is most praised for its elegant syntax and readable code, if you are just beginning your programming career python suits you best.

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

What companies use Oracle PL/SQL?
What companies use Python?
Manage your open source components, licenses, and vulnerabilities
Learn 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 Python?

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

What are some alternatives to Oracle PL/SQL and Python?
PostgreSQL
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
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.
MySQL
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.
JavaScript
JavaScript is most known as the scripting language for Web pages, but used in many non-browser environments as well such as node.js or Apache CouchDB. It is a prototype-based, multi-paradigm scripting language that is dynamic,and supports object-oriented, imperative, and functional programming styles.
Python
Python is a general purpose programming language created by Guido Van Rossum. Python is most praised for its elegant syntax and readable code, if you are just beginning your programming career python suits you best.
See all alternatives