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.

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 or privileges?? Query - Select * from schema1.app_table1 ap1 inner join schema2.app_table2 ap2 The query would be run from oracle user app_user who has access to both the tables - app_table1 and app_table2. It is possible to run the query without schema prefixes or synonyms just by modifying the user app_user. Thanks for your help.

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 TABLE_NAME SET NEW_COLUMN = OLD_COLUMN: I updated the tablespace for the 3 times, but issue is not resolve.

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 Procedure is executed. Here's the pseudocode for P_GEN: CREATE OR REPLACE PROCEDURE P_GEN AS c1 SYS_REFCURSOR; stmt varchar2(4000); BEGIN open c1 for SELECT TXT FROM ( SELECT 'CREATE OR REPLACE PROCEDURE P_DEL' .... TXT FROM TBL ) ; DBMS_SQL.RETURN_RESULT(c1); END; / P_DEL, when created, would have the following code: CREATE OR REPLACE PROCEDURE P_DEL AS BEGIN DEL('TEMP1'); DEL('TEMP2'); DEL('TEMP3'); END; / I need P_DEL to be created when P_GEN is executed. How to accomplish this?

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=>'STORED_PROCEDURE',
   ownname=>'BUSINESSDATA_ARGENTINA' ,
   job_action=>'BEGIN BUSINESSDATA_ARGENTINA.PROC_TKN_WA_FIX_ARREARS; END;',
   start_date=> SYSTIMESTAMP,
   repeat_interval=>'FREQ=DAILY;BYHOUR=11',
   comments=>'Proc diario 11am'
);
END;
/

ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00306: wrong number or types of arguments in call to 'CREATE_JOB'
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

Any ideas what are we doing wrong??

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

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 Studio Code (I want to have code autocompletion option, automatical code checking, useful code color schemes etc as VScode does). So far I have tried: * PL/SQL Developer - good one, but code assistance is awful. * SQL Developer - not so much difference with PL/SQL Developer. * DBeaver - the same story. * JetBrains DataGrip: I can not use it due to corporate restrictions. * Oracle and PL/SQL add-on for Visual Studio Code: nice one, but exxtremely slow (simple `select * from table` execution takes 20-30 seconds here and less than 1 second in PL/SQL Developer). So I am looking for something like DataGrip or Visual Studio Code add-on for Oracle and PL/SQL. I understand that my question is off-topic, but I really do not know where else I can ask such a question (if you could provide me such a source, I would be very grateful). I am working on Windows, no Powershell. Any help appreciated.

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(500);
BEGIN
    obj_name := sys.dictionary_obj_name;
    lv_sql := 'EXEC SYS.DBMS_FGA.add_policy (object_schema     => ''AIM_DBA'',object_name => '''|| obj_name|| ''',policy_name => ''PROTECT_'|| obj_name || ''',audit_condition  => null,audit_column => NULL,handler_schema => ''AIM_DBA'',handler_module =>''WHERE_CLAUSE_PROTECTOR_PKG.TABLE_PROTECTOR'',enable => TRUE,statement_types => ''UPDATE,DELETE'')';
    IF
        sys.dictionary_obj_type = 'TABLE'
    THEN
        dbms_output.put_line(obj_name);
        dbms_output.put_line(lv_sql);
        EXECUTE IMMEDIATE lv_sql;
        dbms_output.put_line(lv_sql);
    END IF;

END;
/

Execution error Message:

SQL> create table aim_dba.WHERE_TST27
(
    dummy varchar2(20)
);  2    3    4
WHERE_TST27
EXEC SYS.DBMS_FGA.add_policy (object_schema     => 'AIM_DBA',object_name => 'WHERE_TST27',policy_name => 'PROTECT_WHERE_TST27',audit_condition  => null,audit_column => NULL,handler_schema =>
'AIM_DBA',handler_module =>'WHERE_CLAUSE_PROTECTOR_PKG.TABLE_PROTECTOR',enable => TRUE,statement_types => 'UPDATE,DELETE')
create table aim_dba.WHERE_TST27
*
ERROR at line 1:
ORA-04088: error during execution of trigger 'AIM_DBA.CREATE_TABLE_TRIGGER'
ORA-00604: error occurred at recursive SQL level 1
ORA-00900: invalid SQL statement
ORA-06512: at line 17*

