Questions tagged as 'oracle'

Tagged questions
1
answer

How to collect statistics in Oracle Metadata tables?

Collecting statistics from User Tables is simple, just use dbms_utility.analyze_schema, but can (and can) do this for the Oracle Metadata tables? This post , was the source of this doubt.     
asked by 06.06.2014 / 23:28
1
answer

How to give an EXECUTE IMMEDIATE command in an ORACLE bank starting from a JAVA application?

The error is when I run: execute immediate 'update teste set num = 1234 where num = 1'; Exception: java.sql.SQLSyntaxErrorException: ORA-00900: instrução SQL inválida     
asked by 09.07.2014 / 21:18
1
answer

Oracle 12C + Java + XMLType

Hello, Good morning in my company we are testing Oracle 12c. And I found a "problem" to query a field that is the XMLType type. We saved all xml from nfe in the database, so we always have to query this xml. The problem is this, when I query in...
asked by 15.08.2014 / 15:23
1
answer

View BMP image saved in Oracle in PHP

How to do to recover a BMP image saved in an Oracle database and display it on the screen Unfortunately I can not store the image files on the server and save the database only the path.     
asked by 02.05.2014 / 22:21
2
answers

ORA-00907: right parenthesis not found

Hello, I have just been working with oracle, and I'm having this problem in the query, it returns the error: ORA-00907: right parenthesis not found, it follows below: ("""select ordem.id,ordem.data_prog,ordem.rms, ordem.pkpk,...
asked by 03.01.2018 / 14:27
1
answer

Serialize XML and save in Oracle with C # and ADO

I would like to know if there is something equivalent in Oracle for this select in SQL Server: select NickName, ExternalId1 from Basics where externalId1 = @externalId1 for xml auto, elements; And for this select below: sele...
asked by 02.04.2014 / 05:03
2
answers

Change Oracle session to accept number with comma and point in C #

When opening an oracle connection in C# , I need the . and , to behave according to the 0.000,00 rule in a real number. I would like to know how do I change this format in open session in OracleConnection     
asked by 10.04.2014 / 20:08
0
answers

Oracle, how does the no_proxy_domains parameter of UTL_HTTP.set_proxy work?

UTL_HTTP , we have the set_proxy method in it a no_proxy_domains parameter , how this works. In short, I want to request a URL without requiring authentication.     
asked by 07.03.2017 / 19:40
2
answers

Oracle reference the type of a column equal to the type of another column

I'm trying to create a table to return in a function. For this, I'm trying to create a object type like this: create or replace type relatorio as object ( planta TABLE_NAME.COLUMN%TYPE, resp_0 TABLE_NAME.COLUMN%TYPE ); But you...
asked by 17.03.2017 / 19:51
1
answer

Tree Page - Oracle Apex

I'm having trouble creating a tree page on oracle apex . I created the page, but apex displays the results, but not grouped by the specified node. It's a list of paid titles. I would like to create the Vendor node and below it the related t...
asked by 14.06.2016 / 15:30