All Questions
2 questions
3
votes
2
answers
8k
views
SQLPLUS: SELECT INTO prompting for variable value
Any idea why this is prompting me for the value? I'm calling the script via batch file:
DECLARE
precount NUMBER;
nowcount NUMBER;
BEGIN
SELECT COUNT(*) INTO precount FROM ...
- 185
3
votes
1
answer
9k
views
Simple Oracle query hangs depending on WHERE clause
Not used to using Oracle, but we have a large database where a non-unique query like
SELECT * FROM employees where department = 'HR'
is working, results list up no problem.
But when I do
SELECT ...
- 617