Posts by moises.santos • 29 points
9 posts
-
-1
votes1
answer48
viewsQ: How to Restructure a JSON
I created a Node js API connected to Oracle 12.1.0.1.0c where I connect and do the request as follows through the dbconection.js file as shown below: const oracledb = require('oracledb'); const {…
-
-1
votes1
answer1691
viewsQ: Convert LONG column to VARCHAR2 in ORACLE - problem related to LONG column value size relative to VARCHAR2
CREATE OR REPLACE FUNCTION PRC_HAM_CONVT_LONG_VARCHAR2 ( p_owner VARCHAR2, p_tabela VARCHAR2, p_coluna VARCHAR2, p_rowid UROWID )RETURN VARCHAR2 IS v_cursor INTEGER; --cursor v_length INTEGER;…
-
0
votes0
answers232
viewsQ: ERROR 1442 - Trigger AFTER INSERT - Mysql
My database has the following structure: CREATE TABLE BAIRRO ( BAI_COD INT(4) AUTO_INCREMENT NOT NULL, BAI_NOME VARCHAR(200)NOT NULL, CONSTRAINT PK_BAIRRO PRIMARY KEY(BAI_COD) ); CREATE TABLE…
-
-2
votes2
answers1217
viewsA: Update Jtable using Defaulttablemodel
public void carregarDadosProdutosJTable() { ItemDao itemDao = new ItemDao(); table.getColumnModel().getColumn(0).setPreferredWidth(4); table.getColumnModel().getColumn(1).setPreferredWidth(220);…
-
0
votes1
answer76
viewsA: Problem when reloading Table
METHOD OF CONSULTATION OF THE EDITION: public Edicao consultar(String isbn){ conn = Conexao.getConexao(); sql = "SELECT edic_isbn, edic_valor, edic_qtde, edic_numpag, edic_ano, edic_livro,…
-
0
votes1
answer76
viewsQ: Problem when reloading Table
I have the following problem, at first run my Defaulttablemodel loads normally as can be seen below in red: After registering, changing or deleting once, the table updates normally, but when I…
-
0
votes2
answers275
viewsQ: Relationship problem in the Mother Table (Inheritance) in Postgresql
I got the Mother Pay Table: CREATE TABLE pagamento ( pagcod serial not null, CONSTRAINT pk_pag PRIMARY KEY (pagcod) ) And the two daughter tables Cash and Credit Card: CREATE TABLE dinheiro (…
-
0
votes1
answer489
viewsQ: How to Save the Date Field of a Java SE Application in Postgresql
I need to save these two dates (ALLOCATION DATE and RETURN DATE) from an allocation, where I have the following Allocation Table: CREATE TABLE public.aloca ( alocod serial NOT NULL, alodtdevolucao…
-
2
votes1
answer732
viewsQ: Create a precedent in Postgresql
I have created a database in Equipment Allocation Postgresql where one or many Equipments can be Allocated by one or many Sectors. That is, I have 3 tables in this relation: One is the Sector Table…