Alex Rivera | Logout

Questions tagged plsql

100 questions · page 1 of 2

Sort by: Newest Votes Active
9
votes
2
answers

PL SQL Auto Commit on execution

plsql plsqldeveloper
asked 2013-08-04T11:50:49.323
8
votes
3
answers

How to get all values in hierarchy linked to some value using Oracle CONNECT BY

oracle-database plsql connect-by
asked 2013-05-10T19:42:41.653
25
votes
3
answers

How to increase dbms_output buffer?

sql oracle-database plsql oracle10g dbms-output
asked 2013-05-10T06:39:37.057
10
votes
4
answers

Determining query's progress (Oracle PL/SQL)

sql database oracle-database plsql monitoring
asked 2013-04-10T23:03:33.103
9
votes
2
answers

PL/SQL FOR LOOP IMPLICIT CURSOR

oracle-database for-loop plsql database-cursor
asked 2013-04-06T18:51:03.313
11
votes
1
answers

Why cannot I create triggers on objects owned by SYS?

oracle-database plsql oracle11g database-trigger
asked 2013-03-13T04:54:27.670
12
votes
5
answers

Calling an Oracle PL/SQL procedure in Java using a CallableStatement with a boolean IN parameter gives an PLS-00306 oracle error:

java sql oracle-database jdbc plsql
asked 2013-01-28T01:27:29.057
9
votes
5
answers

how to find partition of record oracle

database oracle-database plsql oracle11g database-partitioning
asked 2012-12-01T13:35:20.010
41
votes
17
answers

PLSQL :NEW and :OLD

oracle-database plsql triggers
asked 2012-10-30T08:37:20.753
10
votes
2
answers

How to display a sys_refcursor data in TOAD's DataGrid

sql plsql oracle11g toad sys-refcursor
asked 2012-10-05T13:54:40.327
12
votes
3
answers

Procedure in package specification

oracle-database stored-procedures plsql scope package
asked 2012-10-03T11:06:03.667
10
votes
3
answers

Sql Insert statement return "zero/no rows inserted"

oracle-database plsql insert
asked 2012-08-09T05:08:38.193
10
votes
5
answers

How can I check if a procedure exists in a package?

oracle-database plsql
asked 2012-07-11T15:46:17.040
10
votes
5
answers

What is the simplest way to define a local variable in Oracle?

oracle-database variables plsql
asked 2012-07-02T17:53:35.430
9
votes
1
answers

how to declare %ROWTYPE of a variable that is a weakly typed SYS_REFCURSOR?

oracle-database stored-procedures plsql sys-refcursor rowtype
asked 2012-06-25T10:16:22.333
22
votes
5
answers

oracle pl/sql DBMS_LOCK error

oracle-database plsql
asked 2012-06-03T13:32:57.330
18
votes
1
answers

ORA-00947 Not enough values while declaring type globally

oracle-database plsql oracle11g ora-00947
asked 2012-04-18T16:11:02.993
21
votes
1
answers

PL/SQL Inserting 1 row for each result in a select

plsql for-loop insert procedure
asked 2012-03-29T14:06:10.680
30
votes
3
answers

Solution to "cannot perform a DML operation inside a query"?

sql oracle-database function stored-procedures plsql
asked 2012-01-04T15:20:16.100
36
votes
5
answers

How to declare and display a variable in Oracle

oracle-database plsql oracle11g
asked 2012-01-04T09:19:46.590
9
votes
2
answers

Print Record fields in PL/SQL

oracle-database plsql
asked 2012-01-03T19:01:35.617
12
votes
2
answers

How to see refcursor result/output in Oracle SQL Developer?

oracle-database plsql oracle10g oracle-sqldeveloper ref-cursor
asked 2011-12-22T22:38:32.647
8
votes
3
answers

plsql/cursors handle exception and return back to the execution flow

sql oracle-database plsql database-cursor
asked 2011-12-19T19:23:16.467
13
votes
2
answers

Oracle trigger to create an autonumber

