Questions tagged as 'oracle'

Tagged questions
4
answers

Oracle11g - SELECT command problems

I have the following error:    java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly   ended This happens after I run the following line of SQL : /* Listar todas as reuniões do utilizador onde esteja convidado*/ St...
asked by 23.10.2014 / 12:03
2
answers

Update to clear entire column

I need to make a update in the bank where I clear 30,000 records, however I need to zero only the record of one of the columns. Example table: cd_product | ds_product | pr_product | dt_update This table contains the 30mil records an...
asked by 06.01.2015 / 12:30
2
answers

What is the best way to authenticate to the database?

What is the best way to make a connection to the database using C #? Create a USERS table, or create a USER in the database to access?     
asked by 02.11.2017 / 19:47
1
answer

SQL Exception Oracle - Update and Insert

I have a question regarding a procedure that I'm doing oracle database. A little explanation for what I'm doing: I'm reading data from a table, and playing them on a cursor, after playing the cursor, I set it to a record, in the procedure I have...
asked by 02.12.2016 / 15:17
2
answers

How can I use something similar to an IF in an SQL query

I'm applying a SQL q query on Oracle SQL Developer in multiple tables where Column of a view is null in some places and then I'll need to use values of Column and not% I know how to use the query IF very well. Home Can anyone hel...
asked by 03.06.2016 / 16:35
1
answer

Removing reserved SQL words from a Java string

I'm doing a view that has an open field ( textarea ) where the user can write SQL and then can execute the same SQL. The question is that the oracle user where it will run SQL has permissions for everything and it is not supposed to d...
asked by 22.04.2016 / 18:17
2
answers

UTL_SMTP: Sending accents

Hello, I'm using Oracle XE 11.2 to send emails using the UTL_SMTP package, but whenever there are accents in the subject or message, it is replaced by a "?". What I have is the following: I have a procedure that contains the parameters for...
asked by 17.11.2014 / 14:45
1
answer

Return JSON with date and time

I have a problem to return json with date and time the code is as follows: <?php $sql = "SELECT CRED_NUMERO, MOV_DATAHORA FROM APOIO.LOG_CREDENCIAL_APOIO A WHERE A.CRED_NUMERO = 10734568 AND TRUNC(MOV_DATAHORA) = TRUNC(SYSDATE)"; $conn = oc...
asked by 26.08.2015 / 16:13
1
answer

Conversion is not valid

public int ObterTotalAcessos() { int obtertotal = 0; using (var connection = ServiceLocator.ObterConexao()) { var command = connection.CreateCommand(); command.CommandText = "SELECT SUM (ACESS...
asked by 13.10.2014 / 16:19
1
answer

inner join table on 1 = 1 can be considered a gambiarra?

I have a table of provas and a table of alunos that have no direct relationship, I still have a inscrição aluno table and a escolas table, as follows in the modeling below: Ineedtocreateaselecttobringhowmanystudents...
asked by 02.06.2015 / 15:26