r/plsql • • Nov 07 '22

Is Oracle PL/SQL dying out?

12 Upvotes

Hi all,

I've been wondering if this programming language is slowly dying out due to for ex. replacement to Cloud. I'm a young dev who has been specialised in PL/SQL but I'm wondering if I'd need to start focusing on other programming languages as well. I do have knowledge about other languages but still my main work I've done until now is PL/SQL.

What is your feeling about this language, espacially regarding job offers, etc.?


r/plsql • • Nov 23 '21

Why is it so hard to find PL/SQL developers?

8 Upvotes

I constantly have one or two open positions for PL/SQL developers and can never seem to connect up with quality programmers.


r/plsql • • Sep 21 '22

any books or any websites to learn PLSQL?

7 Upvotes

r/plsql • • Aug 01 '22

One Simple Trick to Writing and Understanding SQL Better by Randy Meacham

7 Upvotes

When SQL was developed, the developers wanted a language that resembled the English language more than the typical computer language at that time. They wanted the language to be Declarative and to have a similar structure as a sentence the average human would state.

Example: Bring me the screwdriver from the toolbox in the garage that has a yellow handle.

  1. Bring me the Screwdriver (SELECT)

  2. from the toolbox in the garage (FROM)

  3. that has a yellow handle (WHERE)

We’re all familiar with this beginning structure of an SQL query when we design one. However, the computer/engine does not interpret the code this way.

Instead, the computer would have read and performed the instructions as follows:

  1. From the toolbox in the garage (FROM)

  2. That has a yellow handle (WHERE)

  3. Bring me the Screwdriver (SELECT)

This is called logical query processing and is the most effective and efficient way for the database engine to execute the code.

We are used to writing queries in the following format:

  1. SELECT

  2. FROM

  3. WHERE

  4. GROUP BY

  5. HAVING

  6. ORDER BY

But the SQL Database Engine processes it as:

  1. FROM

  2. WHERE

  3. GROUP BY

  4. HAVING

  5. SELECT

  6. ORDER BY

Remembering this Logical Processing order is crucial while writing SQL to make sure you do not reference column alias in any SQL Clause before the SQL Engine has even ‘read’ your SELECT statement to know what the alias is!

This is also helpful in remembering why and how we use HAVING vs WHERE.

As you can see in the Logical processing phases, WHERE is processed before GROUP BY and HAVING. Seeing that should be an indicator to you that the WHERE clause is filtering on Rows, and not Groups because the SQL Engine doesn’t even know you’ve grouped your data yet when its processing the WHERE clause.

HAVING is then processed after GROUP BY because the SQL Engine now knows how you Grouped your data and can now filter those groups using the HAVING clause.

You’re probably thinking,

“ Cool story, but how am I supposed to remember the logical order?? “

well, I got you! We can just put it into an Acronym (FWGHSO) that you can remember! Mine is:

Friends (FROM)

With (WHERE)

Girlfriends (GROUP BY)

Have (HAVING)

Silly (SELECT)

Outfits (ORDER BY)

Hope this helps!

https://medium.com/@DataScienceDad/one-simple-trick-to-writing-and-understanding-sql-better-c3ba3b66ee16


r/plsql • • Jun 29 '21

/r/plsql hit 1k subscribers yesterday

Thumbnail
frontpagemetrics.com
7 Upvotes

r/plsql • • Aug 05 '19

Oracle external table with preprocessor

Thumbnail
rolkotech.blogspot.com
7 Upvotes

r/plsql • • Feb 12 '23

Stored procedure inside a stored procedure?

5 Upvotes

I was reading some Oracle code and I saw a Stored procedure inside a stored procedure.

Is this technique a bad idea? Why would a programmer do this?


r/plsql • • Oct 28 '19

The advantage of Oracle analytic functions

Thumbnail
rolkotech.blogspot.com
5 Upvotes

r/plsql • • Oct 19 '19

Question: Would the PL/SQL community welcome another implementation?

5 Upvotes

Greetings from the Ada side of things!

I'm currently working on a MIT-licensed implementation for Ada 2012 (possibly 2020, depending) and it occurs to me that the environment I would like to have would be heavily database dependent [Ex: VCS/CI.] — given that, it also occurs to me that PL/SQL is very good for database manipulation/interaction, and might be suitable for the "back-end" (storage of source/IR, manipulation, change-tracking, etc) of the IDE, but in order for this to be viable for this project, we'd have to have an open-source PL/SQL… this, in turn, raises the question of the title: Would the PL/SQL community be interested in an open-source implementation? If so, would they be willing to invest some time/effort in such a project?

Thank you /r/plsql.


r/plsql • • May 24 '18

Learn Oracle PL/SQL : Create Table & Use

Thumbnail
asporacle.com
5 Upvotes

r/plsql • • Oct 18 '17

Mark Old Code as "Not For Use" : 12 Things Developers Will Love About Oracle Database 12c Release 2…

Thumbnail
medium.com
5 Upvotes

r/plsql • • Jan 21 '25

Control Statement in Oracle PLSQL

Thumbnail
javainhand.com
4 Upvotes

r/plsql • • Dec 14 '21

Help With Code

4 Upvotes

