When I want to get a sum of two numbers in mysql I can just use
select 10 + 15;
However, when I try the same in oracle sql i get the following error.
ORA-00923: FROM keyword not found where expected
What would be the correct way to sum two numbers?
oracle doesn't allow queries without a from clause. You could use the dual dummy table for such purposes:
SELECT 10 + 15 FROM dual;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With