Top "Plsqldeveloper" questions

PL/SQL Developer is an Integrated Development Environment by Allround Automations that is specifically targeted at the development of stored program units for Oracle Databases.

Reading clob line by line with pl\sql

In my project i use oracle as primary database and i've faced a problem with parsing clob. So suppose we …

oracle plsql plsqldeveloper
Escape ampersand in PL/SQL Developer

I'm trying a simple INSERT statement against an Oracle database. One of the values is a VARCHAR2 field and the …

oracle escaping special-characters plsqldeveloper
How to parse comma delimited string in PL/SQL?

I have a comma delimited string in a PL/SQL script (e.g. data:= 'a,b,c,d,e'), that …

oracle stored-procedures plsql plsqldeveloper
update using for loop in plsql

i'm having problem updating and insert into below column. Please advise on this. This is the input depnto extra comm …

oracle plsqldeveloper
How to create cursor inside procedure body in plsql

I want create cursor inside procedure body dynamically also i have to use for loop instead of below code. i …

sql oracle plsql plsqldeveloper
Is there a keyboard shortcut for writing "SELECT * FROM" template?

Is there a way to generate a SELECT * FROM template in SQL editor by a certain keyboard shortcut in PL/…

plsqldeveloper
Skipping data fields while loading delimited data using SQLLDR

Consider below scenario: Table T1 (f1, f2, f3); Data files: a|b|c|d w|x|y|z I want …

oracle11g plsqldeveloper sql-loader
How to convert VARCHAR2 to BLOB inside Oracle 11g PL/SQL after ORA-06502

I have a function, that calculates hash value of big string! First of all I wrote a cursor T1_CUT, …

plsql oracle11g blob plsqldeveloper
How to use Oracle global temporary table?

I am attempting to use an Oracle global temporary table without physically creating a table in the database. The following …

oracle plsql oracle11g oracle10g plsqldeveloper
Executing stored procedure in PL/SQL Developer SQL Window

I've used TOAD for awhile, but my dept has asked me to evaluate PL/SQL Developer as a possible change. …

oracle exec procedure plsqldeveloper ora-00900