Questions tagged as 'oracle'

Tagged questions
1
answer

Select Oracle Bank - Constraint

Good morning, if anyone can help me, I need a query that returns me the constraints of a table and its data types. I'm trying to set up a procedure generator to facilitate, it takes a lot of time to create procedures. In this select it does not...
asked by 16.06.2016 / 15:48
2
answers

calculate how many hours between calling date and current date in pl / sql [closed]

I need to make a query that brings the calls that are outside the SLA for 48 hours calculating the dates and times of the call's opening and current date, can anyone help me?     
asked by 31.05.2016 / 02:25
2
answers

How to use store procedure with Doctrine

How do I use stored procedure with Doctrine? Should I use createNativeQuery?     
asked by 03.05.2016 / 15:36
1
answer

Bring value from a grouped record

Dear colleagues, I grabbed a query that I thought was simple but it's complicated! I have a database where I have all my NF per product incoming goods, I need to find the value of the product in the last entry of the year. I arrived easy o...
asked by 17.03.2016 / 14:19
1
answer

Git Permission denied for longer pathnames

I have to do the clone of the project in the directory: C:\xampp_5.3\htdocs\Meu-projeto First running the configuration to allow pathnames more extensive: git config --system core.longpaths true Running the above command...
asked by 18.03.2016 / 13:27
0
answers

How to make a Delphi-Oracle connection without Oracle Client

I have an application that was developed at a time when we had a client-server system, with this there was always an Oracle client on each machine, now we have a 3 layer system and we no longer have this Client. I would like to know how to mak...
asked by 18.02.2016 / 15:34
1
answer

Conversion from Oracle to SQLServer

   Context: I currently work on a system that uses the
asked by 04.03.2016 / 18:21
0
answers

How to pass a parameter of type 'Nested Table' to a stored procedure in Oracle

I'm working with Oracle for just over 2 months and need to pass a dataset to be used in the query parameter inside the procedure. I searched a lot on the net and found no solution to solve my problem, I always get the same error message - incorr...
asked by 04.12.2015 / 15:30
1
answer

Oracle SQL - Query multiple schemas

I was able to assemble the result, but now I want to create the view with this result. What is the best way? This query: "SELECT CONCAT(CONCAT(CONCAT('SELECT * FROM ',a.OWNER),'.TAB2'),CASE WHEN a.OWNER = UPPER(b.TESTE1) THEN '' ELSE ' UNIO...
asked by 13.11.2015 / 10:58
1
answer

Error connecting ORACLE database with PHP

When trying to connect to an Oracle ORACLE database the following error appears:    TNS: listener was not given SERVICE_NAME in CONNECT_DATA I have already set up php.ini and include the following lines: extension=php_oci8.dll extension...
asked by 04.11.2015 / 11:45