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
2 answers

sql query to reduce amount of data

I am a new oracle developer and I have no clue how to do it: so I need to create a query in oracle that reduce the amount of my returned data what I have is 2 records for the same purpose In the first record I have id1 = A and id2 = B and in the…
Neeldz
  • 131
  • 2
  • 13
-1
votes
2 answers

I create one PL/SQL procedure i want simple show two messages?

The PL/SQL procedure below: 'DECLARE V_EMPNO NUMBER(10):=&EMPNO; V_EMPNO2 NUMBER(10):= 0; CURSOR C1 IS SELECT EMPNO FROM EMP; BEGIN FOR I IN C1 LOOP FETCH C1 INTO V_EMPNO2; EXIT WHEN C1%FOUND; END LOOP; IF (LENGTH(V_EMPNO)) > 4…
Muhammad Umair
  • 3
  • 1
-1
votes
1 answer

Cursor for For Loop

How do I combine these 2 example cursors below so that they retrieve data for all 4 conditions: all, candy, cake, popcorn; in a for loop? I have 3 session/global variables that can be empty string s_Candy Varchar2(5); s_Cake …
user6569270
-1
votes
1 answer

error in pl/sql package body

I am having this error: Error(42,22): PLS-00103: Encountered the symbol ")" when expecting one of the following: current I have written a package with few functions and procedures. here is my package: -- specification -- CREATE OR…
swayam
  • 1
  • 1
-1
votes
1 answer

How to parse(append) value to existing xml file in oracle?

How to parse(append) value to existing xml file in oracle??? (I have standard fields in my xml file, i want to change that field value dynamically from oracle database). Thank you.
Vinayak Bhat
  • 3
  • 1
-1
votes
2 answers

update the salary base on onther table

I have two tables first one is emp(emp_id,name,gender--M or F) and second one is emp_sal(emp_id,address,salary).I want to update salary filed like female employee should be increment 10% and male employee should be increment 15% of current salary
Rajeev Singh
  • 31
  • 5
-1
votes
1 answer

oracle sql statement to get counts with pivot, group by or windowing? oracle 11g

Is it possible to and can someone please give me a good example of selecting in one query a result set that returns counts for demographics or other things group by a certain grouping? That really sound cryptic so I am going to add an example output…
user1417467
  • 75
  • 1
  • 6
-1
votes
1 answer

How to write this query in PL/SQL?

How do I write this? DECLARE STARTDATE DATE; ENDDATE DATE; BEGIN STARTDATE='&&STRTDTE'; ENDDATE='&&ENDATE'; ... ... WHERE AAA_BBB.TR_DATE BETWEEN 'STARTDATE' AND 'ENDDATE';
kareem elwakil
  • 1
-1
votes
1 answer

PL/SQL procedure sending email with variables

I've written a procedure in oracle that will send an email. I would like to include variables in the body of the message that should refer to the variables calculated in another procedure. As an example let's say I have procedure: select…
Janna Sherazi
  • 167
  • 1
  • 1
  • 15
-1
votes
2 answers

How to read & write without using temp tables

I have a procedure where it has few select statements (from different tables) and the output of these select statements will be loaded into a temp table. All the records which are loaded in this temp table will be displayed as an output. Now I have…
Siddharth
  • 21
  • 4
-1
votes
1 answer

While creating this java program in oracle db. Im facing some errors. CAn anyone tell me the way to compile it. the code is as follows

Below code is working properly in eclipse. But I,m trying to create this source in oracle 11g Db. While creating it throws some warnings. create or replace and compile java source named "Noitime" as package com; import java.io.IOException; import…
Gobikkannan
  • 11
-1
votes
2 answers

I am trying to write a program for Armstrong number in PL/SQL.Can anyone tell me where i am wrong?

while N !=0 LOOP R:=MOD(N,10); R1:=power(R,3); A:=A+R1; N:=TRUNC(N/10); END LOOP; After this it comes IF N=A THEN SYS.DBMS_OUTPUT.PUT_LINE(' number is armstrong '); ELSE SYS.DBMS_OUTPUT.PUT_LINE(' number is not an armstrong ');
Sean T
  • 51
  • 1
  • 7
-1
votes
1 answer

How to return varchar input in reverse by using funtion

I have a interview question to write a function which takes input as varchar and the output should give in reverse order of input. This is the code I wrote ` SQL> create or replace function fn( id in varchar2) return varchar2 is 2 input…
siva krishna
  • 122
  • 8
-1
votes
2 answers

Count distinct does not work in Oracle SQL Developer

I need to count distinct date in one column but I do not want to group by that. Datasource table: ID zip5 date volume 11 11111 01/03/16 5 12 11111 01/03/16 6 13 11111 01/04/16 7 My code: Select zip5, count(ID),…
Michael Li
  • 647
  • 2
  • 8
  • 20
-1
votes
3 answers

PL SQL Insert List

i am trying to insert a list of integers in procedure using pl/sql but unfortunately am not able to find a way, can anyone guide me that how to pass a list of integers into procedure in PL/SQL.
Faizan Ather
  • 23
  • 1
  • 4
1 2 3
…
99
100