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.

display resultset from oracle 10g stored procedure

I am using PL/SQL Developer and i have written a procedure to run a report and i need to …

oracle stored-procedures resultset plsqldeveloper
How to test if a string is inside a list of predefined strings via Oracle PL/SQL

I defined a list of strings, which contains different country codes (like USA ,CHINA,HK,JPN,etc.). How can I …

oracle plsql plsqldeveloper
How to set numwidth in the grid output of PL/SQL developer?

I'm running some queries in PL/SQL Developer, and one of the columns in the result has 18-digit numbers. Instead …

sql oracle plsqldeveloper
oracle pl/sql bug: can't put_line more than 2000 characters

Has anyone else noticed this phenomenon where dbms_output.put_line is unable to print more than 2000 characters at a …

oracle plsql plsqldeveloper
PLSQL CLOBS into variables

I'm trying to save a CLOB into a variable to perform operations like extract and such. I have this code: …

oracle plsql oracle10g oracle11g plsqldeveloper
How to figure out Oracle Connection String from PL SQL Developer's connection?

I PL/SQL Developer installed (pre-loaded by my company) on my laptop, when I want to connect to an ORACLE …

connection-string plsqldeveloper dbvisualizer
how to get count(*) value in local temp variable in dynamic sql (ORACLE PLSQL)

I want to get count(*) value in dynamic plsql statement. We can write static stmt as: select count(*) into tmp_…

oracle plsql plsqldeveloper
PLSQL Trigger to update field value in another table

I am quite new to triggers so obviously I am doing something wrong somewhere. I am working on a report …

oracle plsql oracle11g plsqldeveloper
PLSQL read value from XML?

I have a string with XML code, I want to extract a value from it in PL/SQL to a …

xml plsql plsqldeveloper
Decrypting Stored Password on PL/SQL Developer

When you save connection details on All Around Automation's PL/SQL Developer, the password is encrypted as follows: DisplayName=Oracle …

oracle plsqldeveloper password-encryption