Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

"error: cannot locate an Oracle software installation" When trying to install cx_Oracle

Newbie here trying to use python to do some database analysis. I keep getting the error: "error: cannot locate an …

python oracle cx-oracle
use of bind variable

Can we use a bind variable in oracle inside a procedure or function ? I'm trying to update a bind variable …

oracle bind-variables
basic MERGE into same table

What I am trying to do is insert/update different versions into a product table. This is a PL/SQL …

sql oracle sql-merge
True tablespace size in oracle

I need to know true tablespace size in Oracle. I have some tablespace and I need to know how many …

sql oracle space tablespace
Difference between table access by index rowid BATCHED and table access by index rowid

I'm using EXPLAIN PLAN in oracle database on a simple SELECT statement just to find out how it works. In …

oracle sql-execution-plan
While inserting multiple rows what does the statement 'select 1 from dual' do?

While inserting multiple rows into a table using the following style : insert all into ghazal_current (GhazalName,Rating) values('Ajab …

sql oracle oracle11g multiple-insert
What's the difference between the Oracle SYS and SYSTEM accounts?

What are the differences between the Oracle SYS and SYSTEM built in accounts? Edit: Apart from 3 letters!

oracle administration database-administration
how can I use "impdp" command importing .dmp data with port number?

I am trying to import data to an Oracle database. I have ".imp" and ".dmp" files for importing data. The …

oracle connection listener tnsnames
How to get information about a User-Defined Type?

In simplicity, PL/SQL generally follow the following: DECLARE Variable declaration BEGIN Program Execution EXCEPTION Exception handling END; I am …

oracle variables plsql user-defined-types
ORA-32795: cannot insert into a generated always identity column

Guys I am trying to execute below insert statement and I keep getting the error: cannot insert into a generated …

sql oracle oracle12c identity-column