Code
DECLARE
BEGIN
FOR I IN (SELECT * FROM PRODUTOS_TESTE2) LOOP
DBMS_OUTPUT.PUT_LINE(I.codigo|| ' - ' || I.categoria || ' - ' || I.VALOR);
END LOOP;
END;
Error message:
Relatório de erros -
ORA-06550: line 5, col...
I have this PL-SQL code:
/*1. Criar um bloco PL/SQL anônimo para imprimir a tabuada abaixo:*/
DECLARE
VN CONSTANT NUMBER(2) := 5;
BEGIN
FOR i IN 1..1O LOOP
DBMS_OUTPUT.PUT_(VN || ' X ' || i ||'='|| VN*i);
END LOOP;
END;
Er...
Good afternoon guys!
I'm still new to the subject when it comes to sql, I'd like to know how to create a JOB (or another operation that does the same) that performs a data extraction from a table to a .sql file in a directory I set .
If it...
create or replace TRIGGER cascade_update
AFTER UPDATE OF project_name ON PROJECT
FOR EACH ROW
BEGIN
UPDATE VEHICLE
SET project_name = :new.project_name
WHERE project_name = :old.project_name;
UPDATE VELOC...
I need to do a stored procedure in oracle where I have 5 input parameters and 1 output parameter that will be a cursor (recordset). The problem is that each input parameter can receive more than one value, that is, a list of values. These receiv...
I'm developing a call panel. I have a query that results in the client's call (name / password / guiche), this query returns the result for 10 seconds, after that it is empty until the next call.
I need every time this query has content (numr...
Hello friends I'm trying to do a sql query in SQL Developer as follows:
SELECT * FROM CLIENTE WHERE NOME_CLIENTE IN ('SALES & CIA AGUIAR', 'SAO JOAO')
The tool understands the '&' character as a variable entry and so does not displa...
I am having a question for mounting a query on Oracle, I have the following so far ...
SELECT M5.NIVEL_ESTRUTURA
, M5.GRUPO_ESTRUTURA
, M5.SUBGRU_ESTRUTURA
, M5.ITEM_ESTRUTURA
, M5.SEQ_OPERACAO
, M5.CODIGO_ESTAGIO
FR...
I'm working on an application with N Hibernate and Fluent NHibernate. I'm having problems with the settings of my App.config . I do not know exactly what's wrong with my settings.
I'm getting this Exception:
NHibernate.HibernateExcepti...