Skip to content

Instantly share code, notes, and snippets.

@alexanderjsingleton
Last active February 24, 2016 16:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexanderjsingleton/af94ff115daf32ce669b to your computer and use it in GitHub Desktop.
Save alexanderjsingleton/af94ff115daf32ce669b to your computer and use it in GitHub Desktop.
In case you needed SQL for a quadratic-equation solver.
ALTER SESSION
SET NLS_NUMERIC_CHARACTERS='. ';
SELECT 'Not a quadratic equation.' AS "Answer 1", '0' AS "Answer 2"
FROM dual
WHERE &&A = 0
UNION
SELECT 'x = ' || to_char(-&&B/2/&A) AS "Answer 1", '0' AS "Answer 2"
FROM dual
WHERE &A != 0
AND &B*&B-4*&A*&&C = 0
UNION
SELECT 'x1 = ' || to_char((-&B+sqrt(&B*&B-4*&A*&C))/2/&A) AS "Answer 1", 'x2 = ' || to_char(-&B-sqrt(&B*&B-4*&A*&C))/2/&A AS "Answer 2"
FROM dual
WHERE &A != 0
AND &B*&B-4*&A*&C > 0
UNION
SELECT 'x1 = (' || to_char(-&B/2/&A) || ',' || to_char(sqrt(-&B*&B+4*&A*&C)/2/&A) || '), ' AS "Answer 1", 'x2 = (' || to_char(-&B/2/&A) || ',' || to_char(-sqrt(-&B*&B+4*&A*&C)/2/&A) || ')' AS "Answer 2"
FROM dual
WHERE &A != 0
AND &B*&B-4*&A*&C < 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment