User MT0 - Stack Overflow

59 votes

Accepted

Have max. 2 decimal places

answered Aug 26, 2015 at 14:47

42 votes

Accepted

How to convert XMLTYPE in VARCHAR in ORACLE?

answered Jan 27, 2016 at 14:22

38 votes

How to implement the Java comparable interface?

answered Feb 7, 2014 at 11:30

36 votes

Accepted

check if clob contains string oracle

answered May 17, 2017 at 12:38

36 votes

PARTITION BY with and without KEEP in Oracle

answered Nov 23, 2013 at 0:48

27 votes

Accepted

oracle sql - select statement with multiple "case when" and check for contains text

answered Jul 11, 2016 at 8:30

27 votes

Accepted

Explanation of KEEP in Oracle FIRST/LAST

answered Jan 24, 2021 at 9:01

26 votes

Oracle's default DATE format

answered May 3, 2018 at 21:41

26 votes

Accepted

Detect repeating letter in an string in Javascript

answered Dec 11, 2013 at 7:45

22 votes

Accepted

Oracle subtracting days and minutes

answered May 11, 2017 at 8:58

18 votes

how to select even records from a table in oracle?

answered Nov 16, 2013 at 13:31

18 votes

Accepted

Return all possible combinations of values within a single column in SQL

answered Jun 26, 2015 at 10:13

17 votes

Accepted

Oracle how to convert time in UTC to the local time (offset information is missing)

answered Jul 13, 2016 at 8:44

17 votes

Accepted

Tree structure in sql in Oracle.How to show tree,child nodes and parent nodes in SQL Oracle

answered May 10, 2016 at 9:45

15 votes

Accepted

Remove first characters of string in Oracle Server

answered Jan 20, 2016 at 0:58

14 votes

Extract month and year from date in oracle

answered Sep 7, 2017 at 11:58

13 votes

Date format in where clause-Oracle

answered May 12, 2016 at 8:39

12 votes

Listagg Partition instead of Group By

answered May 15, 2018 at 9:38

12 votes

Accepted

List all tables of a given user in Oracle

answered Jul 12, 2016 at 12:01

12 votes

Accepted

How to convert timestamp with milliseconds to date in Oracle

answered Mar 28, 2017 at 10:18

12 votes

Compare Strings ignoring accents in SQL (ORACLE)

answered Feb 28, 2016 at 23:13

12 votes

How to create day start and end date in PL SQL

answered Sep 8, 2015 at 10:40

11 votes

Accepted

Getting last value of a grouped result - Oracle SQL

answered Nov 21, 2017 at 14:31

11 votes

Accepted

How to get a date at midnight

answered May 3, 2017 at 8:16

11 votes

Accepted

Oracle: How to find date of last Friday of the month

answered Jun 7, 2017 at 8:51

11 votes

Accepted

Modified ROUND UP function in Oracle

answered Jun 22, 2017 at 12:43

11 votes

Convert from date to epoch-Oracle

answered Jun 27, 2016 at 13:28

11 votes

Accepted

how to do a function to return row type from a table in pl/sql?

answered Apr 8, 2016 at 0:53

10 votes

Oracle - Converting SDO_GEOMETRY to WKT?

answered Jun 29, 2017 at 21:36

10 votes

Accepted

Oracle 23c ROUND with DATE data type

answered Dec 1, 2023 at 10:08

Collectives™ on Stack Overflow

8,722 Answers

Have max. 2 decimal places

How to convert XMLTYPE in VARCHAR in ORACLE?

How to implement the Java comparable interface?

check if clob contains string oracle

PARTITION BY with and without KEEP in Oracle

oracle sql - select statement with multiple "case when" and check for contains text

Explanation of KEEP in Oracle FIRST/LAST

Oracle's default DATE format

Detect repeating letter in an string in Javascript

Oracle subtracting days and minutes

how to select even records from a table in oracle?

Return all possible combinations of values within a single column in SQL

Oracle how to convert time in UTC to the local time (offset information is missing)

Tree structure in sql in Oracle.How to show tree,child nodes and parent nodes in SQL Oracle

Remove first characters of string in Oracle Server

Extract month and year from date in oracle

Date format in where clause-Oracle

Listagg Partition instead of Group By

List all tables of a given user in Oracle

How to convert timestamp with milliseconds to date in Oracle

Compare Strings ignoring accents in SQL (ORACLE)

How to create day start and end date in PL SQL

Getting last value of a grouped result - Oracle SQL

How to get a date at midnight

Oracle: How to find date of last Friday of the month

Modified ROUND UP function in Oracle

Convert from date to epoch-Oracle

how to do a function to return row type from a table in pl/sql?

Oracle - Converting SDO_GEOMETRY to WKT?

Oracle 23c ROUND with DATE data type