Top "Oracle" questions

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

Is there something like "if not exist create sequence ..." in Oracle SQL?

For my application that uses an Oracle 8 DB, I am providing an SQL script to setup stuff like triggers, sequences …

sql oracle sequence
Copying data between Oracle schemas using SQL

I'm trying to copy data from one Oracle schema (CORE_DATA) into another (MY_DATA) using an INSERT INTO (...) SQL …

sql oracle insert oracle10g bulkinsert
(Oracle) How get total number of results when using a pagination query?

I am using Oracle 10g and the following paradigm to get a page of 15 results as a time (so that …

sql oracle oracle10g
Append to spool file Oracle

I have one script file called Test.sql in D:\Scripts folder and the content of the file is given …

sql oracle append sqlplus spool
ORA-12505 :TNS listener does not currently know of SID given in connect descriptor

I am using Oracle database. I've written a small JDBC connection program in Java but I am facing an issue …

java oracle jdbc listener tns
Oracle User defined type inside package definition

is it possible to have a User Defined Type inside Oracle package definition? When I try following CREATE OR REPLACE …

oracle stored-procedures plsql package user-defined-types
dbvisualizer: set max rows in a select query

I am using DBVisualizer 8.0.6 and when I run a simply query like.... select * from table It only shows the first 1000 …

sql database oracle dbvisualizer
Python module "cx_Oracle" module could not be found

I recently installed cx_Oracle module on my machine, in order to connect to a remote Oracle database server. (I …

python oracle module cx-oracle
cx_Oracle doesn't connect when using SID instead of service name on connection string

I have a connection string that looks like this con_str = "myuser/[email protected]:1521/ora1" Where ora1 …

python oracle python-2.7 cx-oracle
create synonym ora-01031 insufficient privileges

I need help understanding what grants/privileges a user needs to CREATE a SYNONYM when it points to another (different) …

oracle schema privileges grant synonym