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.
1
vote
1answer
23 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 ...
3
votes
1answer
61 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
64 views
1
vote
1answer
149 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
121 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
3answers
111 views
5
votes
2answers
266 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
122 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
980 views
Oracle PL/SQL decryption function breaking index?
I have a package called pkg_crypto.
My select looks like this:
...
