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

Using decode in where clause

I have a DECODE in my WHERE clause like this: Where id = decode('&flag','Yes',(Select id from tab where id > 10),0) This code works if the subquery returns one post. If I returns several I get an error like, ORA-01427, "Single-row subquery returns…
Ishamael
  • 51
  • 1
  • 2
  • 9
0
votes
3 answers

PL/SQL Date Insert

I am firing a insert query in 'dd/mm/yyyy' format but it is storing date into MM/DD/YYYY format. I just want to know why it is happening? This is insert query i am using. insert into…
Java_Alert
  • 1,159
  • 6
  • 24
  • 50
0
votes
3 answers

DELETE existing data before insert

I'd like to delete the existing data before insert based on ids. So if there are ids in incoming file then existing ids should be deleted, and then data should be entered. Something like this: DATABASE TABLE…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
1 answer

multiline text in varchar2 field

I have a multiline date, and I'd like to insert it in a table. Then of course, I'd like to retrieve it while preserving the places of cartridge returns. For example. I have data like this in text file ------------------------------- | ID | text …
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
1 answer

Pl/SQL oracle functions

I am tryin to compare last name between SRC and target table, names are same but they might have extra spaces or character, how do i ignore that? Is this the best way to do the comparison …
user803860
  • 299
  • 3
  • 4
  • 13
0
votes
2 answers

SQL Loader like errors in a table

I have external tables. And I'd like to extract the data from those tables and insert/merge that data in other tables. Now when a select from => insert into query or merge query runs then it is possible (and likely possible) that the data might be…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
3 answers

How to improve the performance of my query? / My query is running slow.

workitem_routing_stats table is having around 1000000 records .all records are acceesed thats why we are using full scan hint. it takes around 25 seconds to execute is there is any way to tune this query. SELECT /*+ full(wrs)…
Bhagwat
  • 71
  • 1
  • 1
  • 5
0
votes
2 answers

writing pl/sql output into multiple excel worksheets in one excel

Possible Duplicate: How to export the result into different tabs of Excel in Toad for Data Analyst? I have a pl/sql code where I have two procedures in it (independent of each other) and on executing the procedure I want the output to be written…
user1620464
  • 39
  • 1
  • 2
  • 11
0
votes
2 answers

ORA-30926: unable to get stable set of rows in the source table

I'd like to insert the data after unpivoting it. The statement needs to be a merge statemenet. However, I am getting ora-30926 error, and I can't really figure out how to solve it. Here the data…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
1 answer

listagg function is failing

I am trying to use listagg as listagg(select...) way but I guess that it is not possible in the way I would like to say. I have a table of degrees. Degree table: ----------------------------------------------- | user_id | degree_fi | degree_en |…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
2 answers

If no data then don't create empty file

I would like to check if there's no data coming from SQL query then file should not be created. Here is my code: CREATE OR REPLACE PROCEDURE VR_AD_INTEGRATION_EXPORT AS l_v_file UTL_FILE.file_type BEGIN l_v_file :=…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
1 answer

dumping non transfered data in a positional file

I'd like to write the data in a positional file. Only data which was not written before in a file will be written. Obviously, there's a column in the table to determine if the data has been written before. In my case, say if the lenght of field is…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
2 answers

PLSQL stored procedure returns no values in Entity Framework

I have a working plsql oracle stored procedure (i have tested it in plsql and it return the correct value(s)): PROCEDURE FetchCode(code OUT NUMBER) IS BEGIN SELECT MYSEQ.NEXTVAL INTO code FROM DUAL; END FetchCode; and a visual…
CodeCheshire
  • 710
  • 1
  • 8
  • 27
0
votes
1 answer

combining two colums in one column

I have a very unusual task, and the more I think the more I prone to go postal. Data looks like this: ----------------------------------------------------------------------------------------- | user_id | prof_org_id | prof_org_fi | prof_org_pos_fi |…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
2 answers

Creating and calling PL/SQL functions

I'm new to PL/SQL. It's been on fine until now that is. I've the query this query which works fine. declare rec employees_practice%rowtype; sam taxObligations%rowtype; socialsecurity number; rentallowance number; transportation…
Kofi Addo
  • 1
1 2 3
…
99 100