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
-1
votes
1 answer

How long expired (grace) status will exist?

How long expired(grace) status will exist before the actual expiration of user in Oracle? How to find the actual expiry date when a user is in expired(grace) status? I have tried using dba_users table but in the table expiry date is null for users…
Ananthu rajeev
  • 21
  • 3
-1
votes
1 answer

Unable to upload file as blob to table using Oracle APEX

I have a application built using Oracle APEX 20.x. The issue is need to programmatically upload the (.pdf,.txt,.png,.jpeg,.jpg) as a BLOB to table I heard about the APEX_APPLICATION_TEMP_FILES. How to utilize this table to upload my file as BLOB to…
yyy62103
  • 81
  • 5
-1
votes
2 answers

sir give me Q. "Write a procedure named expensive_books which finds the details of books with a price is more than the average price in pl/sql"

I tried a lot but i can't get answer I write this program and I also write "set serveroutput on;" but this is not showing output this is table and this is code declare name book.book_title%type; price book.book_price%type; p…
YASH BHAVSAR
  • 1
  • 2
-1
votes
1 answer

Trying to create a DML file of the owner inserts Oracle

I am trying to create a DML file that contains all the inserts to a database using only a script and asking only for the owner name, I found some documentation about the creation of files in Oracle and some other about how to get the insert…
Alexander García
  • 139
  • 7
-1
votes
1 answer

The product of col1 and col2 directly saves values in table 2

table1 has 2 columns and i want to store the product values of column 1 and column 2 values from table 1 to table 2. (the product of col 1 and col 2 directly saves values in table 2) I'M THINKING TO ADD ONE MORE COLUMN IN TABLE 1 AND PASTE THE…
Shree Kushte
  • 1
-1
votes
2 answers

How to use Substitution in Stored Procedure

Actually I am creating stored procedure with substitution, while trying to compile the procedure, I get the popup to enter the substitution values in compiling itself, Instead of getting popup while execution. Please share me your idea to compile…
Caroline
  • 1
-1
votes
2 answers

Create Fucntion returning Table in pl/sql

TEMP table: Node Curr_Cnt Prev_Cnt Diff First 20 40 20 Second 30 70 40 CREATE OR REPLACE FUNCTION NEW_FUNCTION RETURNS table IS c_rec TEMP%ROWTYPE; TYPE c_tab IS TABLE OF c_rec%TYPE INDEX BY PLS_INTEGER; l_c_tab…
NAMAN GUPTA
  • 71
  • 2
  • 12
-1
votes
2 answers

How to rewrite this procedure by using joins?

CREATE OR REPLACE PROCEDURE sample IS l_sum_1 NUMBER; l_sum_2 NUMBER; l_res NUMBER; BEGIN SELECT SUM (c1) + SUM (c2) + SUM (c3) + SUM (c4) + SUM (c5) + SUM (c6) + SUM (c7) + SUM (c8) + SUM (c9) …
vanathy srilakshmi
  • 1
-1
votes
1 answer

Error(8,1): PLS-00103: Encountered the symbol "SET"

I'm trying to create a function using oracle, it should be working fine but i keep getting the following error: Error(8,1): PLS-00103: Encountered the symbol "SET" here is my Function: CREATE OR REPLACE FUNCTION CountViewers(nameofPlay…
odaiwa
  • 315
  • 2
  • 14
-1
votes
1 answer

Reg: procedure is giving erro

Below is my procedure giving error below, kindly check and confirm. create or replace PROCEDURE CLEANUP_rec IS BEGIN EXECUTE IMMEDIATE 'create table TEMP_JOB_ID_FROM_JOB_DOC_1119 as select JOB_ID, last_update_time_utc, status from J_DOC where…
singh_dba
  • 31
  • 4
-1
votes
1 answer

case in where clause for specific values oracle

we have 2 table, table A and table B, we are fetch 6 columns in select statement, these are the columns A.current_value, A.original_value, A.current_tax_lot, B.current_tax, B.cost_tax, B.current_tax_cost now we have to put mathematics condition in…
Tulsi Thakur
  • 13
  • 5
-1
votes
2 answers

PLS-00306: wrong number or types of arguments in call to procedure PROC_T

declare TYPE stag_tab IS TABLE OF d_staging%ROWTYPE; stag_tab1 stag_tab; begin --Bulk Collect select * bulk collect into staging_tab1 from d_staging; PKG_T.PROC_T(stag_tab1); end; / Package definition: --Package CREATE OR…
Vikash Kumar Sharma
  • 21
  • 8
-1
votes
2 answers

PL/SQL Block to show the table details

I am new to PL/SQL and I need your help.. I was created student table named(students) and inserted 10 rows successfully. I need to create a block when the user enter the student ID should be show the all details which match with the entered…
Shrooq Awadh
  • 11
  • 1
-1
votes
1 answer

is there a better way to write avg procedure?

I wrote this procedure but it keeps showing "WARNING: Procedure creates with compilation errors" and I don't know why, here's the table I created create table EnrolledInClasses ( St_Id char(9) primary key, C_Id char(6), GradeN…
Reem Sultan
  • 1
-1
votes
2 answers

PL/SQL anonymous block completed" with no result displayed

When I executed the code below i got the message "anonymous block completed" without any results back. Can anyone help me out? BEGIN FOR r IN (SELECT DBMS_METADATA.GET_DDL (object_type => 'VIEW', name => view_name, schema => USER) AS view_text …
cesarvizo
  • 59
  • 8
1 2 3
…
99 100