Questions tagged as 'oracle'

Tagged questions
1
answer

Enter Cities in the Oracle database

Would anyone have a query to insert into the Oracle database all Brazilian cities with accent and cedilla in the words? I'm trying to find some on the internet, but all use insert of multiple values and in Oracle would have to write the synta...
asked by 13.12.2017 / 14:55
1
answer

How to change the field of a table, taking values from another table as a reference. Using cakephp 1.3

I have an association of tables projeto > auto > anexo . In the project table I have a field cod_status , and in the attached table I have a field status . How do I make the Anexo.status change to Projeto.cod_st...
asked by 18.12.2017 / 03:35
1
answer

Why does MOD (11.2,2) give 1,2 and not 0?

I need to get the rest of a division in ORACLE and I'm using MOD that works fine with integers but when using decimal numbers gives problem. Ex: MOD (11,2) = 1 ok MOD (11.2,2) = 1.2 Wrong right in my understanding would be 0 because 11.2 / 2 = 5...
asked by 05.12.2017 / 18:07
0
answers

PL / SQL - Trigger: Can I see the entire row updated in a row after trigger?

I am studying PL / SQL in college and the teacher has passed some questions based on Oracle's own Human Resources model. The question I am asking asks for a trigger that prevents an employee from having a salary greater than his boss. And for th...
asked by 12.11.2017 / 07:15
1
answer

Convert query to SQLServer

I have the following query for the Oracle database: select xmlagg(xmlelement(e, d.delinha, '').extract('//text()') order by d.nulinha).getclobval() . I need to convert to run on SQLServer database, but I can not. Does anyone know of...
asked by 10.11.2017 / 12:56
0
answers

Use Autocomplete with Oracle

I'm trying to get autocomplete to search my oracle database, but it's not working. I made the script in the page header: <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script><linkrel="stylesheet" href="...
asked by 26.10.2017 / 13:03
1
answer

Call Oracle function in Laravel?

I made all the configuration to connect in Oracle, it connects, but I want to make an query inside a function, but it is giving the following error message:    QueryException in Connection.php line 729:       oci_bind_by_name (): ORA-01036: i...
asked by 18.10.2017 / 20:40
1
answer

Convert date entry with oracle

I'm having trouble returning the results of the following query, where I put the & month variable, if I put '01 -sep-2017 'would bring the results I need, but in the dialog box I wanted the user is typed with the patterns used for date, bein...
asked by 18.10.2017 / 14:35
1
answer

Wrong trigger update in Oracle

I have the following problem in the trigger, When there is an INSERT in the table TB_DJE_PREPUBLICACAO, it has to be checked if the column DT_DISPONIBILIZACAO is null if it is and if the column DT_PREPUBLICACAO is with the current date, the D...
asked by 14.09.2017 / 20:19
1
answer

ORA-01704: too string string literal

I have a field of type CLOB in the DB, but when I give an INSERT it returns an error saying that it exceeded the size of the field that is 4000 characters. Relatório de erros - Erro de SQL: ORA-01704: literal de string extenso demais 01704. 0...
asked by 19.09.2017 / 16:32