Question : My data is like: keycol,col1,col2,col3 1,a;b;c,some data,some other data 2,x,some data,some other data 3,y;z,some data,some other data Where […]
Tag: oracle-10g
Supporting Multiple Oracle Clients
Question : I have an application where the data repository is moving to Oracle 11g. This means we need the […]
Export synonyms content to tables
Question : I have a distant database to replicate having huge data but I have access only to synonyms and […]
Cannot fix ERROR:ORA-01031: insufficient privileges
Question : I have tried almost every solution on the internet however I still cannot fix this problem. I cannot […]
Separate indices for the field I want to get the MAX() and the ones in the WHERE clause
Question : My customer’s database has a gigantic table (hundreds of millions of records) and a SELECT that, by cumulative […]
Indexing for query using CASE for join
Question : I’m trying to optimize a query on Oracle 10g (I know!), and I have a 4 column table […]
Object changed during datapump
Question : If some object is being changed when data pump is run how will that object go into datapump […]
How to query Last inserted row for each group in oracle 10
Question : I have two tables about users where I want to join two tables and show the latest remarks […]
SQL substitution feature in Oracle 10g
Question : Three or four years ago I read in an Oracle blog somewhere that a DBA had used for […]
how to obtain the functionality of LISTAGG function in Oracle 10g?
Question : I need to put output of a query in single line so that I can create a single […]