oracle

What data types in Oracle correspond to the WORD and DWORD types?

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;.

There is a Python / SQL script that is written under Windows. Everything is elementary simple, I execute the request and do ... rsor.execute(_SQL) Under Windows-everything is fine, and under Linux-an error Which way to look? What could be the problem?

The Oracle server is running in docker Here is the image oracle/database 19.3.0-se2 16ac5716063a ... TNS:no listener PASSWORD entered the one that Oracle issued ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: xfZrvmBVyFs=1

There are three tables linked one-to-one by ID. I need to delete all records from three tables that satisfy the condition: A. ... D LOOP; COMMIT; END; There is a lot of data and so it works for a very long time. Is there any way to make it faster?

There is a machine with Windows XP. As far as I know, you can install the SQL Plus console without Oracle SQL Developer and without Oracle at all on the machine. How do I do this?

When writing various procedures, I ran into the problem that when I try to define a column with the data type BLOB in a priva ... ors, it works like this. Free translation How to define BLOB column in Private Temporary Table? from member @Gregor Cerinšek

Hi everyone. You need to get the ResultSet from such a procedure: exec ais_disp.p_lk.p_add_client (v_sis_id => 1640, ... ommit; How to cram this into java code? I tried using CallableStatement, but I can't insert select from the procedure there.

I'm trying to use the LISTAGG function. It is necessary to get the values of the column without repetitions. Is this possibl ... umn col1 and the list from the column col2 with the function LISTAGG. I get [2,2,3,4,5], and the desired result is [2,3,4,5].

There is a table with data, there is a formula for calculating the values of the last column. How do I create another column, ... in the specification for calculating this column and compare whether there are rows with different values of 3 and 4 columns

In SQL Server, you can use the function IsNull(expression, replacement), to determine whether the result of the expression is NULL, and replace it with an alternative value in this case. Is there an equivalent function IsNull() in Oracle?

If you run the query " CREATE TABLE some_name", jdbc throws an exception ORA-00955: name is already used by an existing obje ... rrorException e) { if (e.getErrorCode() != 955) { throw e; } } Is this correct? Is there a better approach?

There is a parser code: import io from zipfile import ZipFile import pandas as pd def read_zip(zip_fn, extract_fn=None): ... o write to the database. But Timestamp does not write correctly to the DB, because of this I will have to convert to string.

What is the request error? The request itself: CREATE GLOBAL TEMPORARY TABLE `complite_incomplite` ( `card_task_id` INT ... y? I can't run the request itself, so I pass it to another person to execute it, but I have no experience working in Oracle.

You need to prevent deleting records from the table that do not meet a certain condition by using a trigger. Without using th ... re some options can be deleted, but the rest can't, the trigger immediately throws an exception and does not delete anything.

The essence of the problem: There is a Windows Server 2016 and 2019 server. Both have SQLServerReportingServices installed. T ... r does not swear at (ODAC112040Xcopy_64bit). The result is exactly the same. NLS_LANG is registered in the system variables:

How to fix this error: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GET_DATA_INFO' ... ptions); Free translation of the question PLS-00306 when calling Oracle stored procedure in Node.js from member @siddhartha

Win 10 pro x64, the installation of Oracle Database 18c EX comes almost to the end, at a certain point, the rollback of chang ... playing any error, completes the installation, what can I do about it? Faced with this for the first time, I hope for help.

When performing CP, sometimes this error appears: SQL> CALL MY_PROC(); CALL MY_PROC() * ERROR at line 1: ORA-00936: о ... U sometimes works without errors, and sometimes it gives this error. How do I display additional information about the error?

How do I make a query that returns a conditional chessboard image? The column headings must contain the Latin letters a,b,c, ... ution is not correct, but I have not yet come up with another one. How can I display a chessboard and fill it with 1s and 0s?