Questions tagged as 'oracle'

Tagged questions
1
answer

How to save RadioButton in Oracle

How do I save only the Dialed RadioButton? Images below what I did. It is saving a value even though I have marked the other one. In my database do I have to create a single field to save any of the information? Note: I'm using Visual Studio...
asked by 27.06.2016 / 23:43
2
answers

Filter date by time intervals until the last possible hour within the same day

The rule All records that are within a 1-hour interval should be counted as 1 records only. Data ID DATA 1 06/07/2017 09:20:35 2 06/07/2017 10:20:35 3 06/07/2017 10:25:30 4 06/07/2017 10:40:35 5 06/07/20...
asked by 06.07.2016 / 15:47
1
answer

Oracle - From / to WebFocus to Oracle

Well, I'd like some help. I have an ETL that was created in WebFocus, and I'm going to migrate it to Oracle. I have already done a good part of the / paras, and would like an alternative to the following situations. In WebFocus, it can use...
asked by 17.10.2016 / 20:02
0
answers

List only the largest age group?

I'm trying to make a comparison by age to list only the age corresponding to your age range. Ex: 20 year age range from 0 to 43. SELECT DISTINCT U.USS_CODIGO, t.con_codigo, t.CON_SEQUENCIA, t.PLA_NUMERO, t...
asked by 07.06.2016 / 19:07
2
answers

Add 2 selects to one, showing the fields

The 1st select shows the following fields: CONCAT - FILIAL - COD. PRODUTO - DESCRICAO - QNTD. VENDAS PUB. 11 - 1 - 1 - PRODUTO 1 - 10 12 - 1 - 2 - PRODUTO 2 - 20 13 - 1 - 3...
asked by 01.05.2016 / 01:27
1
answer

How to insert and execute parameters in a procedure in oracle 11g in vb6

PROCEDURE pr_consulta_rg_site ( p_rg_cidadao in varchar2, p_dt_nascimento in varchar2, p_rg_cidadao_o out varchar2, p_no_cidadao_o out varchar2, p_dt_nascimento_o out varchar2, p_dt_expedicao_o out varchar2, p_texto_o out varchar2 ) as...
asked by 30.05.2016 / 16:20
0
answers

Multiple connections with bank - Executable c # with multi task

I have an executable that I need to run a giant database. As the processing time would be unfeasible if I did in a single Thread .... Following the idea of this question , I decided to create an executable that does N tasks in parallel...
asked by 25.04.2016 / 17:17
1
answer

View a list of fields, reporting movies and associates using CROSS JOIN

I have three tables, the tb_filme table, the tb_ator and the tb_ator_filme, I need a script that displays the list of all the actors and movies associated with them, follows images to clarify AndIneedascripttodisplaythemlikethis,usedCROSSJOI...
asked by 25.10.2016 / 21:06
2
answers

Error in Insert ... Values using oracle error 00936

I'm trying to make an insert into a table and it always gives me the error 00936 that says missing expression when it arrives at the cmd.executenonquery command line. Can someone help me? Code that I have: using (OracleConnection conn = new...
asked by 26.04.2016 / 19:08
1
answer

My search in BD oracle does not work

I have a method, using Ado.Net to bring DB information (Oracle 11g). There is information in the table (6 records) and when I run it by C# no record comes. See the code below: public class ConexaoBanco { string conexao = Con...
asked by 18.03.2016 / 12:27