Top "Oracle" questions

How do I get Oracle, see what procedures are running?

Good afternoon. How do I get Oracle, see what procedures are running?

oracle procedures

Query my block size oracle

Is there a way I can tell the block size of my Oracle database if I don't have access to …

oracle storage admin

How to use to_char function functionality in MySQL

I have a table tine_by_day and I know how to use TO_CHAR function in oracle, but how …

mysql sql oracle mysql-workbench sqlyog

How to extract ddl for oracle db links?

Is there anyway to extract ddl for all database links? I would like to get in sql and recreate them …

oracle oracle11gr2 dblink

Executing stored procedure in PL/SQL Developer SQL Window

I've used TOAD for awhile, but my dept has asked me to evaluate PL/SQL Developer as a possible change. …

oracle exec procedure plsqldeveloper ora-00900

ORA-12154: TNS:could not resolve the connect identifier specified

The issue started when i installed the server version with already existing client version of Oracle 10g. Background : The Oracle …

oracle oracle10g database-connection ora-12154

LISTAGG function with two columns

I have one table like this (report) -------------------------------------------------- | user_id | Department | Position | Record_id | -------------------------------------------------- | 1 | Science | Professor | 1001 | | 1 | Maths | | 1002 | | 1 | History | Teacher | 1003 | | 2 | …

oracle plsql oracle11g plsqldeveloper

oracle 12c - select string after last occurrence of a character

I have below string: ThisSentence.ShouldBe.SplitAfterLastPeriod.Sentence So I want to select Sentence since it is the string after …

sql string oracle oracle12c

What date format does Oracle/Toad expect?

In the Toad editor, I've got this SQL: SELECT INTERLOPERABCID,AVAILABLEDATE, AVAILABLEQHR,CARPHONEID, TRUNC((AVAILABLEQHR-1)/12) "COL", MOD(AVAILABLEQHR-1,12) "ROW" FROM …

sql oracle date toad

Oracle - drop table constraints without dropping tables

I'm doing some bulk migration of a large Oracle database. The first step of this involves renaming a whole load …

sql oracle constraints rename table-rename