Top "Oracle" questions

Removing Locks in Oracle 10

I have an issue when trying to update a column value in sqlplus. It basically wont complete and just hangs. …

sql oracle sqlplus

How can I describe a table in Oracle without using the DESCRIBE command?

I'm having a hard time with a class I am taking. We need to write an Oracle script that will …

oracle oracle11g sql-scripts data-dictionary

DBMS_SCHEDULER.DROP_JOB only if exists

I have a sql script that I must run after I import a dump. among other things the script does, …

oracle oracle11g dbms-scheduler

How do I use Group By based on a Case statement in Oracle?

I have an SQL-query where I use Oracle CASE to compare if a date column is less than or greater …

sql oracle group-by case

Difference between Oracle's plus (+) notation and ansi JOIN notation?

What's the difference between using oracle's plus notation (+) over the ansi standard join notation? Is there a difference in performance? …

sql performance oracle join

How to clear all cached items in Oracle

I'm tuning SQL queries on an Oracle database. I want to ensure that all cached items are cleared before running …

sql oracle caching oracle10g

How can I check the last time stats was run on Oracle without using OEM

I want to check the last time stats was run on my Oracle 10g server. I would normally do this …

oracle oracle10g sqlplus statistics

Remove Column Header into the Output Text file

I want to create a flat file (text file) of my query from Oracle SQL Developer. I have successfully created …

oracle oracle-sqldeveloper sqlplus spool columnheader

How to get Oracle create table statement in SQL*Plus

I have a table that exists in an Oracle database, but doesn't show on my list of tables in the …

sql oracle sqlplus

Syntax error: missing expression (ORA-00936)

I have 2 tables, Facilities and Services. CREATE TABLE Facilities ( facility_id NUMBER(2) NOT NULL, facility_name VARCHAR2(20) NOT NULL, CONSTRAINT …

sql oracle database-design foreign-keys ora-00936