oracle-database plsql triggers
asked 2011-11-30T17:31:21.743
10
votes
2
answers

What type of join is '....where A.ID = B.ID (+)'

sql oracle-database join plsql oracle11g
asked 2011-11-30T16:18:11.680
10
votes
5
answers

Simple Oracle variable SQL Assignment

oracle-database variables plsql toad
asked 2011-11-07T17:06:43.170
26
votes
3
answers

Existing state of packages has been discarded

sql oracle-database stored-procedures error-handling plsql
asked 2011-10-27T18:15:12.257
112
votes
9
answers

Printing the value of a variable in SQL Developer

oracle-database plsql oracle-sqldeveloper
asked 2011-10-25T09:44:52.970
9
votes
4
answers

Remove all characters after a specific character in PL/SQL

sql oracle-database plsql oracle9i substr
asked 2011-10-10T19:22:50.967
20
votes
3
answers

Get the name of the calling procedure or function in Oracle PL/SQL

oracle-database function plsql procedure
asked 2011-09-01T17:18:37.603
12
votes
2
answers

where to define default value in oracle package

sql oracle-database plsql messagebroker
asked 2011-08-31T16:58:31.887
11
votes
3
answers

What are the common mistakes pl/sql programmers make with money computation?

oracle-database plsql
asked 2011-08-26T02:09:24.437
12
votes
2
answers

dbms_scheduler.run_job('jobName) fails to run

oracle-database stored-procedures plsql dbms-scheduler
asked 2011-08-25T10:13:48.947
17
votes
3
answers

how to print out the definition of a procedure in Oracle?

sql oracle-database plsql
asked 2011-08-23T20:45:10.620
14
votes
2
answers

PL/SQL Update Join?

join plsql
asked 2011-07-26T00:44:28.977
13
votes
4
answers

Using ref cursor vs sys_refcursor inside a Stored Procedure Parameters

plsql
asked 2011-07-24T09:09:45.797
10
votes
5
answers

display select results inside anonymous block

oracle-database plsql oracle10g oracle-sqldeveloper pls-00428
asked 2011-06-23T14:19:49.427
20
votes
2
answers

How to compare string in PL/SQL?

oracle-database plsql
asked 2011-06-10T07:01:11.573
9
votes
4
answers

Understanding Oracle aliasing - why isn't an alias not recognized in a query unless wrapped in a second query?

sql oracle-database plsql alias
asked 2011-05-27T14:37:34.877
30
votes
4
answers

PL/SQL check if query returns empty

plsql
asked 2011-05-10T19:00:23.537
15
votes
2
answers

Is there any hash function in PL/SQL?

oracle-database hash plsql oracle-sqldeveloper
asked 2011-04-08T13:29:53.387
19
votes
7
answers

Oracle - How to obtain information on index fields etc

plsql oracle10g
asked 2011-03-23T17:58:15.413
18
votes
6
answers

Where can I "practice" PL/SQL

database plsql
asked 2011-02-07T10:41:03.730
9
votes
5
answers

How to run sql scripts from a pl sql procedure

sql oracle-database plsql
asked 2011-01-23T05:35:54.583
16
votes
2
answers

Function that would return the data retrieved from a select query - Oracle

oracle-database function stored-procedures plsql return
asked 2011-01-20T16:20:58.937
14
votes
2
answers

Splitting files in Mercurial and retaining history on both sides

mercurial plsql
asked 2010-11-11T15:32:19.353
9
votes
3
answers

Select from PLSQL Associative array?

plsql
asked 2010-10-18T17:55:57.483
21
votes
8
answers

SELECT DISTINCT CLOB_COLUMN FROM TABLE;

oracle-database plsql ora-00932
asked 2010-10-13T08:37:49.893
40
votes
3
answers

What does "%Type" mean in Oracle sql?

sql oracle-database plsql
asked 2010-09-24T20:17:36.583
14
votes
1
answers

oracle pl/sql arrays

arrays oracle-database plsql
asked 2010-08-23T07:09:30.607
page 1 of 2 Next →