I am using a Schema in Oracle (sql developer) and within my schema there are already several tables created that I was using previously.
Now running a new script in this scheme it has the following error:
Relatório de erros -
ORA-00955: nome j...
I have the following procedure in my bank:
I'mtryingtocallmystoreprocedurein.netlikethis:publicintCountEvent(intresourceId,inteventCounterDefinitionId,DateTimestartDate,DateTimestopDate){intret=0;using(OracleConnectionconn=newOracleConnect...
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 ,...
Good morning,
I'm looking for a help to delimit the phone field in my database, being more specific, if today someone enter a phone number with 4 digits (for example) that phone will be saved, I need it to be accepted only numbers between 8 a...
I have enabled the php_oci8_11g.dll extension, but I get the following alert.
PHP Warning: PHP Startup: Unable to load dynamic library 'C: \ php \ ext \ php_oci8_11g.dll' -% 1 No a valid Win32 application.
I've reinstalled PH...
I want to insert images and I want each record to have a maximum of 100M, if this value is exceeded, an error must be returned in the bank itself.
For illustration example of problem: (same as error is returned if we try to insert a string of...
I'm trying to get all the records of a table taking the last change so I used the MAX () function but it is not returning any results.
These are my conditions:
SELECT DISTINCT
U.USS_CODIGO,
T.CON_CODIGO,
t.CON_SEQUENC...
I received an Oracle 11g database for parsing, but the dump file is in the .datp format. I have not found anywhere on the internet reference about this type of file. The client's instructions are "have to use Oracle" but:
1- I have superfic...
Good afternoon, I have a problem with my work.
I need to create a function in oracle that performs the conversion from json to xml and show the result as a table.
I know that version 12 of oracle does this easily, but unfortunately our bas...
I have a script that connects to an Oracle database and then selects:
select count(*) from V$ASM_DISK;
This script is in a .sql file, so I make the following call in the OS:
"$ORA_HOME/bin/sqlplus -L -S xxxx/xxxx @query.sql";
When exec...