/pr/ - Programming

PL/SQL Issues Neckbearded Basement Dweller 18/11/27(Tue)08:09 No. 5160

File 154330259383.jpg - (455.74KB , 2539x1459 , 1445728771441.jpg )

Why the fuck wont this run? it runs fine when i put in a number for the interval but not when i put in left or right input. they should just be numbers so whats the big deal?

SET serveroutput ON

ACCEPT leftLimitInput NUMBER PROMPT "Please enter the leftLimit in minutes: ";
ACCEPT rightLimitInput NUMBER PROMPT "Please enter the rightLimit in minutes: ";

DECLARE
leftLimit NUMBER;
rightLimit NUMBER;
BEGIN
leftLimit := &leftLimitInput;
rightLimit := &rightLimitInput;
SELECT flightno, fromAirport, toAirport, (arrives-depart) AS flightDuration FROM flights WHERE (arrives-depart) >= INTERVAL 'leftLimitInput' MINUTE AND (arrives-depart) <= INTERVAL 'rightLimitInput' MINUTE;
END;
/

Neckbearded Basement Dweller 18/11/27(Tue)09:30 No. 5161

>>5160
also this select statement doesnt work and i dont know why that is either. im trying to get it to display stuff from within the last 61 days and this should do it but it isnt.

select BT, BP, AD, DATE_FORMAT(publDate, '%m/%d/%Y'), PN from auth, book, publ where (publDate BETWEEN NOW() - INTERVAL 61 DAY AND NOW())

Neckbearded Basement Dweller 18/11/27(Tue)15:41 No. 5162

>>5161
Just kidding about this select statement. It does work but there are no dates within the 61 days. That took me far too long to realize