Posts by RENATO PASQUINI • 54 points
7 posts
-
0
votes2
answers1365
viewsA: "ORA-01417: a table may be Outer joined to at Most one other table"
try to do the following, AND F.SEQFAMILIA (+)= G.SEQFAMILIA AND E.SEQCONTRATODESCONTO (+) = G.SEQIDENTIFICADOR basically, the sign of (+) in the oracle represents the side of a relation that is…
-
0
votes3
answers1649
viewsA: Inserting column in Oracle table with conditional
Another way would be this: /*Verifica se coluna já existe e se não houver insere com valor padrão 'A'*/ DECLARE va_existe integer; va_nome_tabela varchar2(100); va_nome_coluna varchar2(100); BEGIN…
-
1
votes1
answer59
viewsA: Error executing Oracle command
Try the following: function mataSessao(){ $connect = oci_connect('xxxx','xxxx','xxxxx','xxxxx'); $IDSESSAO = $_POST['idsessao']; $IDSERIAL = $_POST['idserial']; $matasessao = "ALTER SYSTEM KILL…
-
0
votes6
answers32941
viewsA: Convert varchar to date in SQL
If the column DT_ITEM is of type date (DATE or DATETIME) and you want to convert string in date use the following: select * from TAB_FATURAMENTO where cd_cliente like '%' and dt_item between…
-
1
votes1
answer1445
viewsA: Compare Data Oracle
ORACLE does not recommend you convert a field to perform a query, because if the data_filter column has an index, when converting the column the database will not use the execution plan as the…
-
0
votes1
answer428
viewsA: Add values and subtract values from another condition
select ID_TITULO, sum(decode(codoperacao, 28, -1, 1) * vlroperacao) sum_vlr_operacao from titulo where dtaoperacao <= '01-JAN-2017' group by ID_TITULO;
-
1
votes1
answer1375
viewsA: How to upload data to CSV in oracle SEM SQL Loader?
The Oracle database has a feature called ORACLE_LOADER, where the file is not imported into a database table. A table is created that points to a CSV file (in fact it doesn’t have to be a file in…