Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 993

Procedural Language/Structured Query Language is Oracle Corporation's procedural language extension for SQL. IBM supports PL/SQL for DB2 since version 9.7. Questions about PL/SQL should probably be tagged "oracle" or "db2" as well.

6
votes
I don't know of any built-in way to accomplish this but you could use a derived table or a Common Table Expression (CTE or as Oracle likes to call them: subquery_factoring_clause), if your aim is to p …
answered Jun 19 '14 by ypercubeᵀᴹ
4
votes
I guess that using subqueries inside functions is the main performance problem. It seems that the functions are fairly simple and you could drop them and easily rewrite the query with joins only: S …
answered Nov 15 '12 by ypercubeᵀᴹ
0
votes
In Oracle triggers, you can access the modified table using :NEW (for inserted and after an update data) and :OLD (for deleted and before the update). Also there is noUPDATE .. FROM syntax. Your tri …
answered Nov 24 '17 by ypercubeᵀᴹ
2
votes
The problem is that we know that the join will produce only 1 row (and no more) in the view for every row in MY_CFG_TABLE but Oracle doesn't. As described in OraFAQ: Updatable Join Views (emphasis min …
answered Sep 22 '16 by ypercubeᵀᴹ