Recursive select does not return date list [closed]

117
January 25, 2021, at 08:40 AM
Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? Add details and clarify the problem by editing this post.

Closed yesterday.

Improve this question

I've trying to made a SELECT returns a date list from a table, starting from a date and bringing previous dates to it, that contains a start date and a number to limit the requests.

SELECT sysdate - rownum 
FROM table_01 
WHERE rownum < 50;
SELECT start_date - rownum 
FROM table_01 
WHERE date_ = 'DATA_FINAL'AND rownum < date_limit;

The first select is a functional sample of what I'm trying to do with the second select, using the table columns.

Table I'm using

Answer 1

I suspect you want a "tally" table and join to generate multiple rows for each row in the original data:

with numbers as (
      select rownum as n
      from table_01
      where rownum < 50
     )
select t1.start_date - n 
from table_01 t1 join
     numbers n
     on n.n < t1.date_limit
where t1.date_ = 'DATA_FINAL';
READ ALSO
Cannot publish new release to Google Play because of Sensitive app permissions

Cannot publish new release to Google Play because of Sensitive app permissions

The problem I'm facing is that I cannot create any new releases on any of the Google Play release tracks (internal, alpha, beta, production) since one of the old releases required location permissons

90
Convert datatime column to 18-digit LDAP timestamp

Convert datatime column to 18-digit LDAP timestamp

I have a csv file with AD users and their accountExpires attributeThe accountExpires values are currently in human readable format, but I want to convert it into 18-digit LDAP format so that I can import the file to change the date

118
cant get data from form to server - MERN

cant get data from form to server - MERN

im new and i cant get data from the form in server to insert it in the DB, heres the code:

114
How to store and deal with big chuncks of text between Javascript and HTML

How to store and deal with big chuncks of text between Javascript and HTML

So , I'm using HTML , css and JavaScript, I did a form , where the user will give different data, like name , adress , ID number , etc and I want to introduce those values into a preformatted text (like a renting contract)

79