Top "Oracle" questions

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

Display names of all constraints for a table in Oracle SQL

I have defined a name for each of the constraint for the multiple tables that I have created in Oracle …

sql oracle oracle11g constraints
Removing duplicate rows from table in Oracle

I'm testing something in Oracle and populated a table with some sample data, but in the process I accidentally loaded …

sql oracle duplicates delete-row
How do I get textual contents from BLOB in Oracle SQL

I am trying to see from an SQL console what is inside an Oracle BLOB. I know it contains a …

sql oracle blob
Oracle DateTime in Where Clause?

I have sql something like this: SELECT EMP_NAME, DEPT FROM EMPLOYEE WHERE TIME_CREATED >= TO_DATE('26/JAN/2011…

sql oracle time date-arithmetic
How to uninstall / completely remove Oracle 11g (client)?

How to uninstall / completely remove Oracle 11g (client)? deinstall.bat doesn't work. Edit: Further discussion related to why this question …

oracle oracle11g
Oracle client ORA-12541: TNS:no listener

I am new on Oracle database, but I have one issue. On my Database server (server1) listener and database instance …

oracle listener
How can I set a custom date time format in Oracle SQL Developer?

By default, Oracle SQL developer displays date values as 15-NOV-11. I would like to see the time part (hour/minute/…

oracle oracle-sqldeveloper
Oracle's default date format is YYYY-MM-DD, WHY?

Oracle's default date format is YYYY-MM-DD. Which means if I do: select some_date from some_table ...I lose the …

oracle date-formatting
Oracle: how to UPSERT (update or insert into a table?)

The UPSERT operation either updates or inserts a row in a table, depending if the table already has a row …

sql oracle merge upsert
Search All Fields In All Tables For A Specific Value (Oracle)

Is it possible to search every field of every table for a particular value in Oracle? There are hundreds of …

sql oracle search plsql database-table