Top "Plsql" questions

Oracle: how to INSERT if a row doesn't exist

What is the easiest way to INSERT a row if it doesn't exist, in PL/SQL (oracle)? I want something …

oracle plsql

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

Say I have an Oracle PL/SQL block that inserts a record into a table and need to recover from …

oracle plsql

Default Values to Stored Procedure in Oracle

I have a stored procedure as follows. CREATE OR REPLACE PROCEDURE TEST( X IN VARCHAR2 DEFAULT 'P', Y IN NUMBER …

stored-procedures parameters plsql oracle11g default

Proper way of checking if row exists in table in PL/SQL block

I was writing some tasks yesterday and it struck me that I don't really know THE PROPER and ACCEPTED way …

sql oracle select plsql

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

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

sql oracle plsql views

oracle plsql: how to parse XML and insert into table

How to load a nested xml file into database table ? <?xml version="1.0" ?> <person> <row> &…

xml oracle plsql insert xml-parsing

How can you tell if a value is not numeric in Oracle?

I have the following code that returns an error message if my value is invalid. I would like to give …

sql oracle plsql isnumeric

Oracle "ORA-01008: not all variables bound" Error w/ Parameters

This is the first time I've dealt with Oracle, and I'm having a hard time understanding why I'm receiving this …

sql oracle plsql oracle10g

ORA-00060: deadlock detected while waiting for resource

I have a series of scripts running in parallel as a nohup on an AIX server hosting oracle 10g. These …

database oracle unix plsql aix

dropping a global temporary table

2 Separate questions. I am using this script to drop a table [SOLVED] BEGIN EXECUTE IMMEDIATE 'DROP TABLE_NAME'; DBMS_OUTPUT.…

oracle plsql ddl temp-tables