Top "Oracle" questions

Why do i get #### in the NUMBER column after format... Oracle?

I have two problematic columns: Fee NUMBER type, AdjFee also NUMBER. After column Fee format a5; select Fee ID smth …

oracle numbers format sqlplus

Oracle Joins - Comparison between conventional syntax VS ANSI Syntax

Preamble Of late, I see too many geeks commenting on Oracle questions saying that "Do not use (+) operator, rather use …

sql oracle oracle11g oracle10g oracle12c

Oracle select for update behaviour

The problem we try to solve looks like this. We have a table full of rows which represent cards. The …

sql oracle locking blocking

convert blob to clob

I'm using oracle 11g and I'm trying to find out the length of a text. I will normally use select …

oracle blob clob

"date" as a column name

I have a table called calendars. One of its columns is named 'date' When I want to select the date …

database oracle database-design ora-00904 ora-01747

How do I rename a table in Oracle so that all foreign keys, constraints, triggers and sequences are updated and any existing data is preserved?

I need to rename a table in Oracle but I want to be sure that any foreign keys, constraints, triggers …

oracle rename preserve

DB2 database in Oracle SQL developer

I've heard it's possible to connect to a mainframe DB2 database with a client like Oracle SQL developer. I've looked …

database oracle db2 mainframe oracle-sqldeveloper

Using a view with no primary key with Entity

I just started on a project converting an application from raw ADO.NET and embedded SQL to Entity. I ran …

sql oracle entity

CX_Oracle - import data from Oracle to Pandas dataframe

Hy, I'm new in python and I want import some data from a Oracle Database to python (pandas dataframe) using …

python oracle cx-oracle

Cannot call oracle stored procedure and function

Might be too simple question to ask, but I do need help. I am creating a stored procedure in Oracle 10…

oracle function stored-procedures oracle10g