Rachcha

Rachcha has asked 13 questions and find answers to 21 problems.

Stats

About

Cert CII, OCP PL/SQL Developer, B. E. From Mumbai University. Working as a software developer in insurance domain.

SOreadyToHelp

Rachcha questions

Why doesn't Oracle throw an "ambiguous column reference" here?
Distinct LISTAGG that is inside a subquery in the SELECT list
Inserting a child node in an XMLTYPE column
Stretch a row with data overflow while having multiple rows in a single band
How to add a not null constraint on column containing null values
How to run a more than 8000 characters SQL statement from a variable?

Rachcha answers

Merge statement array as source table
How do you select into a nested type in oracle pl/sql?
Boolean giving invalid datatype - Oracle
Searching and displaying results by relevance in Oracle
IN subquery's WHERE condition affects main query - Is this a feature or a bug?
when should I go for procedure or function in PL/SQL?
How to Delete Records NOT IN
Stretch a row with data overflow while having multiple rows in a single band
Select First Row of Every Group in sql [duplicate]
How does Subquery in select statement work in oracle