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

Oracle/SQL: Recursive Query for a Many-to-many relationship

I am trying to make a query in Oracle SQL that is able to find all connected records through it's parent, then find the parents of the children and so on. I have been looking into CONNECT BY and START WITH select queries but I have not been able to…
Dave G
  • 21
  • 2
2
votes
1 answer

how to export schema and import it to another schema in PL\SQL Developer

I am using PL\SQL Developer by AllroundAutomations. My task is to import schema named EN to another schema (it doesn't exist now) called E9. I managed to make a dump of a scheme using Tools --> Export User Objects, so now I have EN.sql file So, here…
paut
  • 65
  • 1
  • 11
2
votes
1 answer

Is possible write in xls file and open the file when executed using plsql developer?

I have a procedure to write a report in Xls file using utl_file. This procedure works correctly but my question is: is it possible to open this file directly in Excel after executed? I ask it because, when it's executing now, I must open the folder…
M.Youssef
  • 146
  • 9
2
votes
2 answers

Handle a very large string in pl/sql script

I am trying to run below code which reads the index definition for table A so that it can be created again after I delete/create that in this script. This script runs fine when the returned value(ddl) is small but in other environments where the…
Mayank Aggarwal
  • 35
  • 4
2
votes
1 answer

PL/SQL developer export query result as merge statements

I just started to use PL/SQL Developers tools. Before I used to use Toad for Oracle. In Toad, I can generate Merge Statement from the Query result for every records and it give me following example result. (for single result) MERGE user T USING ( …
gourcam
  • 21
  • 4
2
votes
1 answer

How to include a column containing calculation for a SELECT script?

Just getting my head around PL/SQL. I wanted to create a SELECT script that will show the difference in date between a start date and an end date and then display a message accordingly within the Flag_Status column. If the results from the…
user12009722
  • 35
  • 6
2
votes
1 answer

Debugging PL/SQL Collections using PL/SQL Developer

How can I see in the debug window (PL/SQL Developer, version 10.0.5.1710) to look up information on an array of data in a collection: the nesting hierarchy, elements with data types and their values without listing all its elements…
ITR
  • 21
  • 3
2
votes
3 answers

What is the difference between data dictionary table and data dictionary views in oracle?

I was searching for data dictionary tables and i ended up in this page which describes "Tables Data Dictionary Views" with there description. https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables014.htm#ADMIN01508 So what is the difference…
Erik
  • 307
  • 5
  • 15
2
votes
2 answers

Exporting databases or tables can't be done in pl/sql developer

I am currently using PL/SQL developer software to manage my databases, however, when I want to import or export tables or databases, "Export" or "Import" buttons are disabled in it as shown in picture. Here, "Export" button can't be clicked as It is…
Arslonbek Kulmatov
  • 21
  • 1
  • 3
2
votes
3 answers

Can't connect to oracle database with IntelliJ, Locale not recognized

I have Oracle Database 11g Express Edition installed, and can normally connect to my local database with PLSQL Developer, but I can't connect with IntelliJ. It says Locale not recognized. After searching for some similar questions here, solution…
Aleksandre Tskhovrebovi
  • 94
  • 1
  • 8
2
votes
0 answers

Execution flow for PL/SQL

I have many packages in production system and those packages has as much procedures.Say some of them updates/inserts into a table. How can I identify those packages in sequence of operation without going through 1000s lines of code. Thanks.
user8950495
2
votes
0 answers

How do I filter names containing "_" in object window in PL/SQL Developer

For example. I have a lot of objects names "C_something" how do I filter objects in the objects window to only show the ones starting with "C_" since "_" is used as a wildcard character. image of IDE GUI
Zelloxy
  • 45
  • 3
2
votes
1 answer

SQL Developer Status : Failure - I/O Test failed: The Network Adapter could not establish the connection

I am a newbie don't know how to use SQL developer. whether I need Oracle database for installing in windows 10 what are these hr and sys users and how to know their passwords. please help me I know this question is asked many times but really,…
vikas2cc
  • 43
  • 1
  • 9
2
votes
1 answer

Can't run hello world in PL/SQL

I am trying to learn PL/SQL, but I cannot run a basic script. At this point I feel there is not a syntax issue, but something basic I'm missing. BEGIN dbms_output.put_line('Hello world'); END When I run it I get an error saying Error starting at…
Jaymes
  • 37
  • 5
2
votes
3 answers

INSERT INTO SELECT vs. INSERT from Cursor in PL/SQL

So I have this project I'm working on at work and I've noticed a lot of people using a the INSERT INTO SELECT method: INSERT INTO candy_tbl (candy_name, candy_type, candy_qty) SELECT food_name, …
nlgatewood
  • 53
  • 1
  • 1
  • 7
1 2 3
…
99 100