I have a question about using count in an Intersect Statement. I want to
get the total count of the following SQL Statement: How would I do this?
SELECT
nvl((c.sr_num),0)),
FROM
s_evt_act a,
s_srv_req c
WHERE
a.sra_sr_id = c.row_id and
a.priv_flg = 'N' and
a.x_cp_created between
Can someone look at this at see what I am doing wrong:
The following SQL returns to records:
50
333
select SC_USER_ID as parmSecurename from CP_USER_COMMENT where SC_ID =
107793;
If I include it in the following loop the result is
50
333
333
CREATE OR REPLACE Procedure SP_USER_COMMENT_2
as
Does anyone know of any good PL SQL Oracle Lists?
thank you in advance
Lance
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Does anyone know of any good PL SQL Oracle Lists?
thank you in advance
Lance
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
I am using the following statement in Oracle 8.0.6 and getting an error I
and I do not understand why it is giving it to me.
CODE:
CREATE OR REPLACE procedure primus_temp_dump_test(in_tab_name in varchar2)
as
cursor_id integer;
execute_return_value integer;
last_function_code integer;
Begin
Why when I use the following SQL it get a
ORA-00937: not a single-group group function
What could I be doing wrong?
I am only trying to group on Time_stamp.
Thank you in advance
SELECT
ROUND(AVG(COUNT(Time_stamp))),
MIN(COUNT(time_stamp)),
MAX(COUNT(time_stamp)),