Questions tagged as 'oracle'

Tagged questions
1
answer

Date conversion to oracle

I have a problem, I'm trying to save a date in oracle with the formatted dd/MM/yyyy , however, in the database it displays the date in dd/MM/yy format. So, I came to doubt, if the type I used in the table is not appropriate, or i...
asked by 23.09.2017 / 02:10
1
answer

Oracle - Error connecting to ADOConnection Delphi 10.1 (Berlin)

I have an application that works on Delphi XE2 using the database connection component ADOConnection . When I migrated to Delphi 10.1 (Berlin) , it did not show any error. The connection exists, but does not connect, and displays the followi...
asked by 18.09.2017 / 14:56
2
answers

Grant for multiple Oracle tables

I need to create a database user where he can have all DML permissions, but when creating the grant I have to specify table by table, there is some form of permission for the whole bank, follow my example : GRANT select, update, delete, insert...
asked by 08.09.2017 / 22:11
1
answer

Call Procedure with Oracle return in Codeigniter

I'm developing a system and in a part of the code, I need to call a procedure and it returns a value. How can I do this? For the time being I did it and it did not work: $sql = "CALL P_VERIFICA_VALORES(" . $this->_databas...
asked by 19.09.2017 / 22:28
1
answer

Execute script file directly in PLSQL

I have arquivo.sql , which has thousands of lines of scripts, containing, creations, changes, etc. I need to run this file directly in PLSQL in SQL Window , and not can be via Command Window . Via Command Window ,...
asked by 19.07.2017 / 16:31
3
answers

Update in the values of the CD_SETOR column in all the tables found with the column

Using select SELECT * FROM DBA_TAB_COLUMNS WHERE column_name like 'CD_SETOR' I get many tables with different owner with the same CD_SETOR. EX: Owner Tables Column Type 210 MVINTEGRA INTEGR...
asked by 21.06.2017 / 22:37
1
answer

Name of Columns in uppercase with Codeigniter and PostgreeSQL

I am developing a WEB system using Codeigniter with support for Oracle database and PostgreSQL. In my queries, I use Codeigniter's own Query Builder. Simple Select example: SELECT "ID", "NOME" FROM "USUARIO" However, this sele...
asked by 07.06.2017 / 16:33
1
answer

Query rows having maximum value in a column

I have a problem with a query in a Oracle database in a table with 3 columns:    ID_Loja | Channel | Sales_Value There is the possibility of having more than one sale per store and I want to know which channel is assigned to...
asked by 21.05.2017 / 23:00
2
answers

Oracle DB and MVC 4 with error ORA-06413

I'm having a problem very similar to this here . In short, I have an application that runs with ASP.NET MVC 4, using the .NET Framework 4.0, using the same Oracle access DLL, the System.Data.OracleClient.dll Version 2.0.50727. I did wh...
asked by 22.05.2017 / 20:28
1
answer

Error executing Oracle command

Well, good afternoon, I'm having trouble calling a function in Oracle ... The function is this: function mataSessao(){ $connect = oci_connect('xxxx','xxxx','xxxxx','xxxxx'); $IDSESSAO = $_POST['idsessao']; $IDSERIAL = $_POST['id...
asked by 08.05.2017 / 19:50