begin
EXECUTE IMMEDIATE 'CREATE TABLE X(A DATE)';
end;
begin execute Immediate 'TRUNCATE TABLE emp'; end;
DECLARE
var VARCHAR2(100);
BEGIN
var := 'CREATE TABLE temp1(col1 NUMBER(2))';
EXECUTE IMMEDIATE var;
END;
DECLAREcreate or replace procedure for_ekle_proc as
CURSOR dept_cur IS
SELECT deptno
FROM dept
ORDER BY deptno;
-- Employee cursor all employees for a dept number
CURSOR emp_cur (v_dept_no DEPT.DEPTNO%TYPE) IS
SELECT ename
FROM emp
WHERE deptno = v_dept_no;
BEGIN
FOR dept_rec IN dept_cur LOOP
dbms_output.put_line('Employees in Department '||TO_CHAR(dept_rec.deptno));
FOR emp_rec in emp_cur(dept_rec.deptno) LOOP
dbms_output.put_line('...Employee is '||emp_rec.ename);
END LOOP;
END LOOP;
END;
/
sql_string varchar2(100);
begin
for i in 1..10 loop
--sql_string :='select * from dual';
sql_string := 'insert into for_table (job_id)values ('||i||')';
execute immediate sql_string;
dbms_output.put_line(sql_string);
end loop;
end;
/
--execute immediate 'insert into mytable values ( '||i||')';
join'lemeler ile ilgli birkaç örnek
http://cagrikilit.blogspot.com/2009/03/tamam-alntdr.html
No comments:
Post a Comment