Questions tagged as 'oracle'

Tagged questions
2
answers

Remove double quotation marks in codeigniter query builder

I'm using the Codeigniter framework and every time I create a select with query builder of them, it puts double quotes in all columns and tables. Ex: SELECT "ID", "NAME" FROM "STUDENT" This gives me a problem because I use 2 connections to...
asked by 06.06.2017 / 14:04
2
answers

SELECT that brings active products in one company and that are not active in all other

I have a table that shows the products that are Active (A) or Inactive (I) in 16 branches. That is, there are 16 rows for each product. I want to select all products that are Active (A) in company 16 and at the same time must be Inactive (I)...
asked by 19.04.2017 / 17:01
1
answer

Difficulty in assigning valorer in plsql

In a college exercise the following was requested:    In a presidential election there are three candidates. Votes are   informed by code. The data used for scrutiny   following codification: 1, 2, 3 = votes for the respective   candidates; 4...
asked by 16.04.2017 / 22:53
1
answer

How to delimit a telephone field (Oracle DataBase)

Good morning, I'm looking for a help to delimit the phone field in my database, being more specific, if today someone enter a phone number with 4 digits (for example) that phone will be saved, I need it to be accepted only numbers between 8 a...
asked by 17.04.2017 / 17:35
1
answer

problems to create multiple tables in Oracle

I'm new to using Oracle , I used firebird before. I would like to know, why I can not create multiple tables at once in the sql master of SQLdeveloper . It creates only the first table (Country). I try to execute the follow...
asked by 18.05.2017 / 17:42
1
answer

Oracle End of file when executing procedure

I'm having the following error message when executing this procedure *Encontrado simbolo "end of file" quando era esperado:* DECLARE -- LOCAL VARIABLES HERE I INTEGER; BEGIN FOR NCM IN (SELECT * FROM NCM_NCM) LOOP UPDATE ADMPRODU...
asked by 04.04.2017 / 18:53
1
answer

Conversion of a Date Subquery to Character in Oracle

I have a sub-query returning dates this way: SELECT DISTINCT DT_EMISSAO_NF FROM DANFE ORDER BY DT_EMISSAO_NF DESC And, starting from this query, I need all the returned dates to be converted into a character in this pattern 'DD / MM / YYY'...
asked by 02.05.2017 / 20:03
1
answer

PL / SQL - Incorrect number of argument types in the call

I'm having a problem with a simple function that I created. create or replace FUNCTION dry_login ( username IN VARCHAR2, password IN VARCHAR2 ) RETURN BOOLEAN IS l_user varchar2(70); l_pwd varchar2(70); BEGIN SELECT usuario_...
asked by 26.05.2017 / 16:29
1
answer

Error compiling function in oracle

When trying to compile the following function: CREATE OR REPLACE FUNCTION f_id_fornecedor(Nomefornecedor in varchar(50)) RETURN integer IS codigoforncedor integer; BEGIN SELECT codfornecedor INTO codigofornecedor FROM TBFORNECEDOR WHERE N...
asked by 02.05.2017 / 21:24
2
answers

Error Installing WebLogic Oracle

I'm trying to install Oracle WebLogic, but in the installation process the message appears:    C: > java -jar fmw_12.2.1.0.0_infrastructure.jar   The trigger log file is C: \ Users \ Wagner \ AppData \ Local \ Temp \ OraInstall2017-04-06_0...
asked by 06.04.2017 / 21:41