Mehmet Ozdemir Ce

select TRUNC(sysdate) from dual SELECT TO_CHAR(CURRENT_DATE, 'HH:MI:SS' ) FROM DUAL ; SELECT TO_CHAR(CURRENT_DATE, 'HH:MI:SS' ) FROM DUAL ; -- Sistem saati -- Sistem tarihi alma Number i Char a cevirir -------------->>> TO_CHAR(123) PLSQL TOAD da Yeni bir Package Oluşturmak için Spack ve Body Oluşturulmalı        -- Yeni Package Spack oluşturmak            CREATE OR REPLACE PACKAGE PackageName IS             END PackageName;  --Package Specification             /    -- Yeni Package Body oluşturmak          CREATE OR REPLACE PACKAGE BODY PackageName  IS          END PackageName ;  --Package Body        /

SELECT * FROM TableName WHERE calx = valx; SELECT col1,col2,col3 INTO val1,val2,val3 FROM TableName WHERE calx = valx; INSERT INTO TableName (col1, col2, col3) VALUES (val1, val2, val3 ); DELETE FROM TableName WHERE colx=valx; UPDATE TableName SET col1= val1*val2 WHERE colx = (SELECT colx FROM TableNamex WHERE coly=valy)

SELECT TO_CHAR(SYSDATE, 'YYYY.MM.DD' ) FROM DUAL DUAL die bir tablo yok dummy bişey PL SQL de  Tablo kullanmadan işlem yapmak gerekebilir

PROCEDURE exampleUseCursor(parameter1 IN VARCAR2, parameter2  OUT VARCAR2, parameter3  OUT VARCAR2) cursor cursorName(parameter VARCHAR2) is         Select * FROM tableName         WHERE col1 = parameter AND col2='xx';              cursorRow cursorName%ROWTYPE; BEGIN   -- .......   -- ....... pen cursorName(parameterX);                             LOOP                             fetch cursorName into cursorRow;                 exit when cursorName %notfound;      ...