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.

learn more… | top users | synonyms

-1
votes
2answers
43 views

Checking whether a grade combination exists

Below function checks if a grade exists ...
1
vote
1answer
28 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
104 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: ...
1
vote
2answers
95 views

for loop vs table cast

I've created a sample table in Oracle 11.2.0.1.0: ...
5
votes
2answers
259 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
112 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
815 views

Oracle PL/SQL decryption function breaking index?

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