Top "Oracle" questions

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

How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, …

sql oracle toad
How to create a oracle sql script spool file

I have a question about spooling the the results of my program. My sample sql script looks like this. whenever …

oracle plsql sql-scripts spool
Resolving ORA-4031 "unable to allocate x bytes of shared memory"

I need some pointers on how to diagnose and fix this problem. I don't know if this is a simple …

oracle memory-management oracle10g
ORA-01882: timezone region not found

I'm accessing an Oracle Database from a java application, when I run my application I get the following error: java.…

oracle jdbc timezone
Can we have multiple "WITH AS" in single sql - Oracle SQL

I had a very simple question: Does oracle allow multiple "WITH AS" in a single sql statement. Example: WITH abc …

sql oracle
Liquibase lock - reasons?

I get this when running a lot of liquibase-scripts against a Oracle-server. SomeComputer is me. Waiting for changelog lock.... Waiting …

database oracle liquibase
Alter table to modify default value of column

I have a requirement where we need to modify a column's default value in database table. The table is already …

sql oracle alter-table
how to modify an existing check constraint?

Is there any way to modify an existing check constraint on a table other than dropping and re-creating it? create …

oracle ora-00933
How to avoid variable substitution in Oracle SQL Developer with 'trinidad & tobago'

When I try to execute this statement in Oracle SQL Developer 2.1 a dialog box "Enter Substitution Variable" pops up asking …

oracle oracle-sqldeveloper
How do I ignore ampersands in a SQL script running from SQL Plus?

I have a SQL script that creates a package with a comment containing an ampersand (&). When I run the …

sql oracle sqlplus