Hi, I'm new to PLSQL and I was tasked to create a stored procedure that verifies the Reimbursement request status and changes the status from Set pay to Paid, and updates the Payment date to the current date. The stored procedure MUST update the referred two columns in the REIMBURSEMENTREQUEST table. It must also redirect the user to the Payment Page. This is my code up to now:

Create or replace Procedure RequestVerify (INReimbursementStatus Char(1))

As

NewStatus char(4);

NewDate Timestamp(5);

CountRequest Integer;

BEGIN

BEGIN

Update ReimbursementRequest

Set ReimbursementStatus = 'PAID'

Where ReimbursementStatus = INReimbursementStatus AND ReimbursementStatus = 'SETP'

Returning ReimbursementStatus into NewStatus;

End;

Begin

Update ReimbursmentRequest

Set UpdatedDate = TO_TIMESTAMP(SYSDATE, 'DD-MON-RRHH24 MI:SS:FF')

Where ReimbursementStatus = INReimbursementStatus AND ReimbursementStatus = 'PAID'

Returning UpdatedDate into NewDate;

End;

BEGIN

Select count(*) INTO CountRequest

From ReimbursementRequest

Where ReimbursementStatus = NewStatus

END;

END;

If someone can look at the code and point me in the right direction


r/plsql • • Mar 26 '21

What is PL/SQL Block Structure ?

4 Upvotes

Hello Group Members,

Here is my Third PL/SQL article please review and share your valuable feedback.

What is PL/SQL Block Structure ?

https://www.javainhand.com/2021/03/what-is-plsql-block-structure.html


r/plsql • • Mar 16 '21

What is PL/SQL

4 Upvotes

Hello Group Members,

I have started to write articles on PL / SQL, here is my first PL / SQL article please review and share your valuable feedback.

What is PL/SQL


r/plsql • • Sep 03 '19

PL/SQL on a Mac?

4 Upvotes

So I'm trying to do a tutorial on PL/SQL. I have a MacBook Pro I was able to successfully download Virtual Box and the Oracle Developer VM but I'm running into issues making the VM visible to my Mac in order to connect to the database. With some instructions I found online on apparently supposed to open a port on the firewall that's running on the Linux virtual machine but when I try to click on the firewall tab in order to change it an error message comes up that says 'failed to connect to firewall. Please make sure that the surface has been started correctly and try again.' I'm not really sure what I'm doing wrong. Does anyone have any suggestions?


r/plsql • • May 31 '19

Simple guide to open Socket Connection using Oracle PL SQL Programming

Thumbnail
opencodez.com
4 Upvotes

r/plsql • • Apr 09 '19

How long for an experienced SQL Server developer to learn PL/SQL?

4 Upvotes

Approximately how long would it take me to learn PL/SQL to an average level?

I am an extremely experienced SQL Server developer (over 10 years).

With both SQL Server abd Oracle being relational databases, I am sure the same basic RDBMS concepts apply. So I assume the learning process would be mainly in the different syntax and the different development environments.

It would be very useful if someone could give me a ball-park idea how long it might take me to get "up to speed" with PL/SQL? Are we talking a week or two? Or more like 6 months?


r/plsql • • Nov 22 '18

Package Inheritance?

4 Upvotes

We have an ETL process where each source system is loaded by a procedure encapsulated in a package for each source.

most of these packages follow the exact same structure (i.e. have all the same procedures and signatures for them.)

the only difference is constants in the package spec, as well as definition/body of each private procedure.

they all have the same public procedure that just calls the package's private procedures, this public procedure is identical between each package.

Is there anyway to have a package act as an interface/abstract base?

I'd like to be able to define all the signatures for such a package's procedures to act as a 'template' for other such packages to follow.

Unfortunately I'm unaware of any such ability.

Does anyone know of a way to accomplish this / has any alternatives to promote a stronger API design?


r/plsql • • Sep 19 '18

Simple guide to open Socket Connection using Oracle PL SQL Programming

Thumbnail
opencodez.com
4 Upvotes

r/plsql • • Sep 06 '18

Cant use 'lower' function inside 'load when' clause [oracle 12c]

4 Upvotes

I'm trying to load an external table only when a value doesnt exist in a column like this

load when ( lower(my_column) != 'bad text' )

but it complains at the 'lower' part saying it expected a comparison of "! !=, etc)". I can still do 2 checks of 'bad text' and 'BAD TEXT' but its far less elegant and doesnt account for mixed case... any ideas here?


r/plsql • • Oct 19 '17

Introduction to Liquibase and Managing Your Database Source Code

Thumbnail
medium.com
4 Upvotes

r/plsql • • Feb 23 '17

Are there any good version control tools for plsql?

4 Upvotes

Pretty much as the title says. Today I copy paste the code into IntelliJ and use git but that's kind of awkward and clumsy way of doing things.


r/plsql • • Jan 26 '17

PL/SQL Exceptions

Thumbnail
oraappdata.com
4 Upvotes

r/plsql • • Nov 16 '16

Challenge your SQL skills at the Great SQLizer November 2016 - a 6 hours competitive challenge on SQL. Compete with SQL minds from across the world [X-Post from r/hackerearth]

Thumbnail
hackerearth.com
4 Upvotes