Questions tagged [plsql]

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural language extension for SQL. Questions about PL/SQL should probably be tagged "oracle" as well.

Filter by
Sorted by
Tagged with
2
votes
2answers
138 views

Calculate the midpoint of a polyline

I have polylines in a GIS database. The polylines are stored using a user-defined type called ST_GEOMETRY. ST_GEOMETRY has lots of spatial functions. However, it does not have a polyline midpoint ...
2
votes
1answer
85 views

Seek to get acceptable performance of SQL request (SOLVED)

Goal: I want to output all non-standard FK constraints from clients DB, versus our "standard" DB (which contains, by default, 2,631 FK). Trial: I wrote this code: ...
0
votes
2answers
92 views

SQL Statement with a Select Statement Inside a Where Clause

Is there a more efficient way to write the following PLSQL statement? It seems inefficient to me to have the SQL statement nested inside the where clause. ...
1
vote
0answers
58 views

Determining how many tabs to create and how many lines per each tab

I wrote this PL/SQL code for Oracle Apex, works perfectly. At the beginning I had more than 200 lines for the same code. I’m new and I’m still learning. After searching on multiple websites I found ...
0
votes
0answers
87 views

Using a boolean column as an index to process rows vs partitions or other mechanisms

I receive files from many sources (SFTP, REST, SOAP, etc.) in many formats (CSV, JSON, XML, etc.) and then process them at a later time in a ...
1
vote
1answer
3k views

Oracle trigger to keep a copy of deleted records in another table

I am using this trigger to keep a copy of the deleted record from table Orders_Details in table Orders_Details_Deleted. I am ...
4
votes
1answer
107 views

Highest andLowest in PLSQL

I have made a procedure to display the highest and the lowest popular Items for a particular time of a given date. The procedure works with no errors or exceptions ...
0
votes
2answers
93 views

Checking whether a grade combination exists

Below function checks if a grade exists ...
1
vote
1answer
699 views

Oracle query to split 1 row into two where conditions are applicable

The scenario question: "I'm having difficulties with splitting a single row into two individual ones." My test schema is: ...
3
votes
2answers
141 views

Searching through tables for a value

I have a PL/SQL stored procedure which searches for a row in 3 different tables (not all columns are the same). The logic goes as follows: ...
5
votes
2answers
281 views

Query for building a view

I am currently trying to improve on a query that is being used to build a view. The query is in PL/SQL, in an Oracle database. There are 3 different types of reports (100,200, and 300) that are ...
3
votes
1answer
133 views

XML schema for Database Unit Tests

I am attempting to develop an XML schema (XSD) to represent a set of unit tests for some code. (Specifically, I am testing Oracle PL/SQL stored procedures.) I would like to have something that ...
3
votes
2answers
1k views

Oracle PL/SQL decryption function breaking index?

I have a package called pkg_crypto. My select looks like this: ...