user avatar
user avatar
user avatar
Kshitiz Sharma
  • Member for 9 years, 11 months
  • Last seen more than a month ago
134 votes
8 answers
88k views

How to properly format sqlite shell output?

60 votes
3 answers
570k views

How to make sqlplus output appear in one line?

42 votes
8 answers
338k views

How to see list of databases in Oracle?

10 votes
5 answers
29k views

Difference between inline view and WITH clause?

9 votes
3 answers
7k views

What actually is a SQL clause?

3 votes
2 answers
1k views

Explain output difference between this inner and natural join

3 votes
5 answers
2k views

Are there any in-memory hybrid databases available?

3 votes
1 answer
11k views

Why does Oracle store time in DATE column?

2 votes
2 answers
50 views

Select rows where smaller row does not exist

2 votes
3 answers
2k views

How to select data in a sub query only once?

2 votes
1 answer
186 views

How to aggregate datapoints in a table?

2 votes
1 answer
9k views

Mysql not closing connections

1 vote
1 answer
1k views

Why doesn't Oracle show my privileges?

1 vote
1 answer
3k views

How can I fix these broken synonyms?

1 vote
1 answer
468 views

What could be the possible reasons for cardinality estimates being very inaccurate in an execution plan?

1 vote
3 answers
21k views

How to get SQL for DDL commands in Sql developer?

1 vote
4 answers
42k views

How to find out why this query is in waiting state?

1 vote
1 answer
67 views

When would one want to use Oracle transparent data encryption

1 vote
1 answer
173 views

SQL Developer auto trace does not show cascading deletes

1 vote
1 answer
2k views

SP2-0584: EXIT variable was non-numeric error

0 votes
2 answers
6k views

How to export own objects using expdp without special privileges?

0 votes
0 answers
1k views

Sql developer how to copy to another tablespace [duplicate]

0 votes
1 answer
5k views

Define a column as MD5 sum of other columns in MySql

0 votes
1 answer
564 views

How to number SQL results sequentially?

0 votes
1 answer
88 views

How to increase the size of query audit log?

0 votes
2 answers
5k views

Why can I execute this query but not see its execution plan?

0 votes
1 answer
3k views

ORA-01722: The specified number was invalid when truncating timestamp

-1 votes
1 answer
488 views

ORA-01536: Out of space error when doing CTAS