Most voted "oracle11c" questions
16 questions
Sort by count of
-
5
votes2
answers2251
viewsOracle - How to force a field size on a Function return
I hope to be clear on this issue , I will define in a general way but I believe that enough 1) I create any FUNCTION that returns a VARCHAR, it does not interfere with the return 2) I create a VIEW…
-
5
votes1
answer819
viewsCalculate import time of DUMP
I would like to know, if possible, how to approximate the import time of a Dump. It could be something considering the following items: GB DUMP size. Number of Tables. Number of Records and(or)…
-
4
votes1
answer322
viewsWhat is the most efficient way to connect an Oracle BD to a Mysql BD
Having the following scenario: a simple telephony application "writes" in a Mysql BD and an Oracle BD needed from time to time to search for information in this Mysql BD. Someone already did this?…
-
3
votes1
answer204
viewsConsider the final term until the next day at 03 am using PLSQL
Guys, 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 term is between the current date then the record is valid.…
-
2
votes1
answer294
viewsString or Cursor in Oracle PLSQL
Good afternoon, I have a precedent that executes a select, but work with a bit map, where I use conditionals to perform a specific select depending on the bit that is passed as parameter to…
-
2
votes1
answer2582
viewsHow to find the foreign from one table to another by Oracle?
When we are running 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? It is…
-
2
votes1
answer858
viewsProblem inserting records into Oracle
I’m having trouble entering records in Oracle, below follows the insert that I use: insert into COMPRAS (id, valor, data, observacoes, recebido) values (id_seq.nextval, 200, '19-FEB-2008', 'MATERIAL…
-
0
votes1
answer135
viewsDB Nosql, when to use?
I work in a company that the data flow is not so great, however the amount of information that is already recorded in the bank are considerably large.... Yesterday in college we argued about the…
-
0
votes1
answer1166
viewsRun Instant with Break Lines Getting Invalid Package
I’m creating a package dynamically: DECLARE vpackageletras VARCHAR2(2000); vvalorpossuia VARCHAR2(10); vvalorpossuib VARCHAR2(10); BEGIN IF letras.possuia THEN vvalorpossuia := 'TRUE'; ELSE…
-
0
votes1
answer58
viewsGroup function does not work
I have two tables. Table: Pedido Columns: IDPEDIDO, CLIENTE, DT_PEDIDO, FORMA_PGMT, CLIENTE_ID. Table: Itens_Pedido Columns: PEDIDO_ID, QT_MERCADORIAS, MERCADORIA, MERCADORIA_ID. I need to create a…
-
0
votes1
answer697
viewsPHP ORACLE VIEW FROM SELECT
I intend to generate a view through a select with the code below, but it doesn’t work, which may be? $row[0] contains "select col1, col2, col3, col4, col5 from tabela1" $select=…
-
0
votes1
answer84
viewsCreate user using a Function
someone could help me, she keeps giving error when saved '-' Error(19,5): PLS-00103: Encountered the Symbol "CREATE" when expecting one of the following: ( start case declare quit for goto if loop…
-
0
votes0
answers534
viewsQuery error - Inconsistent NCLOB data
Hello, I am trying to perform a query in an Oracle database and is returning an error ORA-00932: inconsistent data types: expected - obtained NCLOB 00932. 00000 - "inconsistent datatypes: expected…
-
0
votes1
answer28
viewsOracle Year in full
This question is allowed ? Simple , in thesis SELECT TO_CHAR(SYSDATE, 'YEAR','NLS_DATE_LANGUAGE=PORTUGUESE') FROM DUAL; You should return Two thousand and twenty-one. But returns TWENTY-TWENTY-ONE…
-
0
votes0
answers32
viewsReturn all results in a grouped query even if the sum is zero or null
I have the following consultation grouped: SELECT SUM(SUC.PESO), EXTRACT(DAY FROM HU.FIM), CASE WHEN (ACO.COLUNA_2 IN ('L','C') AND HU.ESP_MM_UNMET<=3) THEN 'Carb' WHEN (ACO.COLUNA_2 IN ('L','C')…
-
-2
votes1
answer823
views