I have 2 tables with relationship 1 to many and I need to concatenate all values of column Nome of table 2 in only one column of select.
Eg:
In the example, the return of what I need would be Maria, João, José
No...
I come from a T-SQL (MS SQL Server) background and have things that do not work the same in PL / SQL.
I would like to know how to give a select in PL / SQL scalars.
Examples in MS SQL Server
Example 1:
SELECT 1 + 1
Example 2:
DEC...
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...
I'm starting to mess with the PL / SQL database and I'm having a hard time creating a trigger that when inserting a row in the table, put a value in my column whose name is token .
I made a code with what I know from DB , but when I ru...
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....
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?
...
I have a table and a function that returns a pipeline, but the function needs to receive a data from the first table, I thought the selection would look something like this:
Select FERRAMENTA.IDFERRAMENTAS
FROM SIG_SERVICOSFERRAMENTAS FERRAME...
How can I change the ID of my table BANDAS_E_ARTISTAS and ensure that other foreign tables also change via PL / SQL?
TABLE BANDAS_E_ARTISTAS
ID NOME_ARTISTICO
01 RAÇA NEGRA
02 OS MENUDOS
03 KELLY KEY
04 LUIZ CARLOS
--------------------------...
I'm making a report and I need to filter out the last 3 vendor evaluations in case this vendor has been downgraded by the date requested in the report.
Each evaluation has several questions and I need to bring all these questions to each of t...