plsql-developer Archives

PLS-00306 dbms_scheduler.create_job

By adminPosted on May 17, 2023

Question : I’m not an expert about DBMS_SCHEDULER.CREATE_JOB and i’ve been asked to create a job. When i run it […]

By adminPosted on March 4, 2023

Question : I have two schemes with multiple tables. The queries in packages heavily reference schema names. Is it possible […]

By adminPosted on November 16, 2022

Question : First i connect to oracle remotely, then open pl/sqldeveloper create one table. Then i am trying to import […]

By adminPosted on August 20, 2022

Question : In the below code (that I’ve inherited), I’m getting the message “SQL80001 – incorrect syntax near ‘)’”, the […]

By adminPosted on May 21, 2022

Question : I want to write PL/SQL Procedure that updates salary which is less than 2000. I wrote this procedure.And […]

By adminPosted on January 31, 2022

Question : When I run first query in PL/SQL Developer I got the error: Dynamic Performance Tables not accessible, Automatic […]

By adminPosted on October 17, 2021

Question : In the below code (that I’ve inherited), I’m getting the message “SQL80001 – incorrect syntax near ‘)’”, the […]

By adminPosted on September 25, 2021

Question : Sorry for this absolute oracle noob question: I am in an environment that uses integrated / active directory […]

By adminPosted on July 12, 2021

Question : I try to learn PL/SQL for loops in tutorials. I learn flow of control in a for loops. […]

By adminPosted on May 10, 2020

Question : Table1 Name CITY RANK Manish New delhi A Akash New delhi A Akash Aligarh B Vinay Barh C […]