Stack Overflow
Stack Overflow

Questions tagged [plsqldeveloper]

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.

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.

Home page: http://www.allroundautomations.com/plsqldev.html

PL/SQL Developer should not be confused with Oracle's SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

1591 questions
13
votes
5 answers

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 of displaying the entire number in the resulting grid, PL/SQL Developer displays only 15 digits in scientific notation. I tried to find…
Ilya Kogan
  • 21,995
  • 15
  • 85
  • 141
13
votes
3 answers

How to keep alive the connection in PL/SQL Developer?

I am using PL/SQL Developer 11.0.4.1774. In my work, I need to use database whole day. Sometimes, during 30-60 minutes, I do not use ide and when I need to use it again, it requires reconnection. I do not want to reconnect, is there any way to keep…
Mehmet Akif Güzey
  • 367
  • 1
  • 4
  • 15
12
votes
5 answers

How to create a dump with Oracle PL/SQL Developer?

I need to take dump of a user (including tables, procedures ,etc.) as FILENAME.dmp. If I create a new user and import that FILENAME.dmp, then everything should be created. How can I create this dump file? Don't tel me to use the Run > EXP or Run >…
Gokul
11
votes
2 answers

Themes or Look and feel on PL/SQL Developer

How to change the look and feel or the colors of all in PL/SQL Developer? Because for current time, it's hard to work wheb all in black!
David Michaeli
  • 777
  • 4
  • 11
  • 22
11
votes
2 answers

What is the meaning of Cost, Cardinality and Bytes in Explain Plan?

This is a simple query: select * from customers When I write this query in PL/SQL Developer and press F5, I see Explain Plan, but I don't know what are Cost, Cardinality and Bytes represent.
M.Minbashi
  • 244
  • 1
  • 3
  • 12
11
votes
1 answer

How to debug a pipelined function in PL/SQL Developer?

I have a PL/SQL package in oracle database which contains a pipelined function named FN_GET_USERINFO_ROWS as bellow: CREATE OR REPLACE PACKAGE PKG_USERINFO AS TYPE TY_USERINFO_RECORD IS RECORD( U_ID VARCHAR2(50), …
mmuzahid
  • 2,252
  • 23
  • 42
11
votes
1 answer

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, which can include variable count of SELECT statements, something like: SELECT T1.COL1||T1.COL2||...||T1.COLn FROM T1 WHERE id=documentid SELECT…
Sergey
  • 157
  • 1
  • 6
  • 19
10
votes
4 answers

PL/SQL Developer: Multiple statements?

I have a script that generates a text file containing several SQL UPDATE statements: UPDATE TableX SET Field1 = 'New value 1' WHERE Field2='1'; UPDATE TableX SET Field1 = 'New value 2' WHERE Field2='2'; UPDATE TableX SET Field1 = 'New value 3' WHERE…
IVR Avenger
  • 15,090
  • 13
  • 46
  • 57
10
votes
1 answer

Update Parent and Child Table Simultaneously

I need to update a column in two tables that are joined by a primary/foreign key. My problem is that when I try to update either table separately, I get either of the following (dependant upon which table I try and update): ORA-02292: integrity…
TomB
  • 255
  • 2
  • 5
  • 15
9
votes
2 answers

Collapsible region for PL/SQL Developer

Is there some tag or command that would collapse a region of my code in plsqldeveloper; in netBeans for java, I use: and if my memory is right in c#: #region;
Roger
  • 2,912
  • 2
  • 31
  • 39
9
votes
7 answers

PL/SQL Developer Initialization error

I want use PL/SQL Developer first my oracle directory C:\oracle\product\10.2.0\client_1\BIN I use windows10 and environment variable setting ORACLE_HOME C:\oracle\product\10.2.0\client_1 Path C:\oracle\product\10.2.0\client_1\BIN but execute…
chohyunwook
  • 251
  • 2
  • 4
  • 9
9
votes
1 answer

Reasons why PL/SQL Developer's debugger won't enter a procedure?

I am trying to debug a procedure using PL/SQL developer's built-in debugger. After stepping over the BEGIN, when the debugger is over the actual procedure call, the "step-into" button will just execute the procedure without entering it. Any…
Nico Mezeret
  • 193
  • 1
  • 1
  • 7
9
votes
1 answer

PL/SQL Associative array validate if index exist

I have this Associative array 3-d type v_arr_class is table of varchar2(255) index by varchar2(255); type v_arr_component is table of v_arr_class index by varchar2(255); type v_arr_property is table of v_arr_component index by…
Andy Chaves
  • 137
  • 1
  • 2
  • 9
9
votes
1 answer

Generate test data using Oracle PL/SQL developer

I want to test some schemas and indexes, and I was wondering if there is a functionality in PL/SQL Developer that can generate test data (so I won't have to create sequences and loops to insert data in the tables).
eyettea
  • 1,376
  • 2
  • 16
  • 35
9
votes
1 answer

How do I check index building status on Oracle 11?

I made terrible mistake in SQL index creation: create index IDX_DATA_TABLE_CUSECO on DATA_TABLE (CUSTOMER_ID, SESSION_ID, CONTACT_ID) tablespace IDX_TABLESPACE LOCAL ; As You can see I missed keyword "ONLINE" to create index without blocking…
WBAR
  • 4,924
  • 7
  • 47
  • 81
1
2
3
…
99 100