Ken Watts
Last Activity: Sep 4 '07, 06:27 PM
Joined: Jun 22 '07
Location:
-
Sorry, different query but same issue. -
Did I do this correctly?
create or replace
PROCEDURE SKELETON
aS
s_ERR VARCHAR2(500);
STR LONG;
BEGIN
STR := '
CREATE TABLE ken_blah AS
SELECT sbscrp_id,
MONTH,
rankm,
cnt,
1 +
(SELECT COUNT(*)
FROM ken_test temp
WHERE temp.rankm < ken_test.rankm
AND temp.sbscrp_id = ken_test.sbscrp _id
AND...Leave a comment:
-
I do not get an error. It simply does not create the table with the data. yes I have create table priviledges. Thanks...Leave a comment:
-
Create Table In Oracle Procedures
Hello, I am new to all of this. I have basic SQL skills. I am trying to create a table using a procedure in Oracle Developer but I can't seem to get the table to create. I get no errors.
create or replace
PROCEDURE SKELETON2
Is
str long;
s_ERR VARCHAR2(500);
BEGIN
STR := 'CREATE TABLE ken_blah2 AS
SELECT sbscrp_id,
MONTH
FROM ken_test
where rownum <...
No activity results to display
Leave a comment: