I'm facing a problem with two separate queries in oracle . Both have the sql% share of%
The error that returns is REPLACE(dbms_lob.substr(wm_concat(disctinct <COLUNA>)), ',', ', ') .
I looked for the error in ORA-22922...
In Oracle what table or view of the metadata I have in the parameters of a Procedure.
My question is, does procedures have parameters with the name resembling "XPTO"?
I tried the "dict" but did not find it.
I am creating an Oracle user for my bank, after defining the basics I tried to execute my script to create the tabelas and sequences , however, the tool returned an error saying it lacked permissions.
The error:
Relatório de err...
Speak, I'm learning BD Oracle, before I used firebird. But I'm having a problem that I can not solve. I can not add a new country through the system (java), if I enter it through SQLDeveloper, it appears in the query. The error that appears when...
How do I load an Array or Bulk into a PLSQL and then read this as a table.
Example
DECLARE
VA_ARRAY ....DEFINIÇÃO DO ARRAY
VN_QTD NUMBER;
BEGIN
-- TABELA01 É UMA TABELA FÍSICA EXISTENTE NO BANCO
SELECT * BULK COLLECT INTO VA_ARRAY F...
utl_http.set_proxy ( link ');
In this example what exactly does this proxy address?
I tried the internal IP and it did not work, the infra of my company said to have no "external proxy".
Font
Thank you.
I'm in doubt, when I create a CONSTRAINT UNIQUE , does it evaluate all the columns together?
For example, I want a country not to have names or acronyms , in which case should I create CONSTRAINT different?
Because I...
In an environment I have 5 schemas that make grant and synonym between them, of which they are already working.
Now I need to duplicate this default environment for the client environment, and I need to change the name of sch...
I'm trying to replicate a binary field representing an image in Oracle. Could you tell me the best way to get this data and insert again? The field in Oracle is LONG RAW. What kind of data do you use in Java? I already tried byte and I could not...