Top "Oracle" questions

ORA-12543: TNS:destination host unreachable but telnet and tnsping works

Last days i stay face to face with a strange oracle problem. I have defined database in tnsnames.ora. Oracle …

oracle sqlplus telnet tnsnames

extract a substring from clob in oracle

I have a clob with data <?xml version='1.0' encoding='UTF-8'?><root available-locales="en_US" …

oracle substring database clob

hibernate oracle sequence produces large gap

I am using hibernate 3 , oracle 10g. I have a table: subject. The definition is here CREATE TABLE SUBJECT ( SUBJECT_ID …

oracle hibernate sequence gaps-in-data

Max column width in Oracle spool to file

I have a script like this: SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET TERMOUT …

oracle sqlplus oracle-xml-db-repository

How to connect to an Oracle database Connection from .Net Core

Within a .netCore library I want to connect to an Oracle database. Is there any way I can do that …

c# oracle asp.net-core database-connection

Making a sha1-hash of a row in Oracle

I'm having a problem with making a sha1-hash of a row in a select on an Oracle database. I've …

oracle hash sha1

Oracle SQL - Sum and group data by week

I have records related to dates: DATE AMOUNT 16.03.2013 3 16.03.2013 4 16.03.2013 1 16.03.2013 3 17.03.2013 4 17.03.2014 3 I know how to sum them up for each day, but how …

sql oracle aggregate-functions

ORA-00600: internal error code, arguments: [4194], [65], [51]

I have issue on Oracle. When I execute startup to open database there is error in alert log that ORA-00600: …

oracle oracle-xe ora-00600

How can you tell if a PL/SQL Package, Procedure, or Function is being used?

How can you tell if a PL/SQL Package, Procedure, or Function is being used? Is there an Oracle table …

oracle plsql statistics dead-code

How to add a not null constraint on column containing null values

I have a table with a column that contains a few null values. I want to add a NOT NULL …

sql oracle plsql oracle11g constraints