Skip to main content
Database Administrators

Questions tagged [plsql-developer]

Ask Question

PL/SQL Developer is a development platform targeted at Oracle Database.

41 questions
Newest Active Bountied Unanswered
0 votes
0 answers
83 views

While updating/copying the data from old column to new column we are facing the issue with tablespaces in database. Records count: 158 million+ Using below query to update the records, UPDATE ...
Mujahid Boramani's user avatar
  • 1
0 votes
1 answer
89 views

I have a Stored Procedure that outputs the DDL of another Stored Procedure. I need to execute this DDL dynamically. Meaning, the second Stored Procedure should get created when the first Stored ...
Vincy Wales's user avatar
  • 1
0 votes
1 answer
2k views

we are getting this error when we try to create this scheduler_job but we try to create it give us this error: BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name=>'PROC_TKN_WA_FIX_ARREARS', job_type=...
Daniel Soto's user avatar
  • 3
-1 votes
1 answer
66 views

I want to add number in ip number. for example ip Number = 172.17.14.65 and i want to add one number ,let say 172.17.14.65+1 = output like 172.17.14.66
Ramashish Kumar's user avatar
  • 1
-2 votes
1 answer
1k views

Good afternoon! I am working with Oracle Database (mostly writing queries, stored procedures and creating tables). The problem is that I can not find a modern IDE to work with Oracle such as Visual ...
rsx's user avatar
  • 1
0 votes
0 answers
869 views

When I am trying to execute this trigger getting following error: CREATE OR REPLACE TRIGGER create_table_trigger AFTER CREATE ON SCHEMA DECLARE lv_sql VARCHAR2(5000); obj_name VARCHAR2(...
ashwani Kumar's user avatar
  • 1
0 votes
0 answers
2k views

I trying to create a process in Oracle Apex to update certain columns of a table when a button is pressed which is related to accounting info. Moreover, I would like to validate the existence of ...
DMAS's user avatar
  • 11
-1 votes
1 answer
277 views

I'm spending the last few days trying to learn some tips/tricks on tuning an Oracle query being run in Crystal Report. Obviously it has some performance issues. I suspect there are some deficiencies ...
sydney's user avatar
  • 167
1 vote
0 answers
138 views

I am checking on an performance issue and when I try to execute the time consuming query after turning on the profiler, after like a minute it gives the error "Error stopping profiler" and ...
lse23's user avatar
  • 131
3 votes
1 answer
133 views

There are three tables with the same name Pantea in my recyclebin section of pl-sql developer and I don't know how to find the one that had been dropped the last (I mean the last version of the table)...
Pantea's user avatar
  • 1,502
0 votes
1 answer
103 views

I really like using my PC just by keyboard and any time I have to use a mouse is a real pain for me. I really like 'go to symbol' feature in VS Code or Sublime Text, so I can navigate through any ...
kovalensue's user avatar
  • 33
0 votes
1 answer
1k views

Can we install and run PL/SQL Developer on CentOS 7 server? I couldn't find installation documents anywhere. If the installation is possible can someone guide me on this.
Manoj's user avatar
  • 1
0 votes
1 answer
640 views

I have two schemes with multiple tables. The queries in packages heavily reference schema names. Is it possible to remove schema names from the queries and oracle to identify the tables based on roles ...
Surajkuamr Shinde's user avatar
  • 1
1 vote
1 answer
584 views

I recently installed an Oracle 12c in Oracle Linux 7.6, it was previously in Windows. In the first database restored, some functions are with compilation errors. The query below informs you that ...
Rafael Lima's user avatar
  • 523
1 vote
1 answer
262 views

I'm working with the following script: create or replace PROCEDURE a_proc is vi_get_emails varchar2(500); cursor get_emails is SELECT DISTINCT purchase_authorizer_api.get_userid('30', pagl....
krebshack's user avatar
  • 111

15 30 50 per page
1
2 3