Purpose of Trigger: Whenever new object create Audit policy would get enabled for that object with this trigger.

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 certain columns from another table. I have created a small procedure to test the this update process but it running for more than ten minutes and it is not updating the records. I have tried a for loop with a select statement inside and with cursor as well. Both are not working The snippet below is using a cursor. I am not sure why its running for a long time since there exists about a little more than 1K records that will get updated. Please let me know what I could be doing wrong. Thank you in advance. DECLARE VAR1 DATE := TO_DATE('11/15/2019', 'MM/DD/YYYY'); VAR2 VARCHAR2(25) := '0000809349'; VAR3 NUMBER := 2017; VAR4 NUMBER := 4; VAR5 DATE := TO_DATE('11/18/2019', 'MM/DD/YYYY'); CURSOR TEST1 IS SELECT PD, JI, FY, AP, DPD FROM MFT WHERE RSN = 9097 FOR UPDATE; BEGIN FOR i IN TEST1 LOOP UPDATE MFT SET PD = VAR1, JI = VAR2, FY = VAR3, AP = VAR4, DPD = VAR5 WHERE RSN = 9097 AND VAR1 IN (SELECT PAYMENT_DATE FROM MEC WHERE PAYMENT_DATE = VAR1) AND VAR2 IN (SELECT JI FROM CGL WHERE JI = VAR2) AND VAR3 IN (SELECT FY FROM CGL WHERE FY = VAR3) AND VAR4 IN (SELECT AP FROM CGL WHERE AP = VAR4) AND VAR5 IN (SELECT DPD FROM CGL WHERE DPD = VAR5) AND PD = TO_DATE('06/09/2017', 'MM/DD/YYYY') AND JI = '0000911979' AND FY = 2017 AND AP = 12 AND DPD = TO_DATE('06/09/2017', 'MM/DD/YYYY'); END LOOP; COMMIT; END;

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 on both ends. The database is what I want to focus on. So I ran the query and isolated the SQL ID. I ran this to produce the execution plan with "+outline".

SELECT ROWNUM, T.* FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(
sql_id => 'fg3afzk411qw2',
CURSOR_CHILD_NO => 0,
FORMAT => 'ALLSTATS LAST +cost +bytes +outline')) T;

I replaced the actual table names with names like TABLE_A, TABLE_B and this is the LEADING row from the execution plan. >LEADING(@"SEL$6B71E5ED" "TABLE_A"@"SEL$14" "TABLE_B"@"SEL$16" "TABLE_C"@"SEL$1" "TABLE_D"@"SEL$21") Here are my questions: - Does it mean TABLE_A contain the least amount of rows? - Can the above join order be interpreted as something like this?

TABLE_A LEFT JOIN TABLE_B -> resultset TABLE_AB
     TABLE_AB LEFT JOIN TABLE_C -> resultset TABLE_ABC
     TABLE_ABC LEFT JOIN TABLE_D

There are more tables in the actual execution plan. I simplified just to get my questions posted. Here's the actual execution plan with table names altered. TABLE_D appears 4x and it's the same table because it's being aliased 4x by the query. Same with TABLE_E.

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 no data is available in the profiler report. Could someone tell how to fix this issue? Thanks in advance.

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). I can not restore all of them cause there can not be tables with the same name in tables section and I can not see the properties of the tables in recyclebin either . What is the best way to find the latest version of a table in recyclebin? Important thing is that think about a situation in which the table has nearly more than 300 columns and it's not a good solution to restore the tables one by one to check whether it's the latest one . I want to know if there is a solution that for one hundred percent returns the latest version of the table from the recyclebin. Thanks in advance

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 source code with ease. Is there anything that would bring this feature also into PL/SQL Developer, so I would be able to easily navigate through my PL/SQL packages?

I want to run this SQL in Oracle 11g: declare a number; begin select count(*) into a from item w where w.Item_num='MOH601' ; dbms_output.put_line(a); end ; How to run this query with isolation Serializable? As I have learnt before, Oracle will lock the rows with w.Item_num='MOH601' when using Serializable.

Code: execute x.procedurename(row.accc_no, row.bill_no, 0, null, row.total_balance, 'A',assgn_scen_site_cv, :assgn_scen_site_cv); Its my procedure. How to get return value from this proc and assign it to variable ?

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 there is a syntax error on line 2, but I can not figure out where the problem is. **Error:** Error (2.17): PLS-00201: The identifier 'DAYS_INTERVAL_TABLE' must be declared **Query:** create or replace FUNCTION funRetornaDias (p_inicio date, p_termino date) RETURN DAYS_INTERVAL_TABLE PIPELINED IS v_date date; out_rec DAYS_INTERVAL := DAYS_INTERVAL(NULL,NULL); v_ref date; BEGIN if p_inicio > p_termino then v_ref := p_inicio; v_date := p_termino; else v_ref := p_termino; v_date := p_inicio; end if; while cast(to_char(v_date, 'YYYYMMDD') as number) <= cast(to_char(v_ref, 'YYYYMMDD') as number) loop begin out_rec.date_ := v_date; out_rec.day_of_week := datepart('DW', v_date); PIPE ROW(out_rec); v_date := v_date + interval '1' day; end; end loop; RETURN; END;

