Top "Oracle" questions

Splitting string into multiple rows in Oracle

I know this has been answered to some degree with PHP and MYSQL, but I was wondering if someone could …

sql string oracle plsql tokenize

How to get primary key column in Oracle?

I need to get the name of the primary key column. In the input, I only have the table name.

oracle

LISTAGG in Oracle to return distinct values

I am trying to use the LISTAGG function in Oracle. I would like to get only the distinct values for …

sql oracle aggregate-functions listagg

How can multiple rows be concatenated into one in Oracle without creating a stored procedure?

How can I achieve the following in oracle without creating a stored procedure? Data Set: question_id element_id 1 7 1 8 2 9 3 10 3 11 3 12 Desired …

sql oracle concatenation string-aggregation

Oracle SQL query for Date format

I always get confused with date format in ORACLE SQL query and spend minutes together to google, Can someone explain …

sql database oracle oracle11g

Search an Oracle database for tables with specific column names?

We have a large Oracle database with many tables. Is there a way I can query or search to find …

sql oracle

ORA-01653: unable to extend table by in tablespace ORA-06512

I tried to generate some test data by running the following sql. BEGIN FOR i IN 1..8180 LOOP insert into SPEEDTEST …

oracle tablespace

ORA-00932: inconsistent datatypes: expected - got CLOB

Considering that TEST_SCRIPT is a CLOB why when I run this simple query from SQL*PLUS on Oracle, I …

oracle clob

Difference between a user and a schema in Oracle?

What is the difference between a user and a schema in Oracle?

oracle

Oracle ORA-12154: TNS: Could not resolve service name Error?

I am a SQL Server user . I am on a project that is using oracle (which I rarely use) I …

oracle odbc tns