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

How to read the value from EXCEL/CSV and pass into SQL query and the SQL query output also need to print in EXCEL/CSV

Input Excel/CSV: SQL Query: - select 'WWW' as COLUMN_NAME, (case when to_char (max(WWW)) = to_char(min(WWW)) and to_char(count(WWW)) = count(*) or to_char(max(WWW)) is null then 'same' else 'diff'end)as COMPARISION_VALUE, to_char(max(WWW))as…
Routray
  • 75
  • 1
  • 12
-1
votes
1 answer

How to update table rows with values from a table join in oracle

I need to update a table (table 1) with values obtained from joining table 1 with table 2 I was able to achieve this in SQL Server: UPDATE loanacct_payment_history SET paid_by_cifno=loanacct.cifno FROM loanacct_payment_history INNER JOIN loanacct ON…
sonnyk2016
  • 101
  • 1
  • 8
-1
votes
1 answer

unable to us update inside if condition in oracle SQL developer

I'm creating a variable and checking if the variable matches then update a table but it is not working tried a replacement of insert into instead of update, but update suits my requirement CREATE OR REPLACE PROCEDURE "SP1" AS V1 INT; V2…
Durgaprasad
  • 159
  • 2
  • 9
-1
votes
1 answer

How to create 2 tables using EXECUTE IMMEDIATE only once?

I have a requirement where I need to create 2 tables inside a PLSQL block. Currently we're using EXECUTE IMMEDIATE. Now the issue is I need to create 2 tables but I can use EXECUTE IMMEDIATE only once. Are there ways to create tables within PLSQL…
Gokulnath
  • 49
  • 6
-1
votes
2 answers

tnsnames.ora is way too hard to configure

I have a tnsnames.ora and PL/SQL Developer. I want to make PL/SQL Developer establish a connection based on tnsnames.ora. What I read was that it is expected that tnsnames.ora would be found in $ORACLE_HOME/(...) but I don't have any Oracle product…
Z.Szymon
  • 337
  • 1
  • 13
-1
votes
1 answer

mod() in PL/SQL returns an unexpected value

In PL/SQL, the MOD() returns some unexpected values. MOD(23,2) which is expected to return 1 actually returns 0. MOD(29,2) also returns 0, I think the problem is that it uses the float values. Is there any alternative to MOD()?
Adarsh D
  • 511
  • 6
  • 14
-1
votes
3 answers

Cannot get Canadian postal code to work and Province all caps

I am trying to get my PL/SQL code to run but I keep running into issues. I am trying to get my Canadian postal code to be valid and it keeps giving getting error SQL Error: ORA-02290: check constraint (ORCL2_21.CK_INVESTOR_POSTAL_CODE) violated and…
mike
  • 27
  • 6
-1
votes
1 answer

Sequential Queries in PL/SQL

Bear with me. I'm new at this. So, I have three queries, one after the other, the first two ending with semi-colons. It's the same data from the same tables but sliced three different ways. The 'ORDER-BY's are all the same. The results come out on…
D. Morgan
  • 1
-1
votes
1 answer

How to Optimize PL/SQL code using Bulk collect/FORALL?

pl/sql code taking too much time to remove characters in all tables begin for i in ( select TABLE_NAME,COLUMN_NAME from all_tab_columns where owner='BILL' and data_length > 1 and table_name not like 'SYS_EXPORT_SCHEMA%' and…
Gowtham Pranavesh Naidu
  • 11
  • 4
-1
votes
1 answer

how to insert date column of csv or .txt file in oracle database table?

this command is successfully working but don't know how to insert date in date column if i add date column in table and feed date in my file. any suggestion? DECLARE F UTL_FILE.FILE_TYPE; V_LINE VARCHAR2 (1000); V_EMPNO NUMBER(4); …
D'Mayal
  • 7
  • 1
  • 6
-1
votes
1 answer

is there any special script to insert into Oracle cluster table

How to insert into oracle cluster tables and how to validate data inserted into that two tables correctly or not? if I have two tables amp and dept. these two table is cluster table and share same data blocks. can I insert data into both table by…
Saumya Ranjan
  • 75
  • 1
  • 3
  • 11
-1
votes
1 answer

fast fetching data using table function oracle apex

Is there a way to solve the "ORA-01422 fetch return more than requested number of >rows" without using for loop to return value for table functions?Fetching data using for loop to use that data for oracle application using APEX becomes slower.
Rajkumar Pandi
  • 53
  • 5
-1
votes
3 answers

How to run .sql file using pl*sql developer?

I am trying to connect pl*sql developer tool using Java, where I want to run SQL queries. I know how to run sql queries in Oracle database using Java, but not able to run using pl*sql developer. My Oracle database is installed on another…
Vivek
  • 103
  • 1
  • 7
-1
votes
1 answer

create a sql join with more columns

i want create a sql statemnt (in PL SQL Developer) with a join with comma seperated? SELECT * FROM TABLE1 t1 JOIN TABLE2 t2 ON t1.tab_id, second_id = t2.tab_id, second_id; I always get a ORA-00920 Exception. If i change it to two Rows: t1.tab_id =…
Artist_Styler_57
  • 93
  • 1
  • 8
-1
votes
1 answer

Run a script.sql

When trying to run a @'c:/.../.sql' on sqldeveloper an error occures : impossible to find the path ??
Blue
  • 71
  • 5
1 2 3
…
99 100