Questions tagged as 'oracle11c'

2
answers

Oracle - How to force a field size on a function return

I hope to be clear on this issue, I will define it in a generic way but I think it's enough 1) I create a FUNCTION any that returns a VARCHAR, does not matter much what is returned 2) I create a VIEW that uses this FUNCTION Result: The...
asked by 11.09.2015 / 16:19
1
answer

Calculate DUMP import time

I would like to know, if possible, how to calculate approximate the import time of a Dump . It could be something considering the following items: DUMP size in GB. Tables Amount. Number of records and (or) rows / columns per table....
asked by 27.01.2016 / 14:31
1
answer

What is the most efficient way to connect an Oracle DB to a MySQL DB [closed]

Having the following scenario: a simple telephony application "writes" to a Mysql BD and a BD Oracle needed from time to time to look for information in this BD MySql. Has anyone done this yet? What would be the best practice? ps Actua...
asked by 26.06.2015 / 18:29
1
answer

Consider the final validity until the next day at 03 AM using PLSQL

Personal, I need to do the following validation: When a record enters my database, I need to validate the effective date of this record. If the validity is between the current date then the record is valid. Ex: Effective 12/03/2015 to 03/...
asked by 13.03.2015 / 13:40
1
answer

How to find the foreigner from one table to another by Oracle?

When we are executing SQL statements and we need to navigate between tables it is simple when we know the database modeling to apply JOIN and GROUP BY , but when we do not know, what to do? Is it necessary to apply DESC Table...
asked by 20.01.2016 / 12:51
1
answer

String or Cursor in Oracle PLSQL

Good afternoon, I have a procedure that executes a select, but I work with a bitmap, where I use conditionals to perform a specific select depending on the bit that is passed as a parameter to the procedure. In this scenario I use a varchar v...
asked by 23.12.2014 / 18:34
1
answer

Problem inserting records in Oracle

I'm having trouble inserting records into Oracle, below is the insert I use: insert into COMPRAS (id, valor, data, observacoes, recebido) values (id_seq.nextval, 200, '19-FEB-2008', 'MATERIAL ESCOLAR', '1'); However, it generated thi...
asked by 17.01.2016 / 11:23
1
answer

DB NoSql, when to use?

Working in a company that data flow is not so great, however the amount of information that is already recorded in the bank are considerably large .... Yesterday at college we discussed about the NoSql bank, about big companies like Fa...
asked by 04.09.2014 / 17:05
1
answer

Create user using a function

Someone could help me, she gets error when saving '-' Error (19.5): PLS-00103: Encountered the symbol "CREATE" when expecting one of the following: (start case declare exit for goto if loop mod null pragma raise return select select update wh...
asked by 25.05.2016 / 18:58
1
answer

PHP ORACLE VIEW FROM SELECT

I want to generate a view through a select with the code below, but it does not work, what can it be? $row[0] contains "select col1, col2, col3, col4, col5 from tabela1" $select= oci_parse($ora_conexao, 'SELECT *...
asked by 14.01.2016 / 17:39