Questions tagged as 'oracle11g'

1
answer

Dropping the tables from my schema in Oracle

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...
asked by 05.11.2017 / 02:37
1
answer

How to call a "Stored Procedure" oracle c #

I have the following procedure in my bank: I'mtryingtocallmystoreprocedurein.netlikethis:publicintCountEvent(intresourceId,inteventCounterDefinitionId,DateTimestartDate,DateTimestopDate){intret=0;using(OracleConnectionconn=newOracleConnect...
asked by 05.10.2017 / 22:59
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
1
answer

How to delimit a telephone field (Oracle DataBase)

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...
asked by 17.04.2017 / 17:35
1
answer

Enabled a PHP extension and a Warning appears?

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...
asked by 26.01.2017 / 20:56
1
answer

How to set a maximum size for a BLOB field?

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...
asked by 25.05.2016 / 13:24
2
answers

last change of table record using MAX function

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...
asked by 30.05.2016 / 15:10
1
answer

Oracle DUMP Recover

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...
asked by 30.10.2018 / 20:12
0
answers

How to convert JSON to XML in ORACLE 11g?

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...
asked by 10.09.2018 / 20:56
0
answers

Different results 'count (*) from V $ ASM_DISK'

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...
asked by 20.06.2018 / 17:36