Alex Rivera | Logout

Questions tagged plsql

100 questions · page 2 of 2

Sort by: Newest Votes Active
14
votes
5
answers

Check if table exists in the database - PL SQL

oracle-database plsql
asked 2010-08-19T19:24:04.540
146
votes
4
answers

What is the Oracle equivalent of SQL Server's IsNull() function?

sql-server oracle-database t-sql plsql
asked 2010-08-19T14:55:49.423
21
votes
5
answers

Determine if Oracle date is on a weekend?

oracle-database date plsql weekend
asked 2010-08-10T16:02:48.343
24
votes
5
answers

Declaring & Setting Variables in a Select Statement

sql oracle-database variables plsql
asked 2010-08-03T19:26:21.287
20
votes
5
answers

How can I use Oracle SQL developer to run stored procedures?

oracle-database stored-procedures plsql oracle-sqldeveloper sys-refcursor
asked 2010-06-28T18:05:17.037
16
votes
3
answers

Oracle: copy row while updating one field

sql oracle-database plsql insert
asked 2010-06-22T18:28:48.523
22
votes
3
answers

PL/SQL pre-compile and Code Quality checks in an automated build environment?

oracle-database plsql continuous-integration build-automation code-analysis
asked 2010-06-10T12:18:57.793
18
votes
3
answers

oracle call stored procedure inside select

sql oracle-database stored-procedures plsql insert
asked 2010-05-19T11:50:24.550
31
votes
6
answers

UTL_FILE.FOPEN() procedure not accepting path for directory?

oracle-database plsql oracle9i utl-file
asked 2010-05-01T18:37:22.873
9
votes
3
answers

How to test if a string is inside a list of predefined strings?

oracle-database plsql
asked 2010-04-30T03:47:54.313
9
votes
7
answers

Oracle - Return shortest string value in a set of rows

sql oracle-database plsql
asked 2010-04-20T16:14:49.240
9
votes
4
answers

Does anyone use the PL/SQL Web Toolkit?

oracle-database plsql
asked 2010-03-04T20:31:59.987
78
votes
11
answers

How do I get column datatype in Oracle with PL-SQL with low privileges?

oracle-database plsql ddl privileges
asked 2010-02-26T02:04:59.223
10
votes
7
answers

Where to hold PL/SQL constants?

plsql
asked 2010-02-17T09:04:19.260
13
votes
4
answers

Executing a dynamic sql statement into a SYS_REFCURSOR

sql oracle-database plsql
asked 2010-02-09T16:01:38.323
12
votes
2
answers

Using an Oracle Table Type in IN-clause - compile fails

oracle-database plsql associative-array database-cursor
asked 2010-01-11T22:57:33.000
9
votes
3
answers

Oracle PLSQL - Declare a cursor on a non-existing table

oracle-database plsql database-cursor ora-00942
asked 2009-12-21T19:26:12.507
12
votes
1
answers

Unit testing with Oracle

oracle-database unit-testing plsql
asked 2009-12-16T21:31:30.517
13
votes
3
answers

How to send arbitrary parameters to Oracle trigger?

java oracle-database jdbc plsql
asked 2009-12-10T12:39:40.677
22
votes
8
answers

Oracle PL/SQL - tips for immediate output / console printing

oracle-database debugging plsql console-output unbuffered-output
asked 2009-11-13T14:59:22.280
44
votes
4
answers

In Oracle, is it possible to INSERT or UPDATE a record through a view?

sql oracle-database plsql view
asked 2009-10-31T00:46:17.580
27
votes
4
answers

pl/sql stored procedure: parameter name same as column name

oracle-database stored-procedures plsql
asked 2009-10-22T15:07:40.323
10
votes
10
answers

Is it OK to nest database views?

sql oracle-database plsql view
asked 2009-09-29T20:27:53.050
9
votes
3
answers

Does Oracle roll back the transaction on an error?

sql oracle-database transactions plsql oracle10g
asked 2009-09-23T19:32:35.180
22
votes
4
answers

PL/SQL Logging - How to control?

