var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to put the result of a query into a variable??
DEFINE invoice_count = SELECT COUNT(Invoice#) from INVOICE NUMBER;
This doesnt work. What's the correct syntax or method for doing this in SQL*Plus?
you have to use a sql*plus variable.
-- Declare the variable INVOICE_COUNT as number
variable invoice_count number
-- fill the variable in a anonym-plsql-block
from INVOICE NUMBER;
-- now you can output the Value
-- or us it in a subsequence select
select * from test_table where column1=:invoice_count;