Bazı SQL sorguları

SELECT TO_CHAR(SYSDATE,'MM/DD/YYYY HH:MM:SS AM') FROM dual

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;

DECLARE
 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;
/

create or replace procedure for_ekle_proc as
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