oracle-database plsql oracle10g instrumentation
asked 2009-08-05T09:55:40.430
9
votes
2
answers

Oracle CASE with OR

oracle-database plsql
asked 2009-07-08T18:38:03.883
395
votes
6
answers

What is the difference between SQL, PL-SQL and T-SQL?

sql t-sql plsql
asked 2009-06-25T10:54:48.837
27
votes
12
answers

Hidden features of PL/SQL

sql oracle-database plsql
asked 2009-06-23T09:20:03.967
12
votes
5
answers

Oracle EXECUTE IMMEDIATE with variable number of binds possible?

oracle-database plsql dynamic-sql
asked 2009-06-17T15:45:04.147
12
votes
7
answers

How to iterate over a date range in PL/SQL

sql database oracle-database plsql
asked 2009-06-12T16:21:38.660
27
votes
8
answers

Bulk Insert into Oracle database: Which is better: FOR Cursor loop or a simple Select?

sql oracle-database plsql
asked 2009-06-12T14:44:58.687
36
votes
5
answers

Oracle Pl/SQL: Loop through XMLTYPE nodes

xml oracle-database plsql xmltype
asked 2009-06-12T09:49:12.877
27
votes
5
answers

Abort a PL/SQL program

oracle-database plsql
asked 2009-05-21T05:06:54.857
194
votes
6
answers

Number of rows affected by an UPDATE in PL/SQL

oracle-database plsql sql-update
asked 2009-05-14T07:21:22.210
13
votes
6
answers

What Situations Cause Oracle Packages to Become Invalid?

oracle-database plsql package dependencies
asked 2009-03-09T13:37:48.747
25
votes
9
answers

Can We use threading in PL/SQL?

oracle-database asynchronous plsql
asked 2009-02-23T07:35:08.657
46
votes
4
answers

How to catch a unique constraint error in a PL/SQL block?

oracle-database plsql
asked 2009-01-13T18:17:46.390
9
votes
7
answers

Session based global variable in Postgresql stored procedure?

oracle-database postgresql plsql plpgsql
asked 2009-01-05T21:09:59.457
16
votes
8
answers

IDE for Pl/SQL development

oracle-database debugging plsql
asked 2008-11-20T09:05:57.177
21
votes
3
answers

PL/SQL: How do I declare session variables?

oracle-database plsql
asked 2008-11-19T09:24:09.840
10
votes
2
answers

Access Web service from Oracle stored procedure

java oracle-database web-services stored-procedures plsql
asked 2008-11-18T15:08:43.200
18
votes
4
answers

Find out name of PL/SQL procedure

oracle-database plsql
asked 2008-11-13T08:45:26.697
24
votes
10
answers

Unit Testing Framework for Oracle PL/SQL?

sql oracle-database unit-testing plsql
asked 2008-10-15T00:58:07.630
10
votes
3
answers

What is the syntax to use a Select statement inside a PL/SQL Trigger?

sql oracle-database plsql ora-00923
asked 2008-10-14T20:12:05.057
14
votes
3
answers

What is the size limit for a varchar2 PL/SQL subprogram argument in Oracle?

oracle-database plsql
asked 2008-10-09T08:26:10.113
17
votes
9
answers

ORA-01438: value larger than specified precision allows for this column

sql database oracle-database plsql ora-01438
asked 2008-10-08T04:30:11.650
14
votes
2
answers

Does anyone know some cool PL/SQL plugin for IntelliJ Idea?

plugins plsql intellij-idea
asked 2008-10-03T15:31:08.120
13
votes
6
answers

Code coverage for PL/SQL

oracle-database plsql
asked 2008-09-30T09:55:14.073
47
votes
5
answers

How to return multiple rows from the stored procedure? (Oracle PL/SQL)

sql oracle-database plsql
asked 2008-09-19T10:46:48.460
28
votes
16
answers

What is the difference between explicit and implicit cursors in Oracle?

oracle-database plsql
asked 2008-09-16T16:06:52.083
← Prev page 2 of 2