First i connect to oracle remotely, then open pl/sqldeveloper create one table. Then i am trying to import csv file to PL/sql developer. Importing process starts normally, but every day midnight we face > ORA-03135 connection lost contact. The file is almost 3 GB containing 20 million records. the importing process stop after 10 million records.

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.authorize_id) FROM purch_authorize_group_line pagl join purchase_authorizer pa ON pagl.authorize_id = pa.authorize_id WHERE pagl.authorize_group_id = '30-PM-COM' AND pa.notify_user = 'TRUE'; BEGIN OPEN get_emails; FETCH get_emails INTO vi_get_emails; CLOSE get_emails; FOR rec_ IN vi_get_emails LOOP command_sys.mail(from_user_name_ => 'IFSAPP', to_user_name_ => vi_get_emails, subject_ => 'Test subject', text_ => 'Test message body'); END LOOP; END a_proc; This part of my script returns two values: SELECT DISTINCT purchase_authorizer_api.get_userid('30', pagl.authorize_id) FROM purch_authorize_group_line pagl join purchase_authorizer pa ON pagl.authorize_id = pa.authorize_id WHERE pagl.authorize_group_id = '30-PM-COM' AND pa.notify_user = 'TRUE'; Let's call these values Bob and Bill. I would like the second part of my script to email both Bob and Bill. However, it's only emailing Bob since Bob is the first record returned by my query. It's not emailing the two users. It's only emailing the first user returned by the query.

I'm going to wrap my source of database logon trigger. i run the command, "wrap iname='E:\block_tools_trigger_HR.sql' oname='E:\block_tools_trigger_HR.plb'". plb file created without any error but code not encrypted. Source code of trigger is given blow: CREATE OR REPLACE TRIGGER block_tools_trigger_HR AFTER LOGON ON HRMS.SCHEMA DECLARE v_prog sys.v_$session.program%TYPE; BEGIN SELECT upper(program) INTO v_prog FROM sys.v_$session WHERE audsid = USERENV('SESSIONID') AND audsid != 0 AND ROWNUM = 1; IF UPPER(USERENV('TERMINAL')) NOT IN ('MOAZZAM-LT') THEN IF UPPER(v_prog) LIKE '%TOAD%' OR UPPER(v_prog) LIKE '%T.O.A.D%' OR --OR — Toad UPPER(v_prog) LIKE '%SQLNAV%' OR -- — SQL Navigator UPPER(v_prog) LIKE '%PLSQLDEV%' OR --— PLSQL Developer UPPER(v_prog) LIKE '%BUSOBJ%' OR -- — Business Objects UPPER(v_prog) LIKE '%EXCEL%' OR -- — MS-Excel plug-in UPPER(v_prog) LIKE '%SQLPLUS%' OR -- — SQLPLUS UPPER(v_prog) LIKE '%FRMBLD%' OR UPPER(v_prog) LIKE '%IFBLD60%' or upper(v_prog) is null THEN RAISE_APPLICATION_ERROR(-20983, 'You are not allowed to login in '||v_prog); END IF; END IF; END;

In the below code (that I've inherited), I'm getting the message "SQL80001 - incorrect syntax near ')'", the error being on the third line from the bottom with the + sign. I've looked at THIS SO answer to similar issues, but that wasn't the issue here. select b.batch_id, b.submitted_dt, b.batch_nm, b.paused_cd, b.job_cnt, b.start_dt, b.finish_dt, m.module_nm, m.module_id, mc.hostname from tbl_bat_chess b, tbl_job_bobs j, tbl_man_holes m, tbl_monkey_cokes mc where b.finish_dt is null and to_char(b.submitted_dt, 'DD-MON-YYYY') = to_char(sysdate, 'DD-MON-YYYY') and (to_number(sysdate - b.submitted_dt) * 1440) > 5 -- 5 minutes and b.batch_id = j.batch_id and b.batch_nm like '%EXAMPLE%' and j.module_id = m.module_id and m.proc_group_id not in (10, 18) and j.machine_id = mc.machine_id (+) group by b.batch_id, b.submitted_dt, b.batch_nm, b.paused_cd, b.job_cnt, b.start_dt, b.finish_dt, m.module_nm, m.module_id, mc.hostname order by submitted_dt desc **DBMS:** PLSQL Developer 10.05. **Oracle Version:** 11g I've manually removed all non-breaking spaces and tried putting square brackets around the line mc.machine_id with no success. How should this be resolved?