I tried to run this pl / sql but it did not work
declare
v teste%rowtype;
begin
v.ra;
select ra into v.ra from teste where nome = 'Danilo';
dbms_output.put_line(v.ra);
end;
After a long time I decided to assign a value to it and then change...
Considering these two tables in the database:
Product Table:
| id | nome |
|-----|-----------|
| aaa | Produto A |
| bbb | Produto B |
| ccc | Produto C |
Attributes Table:
| id_produto | atributo | valor |
|------------|------...
I have an anonymous PL / SQL block that returns an XML to me as the result of running a web service. How do I give a select in this XML to get only one column I want?
Anonymous block:
DECLARE
l_filename varchar2(255);
l_BLOB BLOB;
l_CLO...
I'm trying to use the following command to insert:
$sql = "INSERT INTO tabela (campo1, campo2, campo2, campo4)
values(:campo1, :campo2, :campo3,'S')";
$campos = array(
':campo1' => $nome,...
I need to make a report and I can not sort it as a wish, I want to select customer debit between 60 and 120 days and sort by total. The code looks like this:
SELECT
SUM(cod_fat_cli) "Total",
nom_cad_cli "Nome",
end_cad_cli "Endereço"
FR...
I need to return the total monthly data according to the parameter of MONTH and YEAR reported.
I did as follows:
WHERE a.dt_mesano_referencia between
to_date('01/'|| :NR_MES ||'/'|| :NR_ANO ||' 00:00:00', 'dd/mm/yyyy hh24:mi:ss') and
last_...
I wanted to calculate the data of a bad table as follows
I have a price column
100 140 300 200
I wanted to generate a second column that would make a consecutive sum of the previous table
100 240 540 740
I was able t...
I'm trying to perform insert operation on oracle by Laravel (5.6), but it's giving error:
The method I make the insert is this:
public function salvar( Request $request ){
$agenda = new Agenda();
$agenda->dt_agenda = $req...
vsql = @"INSERT INTO ALUNOS_ (UF, IDADE, TELEFONE, NOME_PAI, ENDERECO, EMAIL,
NOME, CIDADE, NOME_MAE)
values ('sp', 0,'','','','','','','');";
This SQL when executed in oracle does the insertion but in the...
When declaring the name of a procedure in sqldevelope
I get this message
Erro: ORA-00972: identifier is too long
Naming example:
PRC_IMVW_TISS_VERIFICA_ELEGIBILIDADE
CREATE OR REPLACE PROCEDURE PRC_IMVW_TISS_VERIFICA_ELEGIBILIDADE AS...