Questions tagged as 'oracle'

Tagged questions
1
answer

Performing UPDATE in ORACLE using FROM

How to UPDATE in Oracle records without using a IN clause to change bulk data? This way: UPDATE TABELA1 SET DADO = DADO FROM TABELA2 WHERE TABELA1.CODIGO = TABELA2.CODIGO; Currently it forces me to report a IN c...
asked by 12.01.2018 / 21:15
1
answer

problem changing PHP environment variable

I installed php via xampp and I need to change this variable: NSL_LANG.Icreatedaphpfilewiththiscode:<?phpputenv("NLS_LANG=BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252") or die("Falha ao inserir a variavel de ambiente"); phpinfo(); ?>...
asked by 26.01.2018 / 18:55
1
answer

Error executing oracle procedure

I have this procedure: CREATE OR REPLACE PROCEDURE buscaturma(cod in INTEGER) AS nomeT varchar2(20); BEGIN dbms_output.put_line('inicio'); IF (cod=0)then dbms_output.put_line('ZERO'); ELSE SELECT DS_TURMA into nomeT...
asked by 23.01.2018 / 14:30
1
answer

How to set Foreign key in oracle SQL developer?

I'm new using this program, how do you define Foreign key in oracle SQL developer?     
asked by 25.11.2017 / 18:29
1
answer

How to resolve error ORA-01795 (maximum number of expressions) in Codeigniter

I am developing a report in Codeigniter, however my select contains a filter that can have more than 1000 expressions in my where_in and then it returns me the error: ORA-01795: o número máximo de expressões em uma lista é de 1000. I...
asked by 25.10.2017 / 12:09
1
answer

Insert data into Oracle table "without returning id into"?

I'm using Laravel 5.2 and when I enter data it wants to return the last, but at the moment I want to insert and know if the operation was successful. My function in controller looks like this: public function cadastrar(), { $cod...
asked by 19.10.2017 / 20:16
1
answer

Dropping the tables from my schema in Oracle

I am using a Schema in Oracle (sql developer) and within my schema there are already several tables created that I was using previously. Now running a new script in this scheme it has the following error: Relatório de erros - ORA-00955: nome j...
asked by 05.11.2017 / 02:37
1
answer

Bring descriptive information of a sequence in PHP

I have a form, one of the fields is a dropdown that does query and brings the results as below: <select name="convenio" id="convenio" class="input" style="width:260px"> <option value="selecione">...
asked by 07.11.2017 / 21:46
2
answers

How to get last sequence in Oracle?

I tried 3 different ways, to make a select of the last sequence of my table, but none worked.    SELECT SEQ_ID_PAIS.CURRVAL FROM DUAL; Error: ORA-08002: a sequência SEQ_ID_PAIS.CURRVAL ainda não foi definida nesta sessão...
asked by 01.10.2017 / 15:38
1
answer

Deserialize Image in ASP.NET WebForm

I have a question about the deserialization of an image in webforms, I am working with Oracle Database which is my context and using the entity framework for image I am using BLOB, I was able to serialize and commit in bd, but not I can deserial...
asked by 24.11.2017 / 13:07