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
6
votes
0 answers

How to show UTF8 character in PL/SQL developer by windows 10?

My problem is that my PL/SQL developer doesn't show UTF8 characters, instead it shows as squares. I changed all "NLS_LANG" variable to 'AMERICAN_AMERICA.UTF8' in registry. I added my language in region&language from control panel of windows. In…
parvij
  • 1,381
  • 3
  • 15
  • 31
6
votes
2 answers

How to pass parameters to sql scripts via command line

There a requirement where I am trying to automate a process in my project where in a sql need to be run for daily reporting. sql looks like below: (This is simplest form but my sql is of 400 lines,below is just an example to get the…
user2075017
  • 457
  • 4
  • 11
  • 23
6
votes
5 answers

How to exit the loop in oracle

Declare var_cnt number(3):=0; begin loop update t_loan_dtl set loan_closure = 'Y' where rownum <10001; end loop; end;
Sundararaj Thathan
  • 81
  • 1
  • 1
  • 4
6
votes
2 answers

How to get Total record count of individual views from all_views

How to get Total record count of individual views from all_views. Please find below code for reference.. Declare view_name VARCHAR2(200); v_str VARCHAR2 (1000); v_output VARCHAR2(4000); CURSOR tbl IS SELECT view_name …
ashwini
  • 75
  • 2
  • 5
6
votes
1 answer

How can I test a function working or not in pl-sql?

I learned the basics of writing a function and procedure in pl-sql but I don't know how to test if it's working , and if not How can I debug it . Any Ideas please . thanks all. Here is the function I'm trying to test it CREATE OR REPLACE FUNCTION…
Lara Dax
  • 131
  • 2
  • 5
  • 10
6
votes
1 answer

Oracle - creating table WITHOUT parallel option

for some reason when I'm trying to CTAS (create table as select) on a large table (40million~ records ) I see in the v$session 18 active sessions with my sql statement. when i'm trying to hint the optimizer to use less CPUs create table table_name…
planben
  • 680
  • 6
  • 20
5
votes
2 answers

How to read string from right PLSQL

In a table column, I have this value: DV-2011-01-000004 (the data type is varchar2) How can i get the part of the string '000004'? In t-sql they have this right() function but in PL SQL i cant'seem to find a function just like the right() in…
FMiS Help Desk
  • 75
  • 1
  • 2
  • 6
5
votes
3 answers

Create table as select statement primary key in oracle

Is it possible to specify which is the primary key on creating table as select statement? My aim is to include the declaration of primary key on the create table not modifying the table after the creation. CREATE TABLE suppliers AS (SELECT…
absolute
  • 63
  • 1
  • 8
5
votes
1 answer

Debugging PL/Python functions

I just practiced some happy engineering and wrote lots of code without testing each step as I usually do. So now I have a few hundred lines of code with an error somewhere... I am using pgAdmin III to write the Python and I write it in their Query…
David
  • 4,786
  • 11
  • 52
  • 80
5
votes
1 answer

PLS-00653 Error on an empty line (Aggregate/table functions are not allowed in PL/SQL scope)

I'm trying to run a PL/SQL Script I made but I'm getting an error: PLS-00653: aggregate/table functions are not allowed in PL/SQL scope The problem here is not the error in itself but the line where it's being thrown from. Here's my PL/SQL block…
Elie G.
  • 1,514
  • 1
  • 22
  • 38
5
votes
1 answer

PLSQL Developer bind variables from GUI like as Oracle SQL Developer

How can I bind variables in PLSQL Developer from GUI like as Oracle PL/SQL Developer? Example: select :variable from dual; Thanks!
Catalin
  • 253
  • 8
  • 21
5
votes
7 answers

formatting PLSQL developer

Is there any shortcut for formatting the query in plsql developer? I want to format below query: SELECT * FROM T1, T2 WHERE T1.ID = T2.ID like: select * from T1, T2 WHERE T1.ID = T2.ID
mohammad_1m2
  • 1,571
  • 5
  • 19
  • 38
5
votes
3 answers

Compare two SELECT statement using PL/SQL Developer

Suppose I have two SELECTquery on same table and I need to compare them column by column. Query 1: select * from mytable t1 where t1.code = '100' returns: id name 1 A 2 B Query 2: select * from mytable t2 where …
user5896972
5
votes
1 answer

Session vs Instance vs Database in Oracle NLS Settings

Why in Oracle there are three logical distinct views for National Language Support ? I can understand the need for distinguishing between session and database - to allow for client custom settings. What about Session versus Instance ? I ran a query…
Veverke
  • 9,208
  • 4
  • 51
  • 95
5
votes
3 answers

Nullable return type in oracle function

Is it possible to return null from an oracle function? I have the following oracle function: create or replace function vta.GetAmount(p_month NUMBER) return number is v_amount number(9); begin select amount into v_amount from salary …
Rene
  • 526
  • 6
  • 18
1 2 3
…
99 100