Tag: oracle

My query is Select class_time from tableA which produces: 0200AM 0230AM 0300AM 0330AM 0400AM i want above result as 0200AM 0230AM 0300AM 0330AM 0400AM 0430AM

I am interested in SQL query not the PLSQL code. We need to assign the rank based on date and id value Input table should look like below output table should look like below Answer This is a type of gaps-and-islands problem. In this case, the simplest solution is probably the difference of row numbers: Why th…

i have problem with partitioning the process data i have from our workflow system. data are stored in database step after step (one step is one row) for couple of processes (id) and a date of the event. in simplified data is looks as follows: what i need to have is such short table the “x” step is…

I have this query which gives me this output its fine except for .000000000 part. I dont need that part, and im not sure how its coming up if its HH:MI:SS format this is for oracle sql developer. Answer Why not just convert to a date? That datatype doesn’t have fractions of a second:

i have this table: How do I fetch a list of Persons who have the same dob and exactly 100 years older or younger? Expected rows: The difference between dob should be 100 years Answer If the DOB is a date data type, would suggest using TRUNC and ADD_MONTHS.

In this query, in the ODF_CA_NL_INIT_REQ_NOTE n table, there can be multiple NL_NOTEs per each record in the ODF_CA_OTHER o table. One to many relationship. I want to select the n.NL_NOTE for each …