Top "Plsql" questions

ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 536

Below is the code i use to extract data from a table to a flat file. BEGIN DECLARE file_name …

oracle plsql oracle11g ora-06512

create table with sequence.nextval in oracle

i created a sequence using the following query, create sequence qname_id_seq start with 1 increment by 1 nocache; Now when …

sql database oracle plsql

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

I want to create a stored procedure with one argument which will return different sets of records depending on the …

sql oracle plsql

Is there a function to split a string in PL/SQL?

I need to write a procedure to normalize a record that have multiple tokens concatenated by one char. I need …

string oracle plsql split tokenize

Passing an array of data as an input parameter to an Oracle procedure

I'm trying to pass an array of (varchar) data into an Oracle procedure. The Oracle procedure would be either called …

oracle stored-procedures plsql

What is the max size of VARCHAR2 in PL/SQL and SQL?

I am on Oracle 10g. In a requirement I need to increase the size of a pl/sql VARCHAR2 variable. …

sql oracle plsql varchar2

Oracle SQL: Use sequence in insert with Select Statement

Basically I want to run the following query: INSERT INTO historical_car_stats (historical_car_stats_id, year, month, make, …

sql oracle plsql insert sequence

check if "it's a number" function in Oracle

I'm trying to check if a value from a column in an oracle (10g) query is a number in order …

oracle plsql oracle10g

Convert comma separated string to array in PL/SQL

How do I convert a comma separated string to a array? I have the input '1,2,3' , and I need …

oracle plsql tokenize

How to create a oracle sql script spool file

I have a question about spooling the the results of my program. My sample sql script looks like this. whenever …

oracle plsql sql-scripts spool