Top "Plsql" questions

ORA-01747: invalid user.table.column, table.column, or column specification

Get the above error when the execute immediate is called in a loop Update CustomersPriceGroups set 1AO00=:disc Where cuno=:…

oracle plsql dynamic-sql

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

I am a bit rusty on my cursor lingo in PL/SQL. Anyone know this?

oracle plsql

PL/SQL print out ref cursor returned by a stored procedure

How can I fetch from a ref cursor that is returned from a stored procedure (OUT variable) and print the …

oracle plsql cursor ref

Check if a variable is null in plsql

I want to check if a variable is null. If it is null, then I want to set a value …

sql oracle plsql

SQL to generate a list of numbers from 1 to 100

Using the DUAL table, how can I get a list of numbers from 1 to 100?

sql oracle plsql

Subtracting Dates in Oracle - Number or Interval Datatype?

I have a question about some of the internal workings for the Oracle DATE and INTERVAL datatypes. According to the …

sql oracle date plsql oracle11g

How to increase dbms_output buffer?

I tried to debug my dynamic query via dbms_output but seems like the query string is too long for …

sql oracle plsql oracle10g dbms-output

Create an Oracle function that returns a table

I'm trying to create a function in package that returns a table. I hope to call the function once in …

plsql oracle10g package

Oracle Convert Seconds to Hours:Minutes:Seconds

I have a requirement to display user available time in Hours:Minutes:Seconds format from a given total number of …

sql oracle plsql plsqldeveloper

ORA-06508: PL/SQL: could not find program unit being called

I am using oracle 10g and toad 11.5. I am trying to call an api from an anonymous block. If I …

oracle plsql anonymous