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
2
votes
1 answer

Setting a value for LIMIT while using bulk collect

I wanted to know if we have any technique by which we can calculate the value which needed to be set for a LIMIT clause of bulk collect operation. For example below, lets say our cursor has 10 Million records..What is the value which we can set for…
XING
  • 9,608
  • 4
  • 22
  • 38
2
votes
3 answers

How to create recursive query to get all dates between two dates

I want to get all dates between two dates arrival date and leaving date. I tried that recursive query but it didn't work. ;with dates as ( SELECT GuestID, ArrivalDate as reserveddate from dbo.Guest union all SELECT GuestID, dateadd…
Kerols Alfons
  • 59
  • 1
  • 10
2
votes
1 answer

Is it possible to connect to Postgres DB with PL/SQL Developer?

Is it possible to connect to Postgres DB with "PL/SQL Developer" like we can connect Oracle DB ?? Thanks.
obsolete
  • 33
  • 2
  • 8
2
votes
1 answer

Conditional Compilation PL/SQL

Can someone explain the concept of Conditional Compilation in PL/SQL? I have researched but can not quite understand the reasoning behind using it and what it actually does. An example would be great! Also, I would like to know more about…
applesandgrapes
  • 23
  • 5
2
votes
3 answers

Generating an alphabetic sequence in oracle

I'm looking for a way of generating an alphabetic sequence: AA, AB, AC, AD, AE, ..., ZZ. Can anyone suggest a convenient way of doing this in oracle.
Sundarraj
  • 21
  • 1
  • 4
2
votes
1 answer

how to extract tables attributes like column name , datatype ,nullable for all the tables from the database from oracle pl/sql

Is there any query that can be used to retrive the Tables and its column attributes like column name , datatype, nullable etc for all the tables inside the database For Oracle Pl/SQL
user5139081
2
votes
1 answer

PL\SQL Query Optimization (currently slow)

I was wondering if the community could help me optimize this query but achieve the same results. Currently, it takes roughly 22 minutes to return. I have tried a few different things but they took longer. Any help is appreciated! GL_TYPE - SIZE 1MB…
Christopher
  • 21
  • 2
2
votes
1 answer

SQL*Plus and SQL Developer

I have just a simple question regarding executing a pl/sql script inside SQL*PLUS: create or replace trigger CICD.S_ACCNT_POSTN_DELETE after delete on CICD.S_ACCNT_POSTN FOR EACH ROW BEGIN INSERT INTO CICD.CX_PROCCHLDDEL (ROW_ID,…
nassah
  • 35
  • 5
2
votes
2 answers

How to easily check the return value of a function in PL/SQL Developer

Totally newbie with database. Now I have created a function which returns a NUMBER, I just simply want to check the result of this function. The tool I am using is PL/SQL Developer but I can't find a output window or whatever. And of course I don't…
tete
  • 4,859
  • 11
  • 50
  • 81
2
votes
2 answers

Backup of package in oracle plsql

I am new to pl/sql, I have a pkg_body and I want to make changes to it. But before doing that I want to take backup of the original pkg. So can I create a new pkg with name **_bkp and just copy the code into it. I have found the below code when…
sandywho
  • 353
  • 1
  • 7
  • 16
2
votes
1 answer

How to research what resources are leaked by which application (not a full ATOM table issue)

Some application on my system is leaking resources. But I don't know what it is leaking and which application. The leak causes other applications to fail with error messages like this: System Error. Code: 8. Not enough storage is available to…
Jeroen Pluimers - Binck
  • 161
  • 12
2
votes
2 answers

Update and insert in oracle PL/SQL along with if else condition

Please find by below code snippet : BEGIN IF (in_config1 IS NOT NULL OR in_config1 !='') THEN UPDATE question_table SET comment = in_config1 WHERE id= id AND questionid = 1; ELSE INSERT INTO question_table( …
nutty
  • 67
  • 2
  • 8
2
votes
4 answers

Can Oracle PL/SQL CASE statement include a SELECT query?

I'm trying to do something similar to this: CASE WHEN number IN (1,2,3) THEN 'Y' ELSE 'N' END; Instead I want to have a query in the place of the list, like so: CASE WHEN number IN (SELECT num_val FROM some_table) THEN 'Y' ELSE 'N' END; I can't…
Miguel
  • 23
  • 1
  • 1
  • 3
2
votes
1 answer

Oracle PLSQL update table where in Associative Array?

I would like to, in a stored proc, update all the records that match an id. Now, this list of id, is being passed in as a table of varchar (Associative Array).. CREATE TYPE varcharArray AS TABLE OF VARCHAR2(1000) index by ... and the proc…
Ocelot
  • 1,733
  • 4
  • 29
  • 53
2
votes
2 answers

Invoking a function call in a string in an Oracle Procedure

I writing an application using Oracle 10g. I am currently facing this problem. I take in "filename" as parameter of type varchar2. A sample value that filename may contain is: 'TEST || to_char(sysdate, 'DDD')'. In the procedure, I want to get the…
DMS
  • 105
  • 2
  • 2
  • 5
1 2 3
…
99 100