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
2 answers

Oracle SQL. How to display result of execute immediate statement

I have a dynamic select script which I build using pl/slq and I need to execute it in simple SQL. How can I do these? P.S.: I can't use views, because number of collumn's in returned table changes every time.
dududko
  • 601
  • 6
  • 5
2
votes
1 answer

Oracle: insert using select is not returning bulk collect newly inserted ids

Table Name: T_record Id(auto increment using sequence) Name Age 1 Chitta 18 2 Chitta1 19 3 Chitta2 18 4 …
Chittaranjan Sethi
  • 443
  • 7
  • 24
2
votes
1 answer

loading xml file to oracle table

I have a requirement to load an xml file to a particular table. i have tried with below code but it did not solve my problem. The xml data is: 7839 FAX SENT …
ravt
  • 71
  • 2
  • 9
2
votes
1 answer

Using a Variable in a Table Creation Script

I'm having some difficulty in creating a PL/SQL block. The purpose of my script is to pull a report based on the last month's totals in a table (which has already been created as table name "countpull"). I want to use the name of the month in my…
Emma
  • 277
  • 1
  • 10
2
votes
1 answer

Import with pl/sql developer

I have an sql file that contains user schema with all objects(tables, packages) which I get by export user objects in pl/sql developer. Now I need to import it to my database. How I can do it with pl/sql developer?
adelak
  • 647
  • 4
  • 11
  • 25
2
votes
6 answers

How to test an Oracle function that contains DML in PLSQL Developer?

Selecting the return value of an Oracle stored function that doesn't contain DML can be done by simply selecting the function: select function_name() from dual; If the function contains DML (in this case some inserts to log the arguments passed to…
James
  • 4,117
  • 2
  • 18
  • 13
2
votes
4 answers

convert a comma separated VARCHAR to be used in an IN clause in PL/SQL?

I have a comma-separated VARCHAR determined dynamically. varchar cHighRank := (1,2,3,4,5,6,7,8) I would like to use this in the following IN Clause, but the system produces an error since an IN clause is only for integers: if (rank in cHighRank)…
user1683987
  • 533
  • 3
  • 7
  • 17
2
votes
3 answers

Description of a Stored Procedure. Listing Arguments

Is there any way of listing down all of the parameters necessary to invoke a stored procedure (with an Oracle DB)? For instance, I have a function called x that someone else has developed and now I have to call it but I don't know which parameters x…
rlc
  • 5,809
  • 5
  • 38
  • 46
2
votes
3 answers

Looping through multiple results in PLSQL

I have a select query which returns 50 results. The select query returns id . The next part i need to run a select query which value for all the 50 ids. Please can some one tell me what is the best way to get it done. is using a for loop a…
Jayant Rao
  • 191
  • 1
  • 5
  • 15
2
votes
2 answers

Can you insert with a mix of of subquery and values?

I have a procedure that is receiving some values from our application, I need to insert these static values and the results of a subquery to one of our tables. Is this possible with one insert statement? So it would look like this Insert into…
Quartzee
  • 25
  • 2
2
votes
3 answers

How to sent email in Oracle PL/SQL package to multiple receivers?

How to sent email in Oracle PL/SQL package to multiple receivers? I have below pl/sql procedure within an oracle package, it works only for one receiver. I need to improve it functional to let it can send email to multiple receivers at same time…
Deep in Development
  • 497
  • 2
  • 8
  • 24
2
votes
1 answer

Spool the data from a CLOB

I have the result of several CLOB, (about 100 Clob). I want to to extract all the data in the CLOB in one one script. I searched for spool but for now I didnt how to use it . Example: select info from ex_employee where data <15 INFO < CLOB > …
Moudiz
  • 7,211
  • 22
  • 78
  • 156
2
votes
2 answers

A query to export the DDL of all the tables in a schema

I have more then 250+ table in my schema, I want to export them as DDL ( create table ...) and send have them in one script . Useally I used the export tool from PLSQL Developer. But I am facing errors like sql export cannot take clob or long raw or…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
2
votes
2 answers

Mysterious change of year from 2050 to 1950

There is something unusual going on. While migration, I have some dates beyond 2050 (for example, 20.05.2050, 21.11, 2051) but for some reason, Oracle changes them to 1950, 1951 etc. Quite annoying if you ask me and it was reported by customer.…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
2
votes
2 answers

PL- SQL recursive function

I am new on PL SQL and I was trying to create a recursive function on it, but I am way too confused with PL SQL terms. I have a table structure like : FFAM_ACC_ID FFAM_UPPER_ACC_ID FFAM_GROUP_FLAG 1 0 …
hsuk
  • 6,770
  • 13
  • 50
  • 80
1 2 3
…
99 100