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.
3
votes
1answer
25 views
How can I make my XML schema robust?
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 ...
2
votes
1answer
90 views
Cross-language Constants
Background
Developing a web application that leverages multiple programming languages. The data flow resembles:
Browser » PHP » PL/SQL » XML » XSLT » XHTML + JavaScript » Browser
Using different ...
2
votes
3answers
114 views
How can I refactor this PL/SQL code?
This works, but nvl AND case seem redundant.
Basically, if null then 'N' else 'Y.
CHICKEN_HATCH_DATE is a DATE data type.
select stricken_chicken_id,
case ...
3
votes
2answers
365 views
Oracle PL/SQL decryption function breaking index?
I have a package called pkg_crypto.
My select looks like this:
SELECT "SEQ", pkg_crypto.decrypt("NAME", 'secret') name, pkg_crypto.decrypt("TEL", 'secret') tel
FROM MYTABLE
ORDER BY "SEQ" DESC
...
1
vote
2answers
569 views
SQL query for adding column value to compare with other column
I have two tables
table_inventory
List item
inventory_rack_key(primarykey)
node_key
rack_id
inventory_item_key
in_coming_qty,locked_qty
quantity
table_item
...
