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

Why is Oracle eating my string?

i currently try to execute the following query on an Oracle DB select tzname || ' (UTC'|| tz_offset(tzname) || ')' from v$timezone_names It not seems to be very complicated. Just the name of the timzone and the UTC offset in braces. But when i…
Marcel
  • 123
  • 6
8
votes
6 answers

Why do I get an open transaction when just selecting from a database View?

If I execute a simple select statement in pl/sql developer against a database table, I get a standard set of results back as I would expect. Recently, I pasted a query from a stored procedure that happened to select from a view, and noticed that a…
James Wiseman
  • 29,946
  • 17
  • 95
  • 158
8
votes
1 answer

Skipping data fields while loading delimited data using SQLLDR

Consider below scenario: Table T1 (f1, f2, f3); Data files: a|b|c|d w|x|y|z I want to load this data skipping the second field as follow: f1 f2 f3 --- --- --- a d c w z y Would really appreciate your help or any…
Vinod Yadav
  • 359
  • 1
  • 5
  • 13
8
votes
2 answers

PL SQL Auto Commit on execution

I am very new to the PL/SQL programming. I tried to write a pl/sql procedure with some DML Statements(insert) inside the code. I am not doing any explicit commit after performing insert operations in the pl/sql code. But the transaction is getting…
Mohan
  • 463
  • 3
  • 11
  • 24
8
votes
3 answers

Unable to log-in using PL/SQL Developer

I have problem with logging into my database using Pl/SQL Developer. All connection parameters are defined in TNSNAMES.ORA and work perfectly with SQL Developer. Unfortunately, when I try to connect using PL/SQL Developer, I am receiving a message…
user1904098
8
votes
2 answers

how to get count(*) value in local temp variable in dynamic sql (ORACLE PLSQL)

I want to get count(*) value in dynamic plsql statement. We can write static stmt as: select count(*) into tmp_cnt from table_info where nbr_entry='0123456789'; but how to get tmp_cnt value while writing the dynamic sql stament? or any other way to…
Vijay Kolte
  • 83
  • 1
  • 1
  • 3
7
votes
2 answers

What does "/" do in PL/SQL?

I reviewing some PL/SQL code and I came across the following in the scripts: / SHOW error grant execute on someName1 to someName2; / SHOW error Reviewing the documentation for PL/SQL I could not find an explanation what the /'s do. Can anyone…
TERACytE
  • 7,553
  • 13
  • 75
  • 111
7
votes
2 answers

How to check the timezone of oracle pl/sql developer

Where do I check the timezone of oracle pl/sql developer.Can someone help please
sith
  • 335
  • 2
  • 3
  • 9
7
votes
2 answers

update using for loop in plsql

i'm having problem updating and insert into below column. Please advise on this. This is the input depnto extra comm ---------------------------- 20 300 NULL 20 300 400 20 NULL NULL 20 500 NULL This…
user2686661
  • 95
  • 1
  • 2
  • 9
7
votes
12 answers

ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer)

I need to use PLSQL Developer to access oracle databases. I get the following error when I try to connect to my database. ORA-12154: TNS:could not resolve the connect identifier specified. I am able to use SQLPLUS from the command line to connect to…
ZakTaccardi
  • 12,212
  • 15
  • 59
  • 107
6
votes
2 answers

When debugging a package procedure in PL/SQL developer, how do you set a CLOB in parameter value?

I'm debugging an Oracle package using PL/SQL developer, but I'm running into a problem - one of the parameters is a CLOB (it's a big ass XML string). I can pass it in from the application side and have it be a CLOB, but in the PL/SQL debugger, I put…
aape
  • 475
  • 1
  • 8
  • 24
6
votes
2 answers

PL/SQL developer import dump

I have a dump file which includes two tables. Now I need to import this dump file. I was instructed to create two tablespaces beforehands.Now how do I import this dump file to these tablespaces. I'm using PL/SQL developer.
Mikayil Abdullayev
  • 12,117
  • 26
  • 122
  • 206
6
votes
2 answers

Oracle - export results to excel with headers/columns more than 30 characters

I can export a Oracle (12.1) SQL results to excel using PL/SQL developer But sometimes the requirements are to give a meaningful name for the column/header for example "total amount for previous 21 days" Obviously, it exceed 30 characters and gets…
Ori Marko
  • 56,308
  • 23
  • 131
  • 233
6
votes
2 answers

Decrypting Stored Password on PL/SQL Developer

When you save connection details on All Around Automation's PL/SQL Developer, the password is encrypted as follows: DisplayName=Oracle…
Hambone
  • 15,600
  • 8
  • 46
  • 69
6
votes
2 answers

PLSQL read value from XML?

I have a string with XML code, I want to extract a value from it in PL/SQL to a variable. The XML is very simple and will not be different than this: …
Data-Base
  • 8,418
  • 36
  • 74
  • 98
1 2
3
…
99 100