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 555

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.

2
votes
Not to the current session, no. You can use the dbms_application_info package to instrument the code so that tools running in other sessions can query v$session_longops and see how far along the proc …
answered Jun 24 '15 by Justin Cave
2
votes
You can always nest blocks in PL/SQL DECLARE <<define your other local variables>> PROCEDURE drop_if_exists( p_table_name IN VARCHAR2 ) AS l_num_tables pls_integer; BEGIN SELECT COUN …
answered May 27 '14 by Justin Cave
7
votes
Gathering statistics and rebuilding indexes are two completely separate things. It is exceedingly rare that an index in Oracle needs to be rebuilt so any process that is regularly rebuilding an in …
answered Jul 24 '12 by Justin Cave
1
vote
Depending on your privilege level, you'd want to use DBA_TABLES, ALL_TABLES, or USER_TABLES. There is a StackOverflow thread that walks through this in some detail. By default, Oracle identifiers ar …
answered Dec 18 '14 by Justin Cave
1
vote
You can't use contains because there is no Oracle Text index on the database source. You could, I suppose, write a query that copied the data from dba_source to a custom table, create an Oracle Text …
answered Oct 20 '14 by Justin Cave
0
votes
If you are asking how to call the small procedure, the answer is that you have to declare the b1 variable in the caller. declare b1 varchar2(10); begin sma11(1000,b1); end; If you are asking wh …
answered Jan 28 '16 by Justin Cave
3
votes
It sounds like you want WHERE date_entered BETWEEN sysdate - interval '2' hour AND sysdate Assuming date_entered never contains future dates WHERE date_entered >= sysdate - …
answered Aug 10 '15 by Justin Cave
4
votes
Generally, it doesn't make sense to create tables in anonymous blocks let alone to then insert data into those tables in the same anonymous block. Creating new objects at runtime is a bad idea (hopef …
answered Mar 12 '13 by Justin Cave
8
votes
It sounds like you want the GREATEST function INSERT INTO my_table( date_column ) VALUES( GREATEST( date_default, date_insert_value ));
answered Feb 14 '13 by Justin Cave
15
votes
The code you posted is using a cursor. It is using an implicit cursor loop. There are cases where using an explicit cursor loop (i.e. declaring a CURSOR variable in the declaration section) produces …
answered Oct 16 '12 by Justin Cave
1
vote
There are two ways to raise exceptions in Oracle. If you want to specify your own message, you wouldn't declare a local variable of type exception. You'd simply put the error code in your raise_appl …
answered Feb 21 '16 by Justin Cave
2
votes
Technically, you could create a Java stored procedure or a dbms_scheduler external job that you invoke from your APEX process. Doing so, however, would almost certainly be a mistake. First, you'd ha …
answered Aug 27 '14 by Justin Cave
0
votes
Yes, if this was to work, it would generate an infinite loop. But more than likely, it will throw a mutating table exception first. What is the problem that you are trying to solve? A trigger that …
answered Jun 22 '15 by Justin Cave
6
votes
Assuming that you are using PL/SQL to dequeue the message (there may be additional JMS limitations-- I don't know enough about the interplay between JMS and AQ), you should be able to use a priority q …
answered Feb 23 '11 by Justin Cave
3
votes
The problem is that the variable a that you declare in your declaration section is not the same as the variable a that is declared in the context of your loop. You've declared two different variables …
answered Nov 22 '15 by Justin Cave

15 30 50 per page