Top "Plsql" questions

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural language extension for SQL.

Oracle - Insert New Row with Auto Incremental ID

I have a workqueue table that has a workid column. The workID column has values that increment automatically. Is there …

Read More
sql oracle plsql oracle10g
How can I get the number of records affected by a stored procedure?

For INSERT, UPDATE and DELETE SQL statements executed directly against the database, most database providers return the count of rows …

Read More
sql sql-server oracle tsql plsql
PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch …

Read More
oracle plsql oracle11g sqlplus
Subtracting Number of Days from a Date in PL/SQL

I would like to subtract a given x number of days from sysdate, can someone assist me on how to …

Read More
sql oracle plsql
PL/SQL block problem: No data found error

SET SERVEROUTPUT ON DECLARE v_student_id NUMBER := &sv_student_id; v_section_id NUMBER := 89; v_final_grade NUMBER; …

Read More
sql oracle plsql oracle10g ora-01403
How can I drop a "not null" constraint in Oracle when I don't know the name of the constraint?

I have a database which has a NOT NULL constraint on a field, and I want to remove this constraint. …

Read More
oracle plsql constraints
Get resultset from oracle stored procedure

I'm working on converting a stored procedure from SQL server to Oracle. This stored procedure provides a direct resultset. I …

Read More
oracle stored-procedures plsql
How to check if a column exists before adding it to an existing table in PL/SQL?

How do I add a simple check before adding a column to a table for an oracle db? I've included …

Read More
sql oracle plsql
PLS-00428: an INTO clause is expected in this SELECT statement

I am wanting to store a Rownum as a variable rather than use a costly Join. I need to get …

Read More
sql oracle plsql oracle11g
IF EXISTS condition not working with PLSQL

I am trying to print the TEXT when condition is TRUE. The select code is perfectly working fine. It's showing 403 …

Read More
sql oracle if-statement plsql