oracle11g

There is a request SELECT * FROM SMSPECREFUSE WHERE REASON= 'Недопоставка' It works correctly and outputs what you need. If ... age', 'item Exchange', 'Short time', 'Failure to follow orders', 'not ready for public consumption' at the end of the error:

I use it to run on a remote machine .bat, which calls SQL * Plus and executes the script. In the log, only the result of the ... em.log I want to see not only the execution notification, but also the result of executing the request select * from table;.

The question is theoretical, if during the session in the Oracle database I made a transaction, such as insert or update, and ... . Can I return everything to its original state, such as Undo or Rolback. I would like to know the opinion of Oracle experts.

Once upon a time there was a Bar table in the Foo schema. Long lived in the production database, it did not have many lines, ... SQL> The DDL request to add a new column and delete it passes without errors. Restarting the instance didn't help

I installed Oracle11g, configured the connection in the idea - everything is ok. But in the end it gives this error: java.s ... ion.logon(T4CConnection.java:458) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546) .....

The request uses the following condition: t1.field = replace(t2.field, <Сложная конструкия вычислений по тексту, insrt, su ... ular case? And another passing question, is it possible to somehow find out which options are already contained in the keshe?

Why does the error occur in this example? set serveroutput on; declare -- Запись type t_recx is record ( ... alue error The type is declared as varchar2 and up to the line with the assignment, everything is executed without errors.

There is a request: select nvl(extractvalue(xmltype(p.src_doc, 871), '//*:' || pd.name), extractvalue(xmltype( ... an understanding of where exactly and on what the parser is falling apart? Version: Oracle Database 11g Enterprise Edition.

Windows Server 2012 OS DB Oracle 11g-r2 The problem is as follows: When you restart or turn on the server, everything works ... - (SELECT CURRENT_SIZE FROM V$SGA_DYNAMIC_FREE_MEMORY) ) "SGA_TARGET" FROM DUAL; Conclusion: SGA_TARGET: 5465165824

I have a table, for example, pessoa, and I would like to delete all people over 40, with the script below I do this: DEL ... d how the bank is in production, when doing this will crash all users. Is there a more efficient way to solve this problem?

I want to know how to go through all tuples that are stored in a table; how do I do this in PL / SQL Oracle ? Right now, thank you!

I have the following procedure in my bank: I'm trying to call my store procedure in .NET like this: publi ... Incorrect number of argument types in the call to 'COUNT_EVENT' Could anyone help me in why the parameters are wrong?

I enabled the extension php_oci8_11g.dll but I get the following alert. PHP Warning: PHP Startup: Unable to load dynamic ... but the error continues. Does anyone know what it can be? Note: I'm using 64-bit Windows 10 and my PHP is in version 5.6.30.

closed . This question needs details or to be clearer and is not currently accepting answers. ... form a select in Oracle that brings all the people who have the same name, surname and date of birth but, have Different IDs.

I am studying PL / SQL and testing the use of CURSOR, but I am not able to test an example: SET SERVEROUTPUT ON DECLARE V ... of the following: if 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a PL/SQL compilation error. *Action:

What's wrong when I try to set a value for an oracle11g variable and use it as a parameter ? I found a post with the same do ... D_CLIENTE = ID; END; Error: ORA-06550: line 4, column 9: PLS-00428: an INTO clause is expected in this SELECT statement

I would like to know how to get the result according to the image, I have a column with id that links the parent and child records, I know that the join joins the tables side by side, however, I needed to join below.

In a table X I have a date column that also returns the time, I would like to know if, based on that time, I have how to crea ... me of the turn. ex (if you have a given 20-02-2002 06: 00: 00 I want to appear in the column the Char 'morning'). any ideas ?

I'm doing a test with some tables, and I decided to do a test with the following command: select 1 from dual where sysdate ... inconsistent datatypes: expected %s got %s" *Cause: *Action: I've done other tests with other data types and it worked.

closed . This question needs details or to be clearer and is not currently accepting answers. ... 3 D 4 E 5 F 6 G 7 a.m. 8 I 9 J Can you help me make the correct command to resolve this situation?