I'm doing an application in Asp.NET , with Entity Framework and using the database Oracle and it's the following I'm uploading the image by a button and saving in the database with type% I want to be able to do this, b...
During the installation of SQL developer 17.3.1 on ubuntu 16.04, it did not prompt user and password. In this case I can not log in, is there any default user or some way to set up a user?
I have the following table with the fields below
SELECT
NR_ANO_MES,
nr_contract,
product_type,
NM_PRODUCT,
sum (QT) as QT
FROM
INN.FT_VENDA
The product_type field has 3 classifications (Video, Data, Voice) and the Product Name field h...
I'm doing a query , however I'm learning now. Can you improve the performance of this query?
select a.COD_EMPRESA, b.Dat_pagamento
from SAS_EMPRESA a
full outer join SAS_ITEM_PAGO b on (a.COD_PREF_EMPRESA || a.COD_EMPRESA = b.COD_PREF_EMPRESA...
I'm using Django Rest Framework, so when I insert a field with null value [POST Model], it retrieves it with an empty value [Get Object Detail]. Why does it happen?
Good afternoon,
I would like to create "Cycles" (Cycle field, increasing sequential numbering), where the beginning of the cycle will always be at "Cod = 10 (cod field)" and the End of Cycle "Cod 99 (Cod field)". In the case of End of Cycle if "...
I have this String in oracle: 'Linked Order with Sale: 4575987/10'
and would like to return only the order number in this case 4575987/10.
So far the maximum I've achieved is by passing a fixed value, but you are going to invoke a fixed number I...
What should change in my query
WITH Consulta AS
(SELECT DT_RFRN_MVMN,
TX_DATA_VNDA,
CD_BNDR,
CD_CRDE,
CD_PCSR CD_EMSR,
CD_TIPO_PLTF_PGMN,
CD_TIPO_TRNS_BNDR_RECB,
CD_TIPO_APRS_TRNS_RECB,
CD_PRDT_BNDR_RECB,...
Good morning.
I need to calculate between values that are stored in my DB, these values are marked with the + and - sign in their respective tables.
I would like to know if there is any way to do that through a single SQL command I make these ac...
I have a problem with a query, which I need to do a left outer join of one table with another, or considering values as 0, if that's the case, basically what I was doing was as follows.
select B.coluna
from A, B
where A.coluna = B.coluna(+) or...