Questions tagged as 'oracle'

Tagged questions
1
answer

Percentage in SQL

I have the following query code: SELECT AC.DT_AGENDA AS DATA, ME.DS_MULTI_EMPRESA AS EMPRESA, AC.CD_UNIDADE_ATENDIMENTO AS CD_UNID_ATENDIMENTO, UA.DS_UNIDADE_ATENDIMENTO AS UNIDADE_ATENDIMENTO, COUNT...
asked by 26.04.2018 / 21:20
1
answer

PLSQL return error when retrieving Bank data

I try to extract data in the database and insert it into a record and then show it in cmd, However when I get a larger number of registration the procedure requires an error message. Code: SET SERVEROUTPUT ON DECLARE TYPE trec IS RECORD...
asked by 10.05.2018 / 23:11
1
answer

Oracle - Cursor

I am studying PL / SQL and testing the use of CURSOR, but I am not able to test an example: SET SERVEROUTPUT ON DECLARE V_NAME VARCHAR2(50); CURSOR CUR_CURSOR IS SELECT FIRST_NAME FROM EMPLOYEES; TEMP CUR_CURSOR%ROWTYPE; BEGIN IF N...
asked by 29.03.2018 / 16:31
2
answers

Error connecting to oracle database using web programming in .NET

When attempting to connect to the bank, I got the error according to the attached image. My application is web in .net, visual studio 2010, database oracle sql developed 3.1.07. My code where you get the error: protected int GetRowCounts()...
asked by 21.02.2018 / 17:45
1
answer

Field as parameter in Generic Update - ORACLE

I currently have a procedure that reads an XML, and does an update on the fields of the physical_person table based on the values sent by the XML, such as CPF, RG, Name, etc. Today I read the XML values and insert into the table variable....
asked by 26.02.2018 / 16:08
1
answer

Error After executing procedure: no output

Code CREATE OR REPLACE PROCEDURE buscaturma(cod NUMBER) AS nomeT varchar2(20); BEGIN IF (cod=0)then dbms_output.put_line('ZERO'); ELSE SELECT DS_TURMA into nomeT FROM TURMA WHERE CD_TURMA = cod; dbms_output....
asked by 23.01.2018 / 15:04
1
answer

How to call another procedure or function within the same packge in oracle?

I have varaias procedures and functions within the same package. How can I reference some inside in my PL-SQL code? PACKAGE : BOX1 PROCEDURE : CLOSE, SOMATOTAL FUNCTION : TOTALNOTES How can I reference SOMATOTAL within CLOSE?    ...
asked by 23.01.2018 / 21:28
1
answer

Customize SQL query output

How do I customize an output of a SQL query example result of a sum of the columns OUTPUT: 23000 wanted to customize only that output to $ 23,000     
asked by 08.02.2018 / 18:42
1
answer

Error in persistence.xml when connecting oracle database

I have this file to perform oracle database persistence. But do not connect! <?xml version="1.0" encoding="UTF-8"?> <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
asked by 16.01.2018 / 15:40
1
answer

Remove Oracle Simple Quotes

Good morning, How can I remove single quotation marks from a string in the oracle database? If I do Replace (test, '' ',' ') is not right. Thank you.     
asked by 11.12.2017 / 13:43