Top "Oracle" questions

Get table name by constraint name

Oracle constraint name is known. How do I find the name of the table for which this constraint is applied?

oracle constraints

How can I kill all sessions connecting to my oracle database?

I need to quickly (and forcibly) kill off all external sessions connecting to my oracle database without the supervision of …

oracle session sqlplus kill database-administration

How to increase dbms_output buffer?

I tried to debug my dynamic query via dbms_output but seems like the query string is too long for …

sql oracle plsql oracle10g dbms-output

Disable and later enable all table indexes in Oracle

How would I disable and later enable all indexes in a given schema/database in Oracle? Note: This is to …

sql oracle sql-loader

What is it exactly a BLOB in a DBMS context

What is it a BLOB? How can I use it? What are the differences between DBMS's BLOBs. I would like …

sql oracle blob database blobstore

ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)

When I have a sql statement like select * from table1, it works great, but as soon as I put it …

sql oracle oracle9i ora-00942

Oracle Convert Seconds to Hours:Minutes:Seconds

I have a requirement to display user available time in Hours:Minutes:Seconds format from a given total number of …

sql oracle plsql plsqldeveloper

Get column value length, not column max length of value

How do I get actual length of value in column? My (oracle) sql command returns maximum length of value that …

oracle string-length

Could not load file or assembly for Oracle.DataAccess in .NET

When I try to run a simple program to access oracle I am getting this message Could not load file …

.net oracle assemblies

Search for a particular string in Oracle clob column

How to get a particular string from a clob column? I have data as below which is stored in clob …

sql oracle oracle10g clob