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
3
votes
3 answers

Variable in UPDATE oracle in procedure : invalid identifier

I don't understand why service is complaining with Fehler(36,11): PL/SQL: ORA-00904: "FOUND_VP": invalid identifier Variable is declared in the first begin... Is it not possible to use variable directly in queries ? when trying store following…
OpenStove
  • 714
  • 1
  • 11
  • 22
3
votes
1 answer

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: DECLARE clob_rec CLOB; n_rec NUMBER:=100; BEGIN SELECT LOB INTO clob_rec FROM table1 WHERE ID = 1234; n_rec :=…
DaveQuinn
  • 189
  • 1
  • 6
  • 19
3
votes
1 answer

PL/SQL report file automatically run and export result?

I am using PL/SQL developer. I have a report file (.rep) that fetches some data based on time period, for ex. from 1st July 2012 to 2th July 2012. I use this report by running it, entering &date_from and &date_to, and then export it in HTML via…
kaytrance
  • 2,657
  • 4
  • 30
  • 49
3
votes
3 answers

all row values in one column

I would like to display all values in one column. How may I do so? Data looks like this: ----------------------------------------------- | user_id | degree_fi | degree_en | degree_sv | ----------------------------------------------- | 3601464 | 3700…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
3
votes
3 answers

Using Case When Statement For Updating from Two Tables

Is it possible to update a column of a table from two optional tables, in Oracle. I mean, there are 2 tables whose columns are exactly same and, according to input Id, I want to update related table. For eg. UPDATE CASE WHEN EXISTS ( SELECT A.ID…
enginbilici
  • 189
  • 3
  • 16
2
votes
1 answer

Oracle 11g procedure error with ftp packages

I have met a problem with my database (version is Oracle 11g). What did I want to do? i want to use procedures to upload a file to the ftp server. How did i do? first , i have download the ftp.pks and ftp.pkb files and I use @**.pks to import…
Tony
  • 398
  • 2
  • 11
2
votes
2 answers

diff local package with database package

I need somehow compare local version of pl sql package with the one that is stored in database. Are there any "easy" way to do it? Currently I download package from database, save it in some file and perform diff using some diff tool. That is a bit…
michael nesterenko
  • 14,222
  • 25
  • 114
  • 182
2
votes
1 answer

PL/SQL identifier 'string' must be declared

Can anyone tell me why this won't execute? set serveroutput on ; Declare TYPE type_emp IS RECORD( emp_name employees.last_name%TYPE, emp_salary employees.salary%TYPE); rec_emp type_emp; due_for_a_raise CHAR(1); begin …
atrueresistance
  • 1,358
  • 5
  • 26
  • 48
2
votes
0 answers

SQL*NET not properly installed

I am new to Oracle, I am starting to work on my first project. I have installed Oracle Client ora11 and pl/sql. I have set tns names files under network/admin(tns names file is ok, I copied it from a colleague). Whwn I start pl/sql I got…
Avrum
  • 269
  • 2
  • 8
  • 16
2
votes
1 answer

How to insert data into NVARCHAR2 field with plsql developer?

Oracle version: 11gr2, NLS_CHARACTERSET: WE8MSWIN1252, NLS_NCHAR_CHARACTERSET: AL16UTF16, client NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252, PL/SQL Developer version: 8.0 I have a table which has a NVARCHAR2 field, I try to execute INSERT statement in…
gfytd
  • 1,747
  • 2
  • 24
  • 47
2
votes
3 answers

PL/SQL Developer: How to find variable references?

In a Oracle package, How can I find out all the references for a variable? Like you would do it in Eclipse or Visual Studio. Is this feature supported in any Oracle IDEs like TOAD, Sql Developer or PL/SQL Developer? I am using PL/Sql developer?
iraSenthil
  • 11,307
  • 6
  • 39
  • 49
2
votes
3 answers

CASE WHEN EXISTS in WHERE clause

I want to print all employee names and also if the employee is present in a table. EMP_ID ENAME 1 ALLEN 2 MAX 3 BEN EMP_ID EC_CODE 1 CONFIG_1 2 CONFIG_2 3 CONFIG_1 Query: SELECT ename, (CASE WHEN…
smriti
  • 23
  • 4
2
votes
1 answer

Transferring data to a test table

There is a table contact_history with 1.244.000.000 number of data (from 04.03.22-05.06.2022) and with fields contact_dt and contact_dttm. I tried to transfer all the data to test using contact_dt with script: **DECLARE dat date; begin dat:=…
Andrey Romanov
  • 79
  • 1
  • 7
2
votes
1 answer

How to jump between bookmarks in PL/SQL Developer

I'm analysing a package that's quite big and as I'm going down, I've selected a few lines that I deem important, every time I click on the line number, PL/SQL Developer marks the line with a blue number starting from zero as the image show. I know…
Leonardo Vecchi
  • 23
  • 3
2
votes
1 answer

How do I set the default directory that the PL/SQL Developer Command Window opens in?

I'm trying to run a script in a sql file in PL/SQL Developer. I open a command window and I find myself not in the directory where the sql script is. I encounter a couple issues when trying to navigate to the directory: cd into the directory…
gib65
  • 1,709
  • 3
  • 24
  • 58
1 2 3
…
99 100