Writing Something

var deviceIphone = "iphone";
var deviceIpod = "ipod";
var deviceS60 = "series60";
var deviceSymbian = "symbian";
var deviceAndroid = "android";
var deviceWinMob = "windows ce";
 
var uagent = navigator.userAgent.toLowerCase();
 
function DetectMobile() {
    if (uagent.search(deviceIphone) > -1
        || uagent.search(deviceIpod) > -1
        || uagent.search(deviceS60) > -1
        || uagent.search(deviceSymbian) > -1
        || uagent.search(deviceWinMob) > -1
        || uagent.search(deviceAndroid) > -1)
        return true;
    else
        return false;
}
 
if (DetectMobile()) {
    alert("mobile browserdan bir ziyaret...");
}

CREATE VIEW vwsal AS
SELECT last_name lname,
     department_id deptid,
     salary sal
FROM employees
WHERE department_id = 50;
 
SELECT *
FROM vwsal;
 
UPDATE vwsal
SET sal = sal + 10;
 
CREATE OR REPLACE VIEW vwsal AS
SELECT last_name lname,
     department_id deptid,
     salary sal
FROM employees
WHERE department_id = 60;
 
CREATE OR REPLACE VIEW vwsal AS
SELECT last_name lname,
     department_id deptid,
     salary sal
FROM employees
WHERE department_id = 20 WITH CHECK OPTION;
--WITH CHECK OPTION where şartındaki kolonun değiştirlimemesini kontrol ediyo
 
CREATE OR REPLACE VIEW vwsal AS
SELECT last_name lname,
     department_id deptid,
     salary sal
FROM employees
WHERE department_id = 20 WITH READ ONLY;
--WITH READ ONLY sadece select için bir view
--raporlar genelde bu şekilde oluşturulur
 
 
DROP VIEW vwsal;
 
CREATE sequence dept_seq increment 
BY 10 START WITH 120 maxvalue 9999 nocache nocycle;
 
CREATE sequence dept_seq increment 
BY 10 START WITH 120 maxvalue 9999 cache 50 nocycle;
 
CREATE sequence seq;
 
INSERT
INTO departments
VALUES(seq.NEXTVAL,      'deneme',      100,      1000);
 
SELECT seq.currval
FROM dual;
 
 
CREATE synonym em FOR employees;
--tabloya nickname verdik
 
SELECT * FROM em;
 
 
CREATE INDEX dept_name ON dept(name);
 
 
SELECT * FROM dictionary;
SELECT * FROM dict;
 
 
--kullanıcı yaratmak
CREATE user serdar IDENTIFIED BY sr
 
 
--session hakkı vermek
GRANT CREATE session TO serdar;
 
 
--select hakkı vermek
GRANT SELECT ON hr.employees TO serdar;
 
 
--kendi şemasında tablo oluşturma hakkı
GRANT CREATE TABLE TO serdar;
 
--tüm şemalarda tablo oluşturma hakkı
GRANT CREATE any TABLE TO serdar;
 
--user kiilitlemek
ALTER user serdar account LOCK;
 
--user kilitlenmişse açmak
ALTER user serdar IDENTIFIED BY sr account UNLOCK;
 
 
GRANT CREATE session, CREATE TABLE, CREATE sequence, CREATE VIEW TO demo;
 
 
--rol yaratmak
CREATE role rol;
 
--role hak vermek
GRANT CREATE session, CREATE TABLE, CREATE sequence TO rol;
 
--user a rol vermek
GRANT rol TO serdar;
 
 
--sifre değiştirmek
ALTER user serdar IDENTIFIED BY '123';
 
 
--verdiğim yetkiyi dağıtabilir şekilde ver, with grant option
GRANT SELECT ON employees TO serdar WITH GRANT OPTION;
 
 
--herkese yetki ver, to public
GRANT SELECT ON alice.departments TO public
 
 
--hak almak
REVOKE SELECT,INSERT ON departments FROM serdar cascade constraints;
--casced daha önce bu haklardan dağıtmışsa onlarıda alır...
 
--kolon ekle
ALTER TABLE employees ADD(kolon varchar2(20));
 
--kolon değiştir
ALTER TABLE employees MODIFY(kolon varchar2(30));
 
--kolon sil
ALTER TABLE employees DROP(kolon);
 
--kolonu kullanılamaz yapmak
ALTER TABLE employees
SET unused(salary);
--çok data olan bir kolon drop edildiğinde 2-3 dakika sürebilir
--unused anında kolonu kullanılamaz yapar
--kolon datası hala arkaplanda duruyordur ama getirilemez
--ikinci adımda drop ederek arkaplandanda sileriz
 
--constraint eklemek
ALTER TABLE emp2
ADD constraint emp_mgr_fk
FOREIGN KEY(manager_id)
REFERENCES emp2(employee_id);
 
ALTER TABLE emp2 MODIFY employee_id PRIMARY KEY;
 
ALTER TABLE emp2 MODIFY employee_id PRIMARY KEY deferrable initially deferred;
 
ALTER session
SET constraints = immediate;
 
ALTER TABLE dept2
DROP PRIMARY KEY cascade;
 
ALTER TABLE emp2
disable constraint emp_dt_fk;
 
ALTER TABLE emp2
enable constraint emp_dt_fk;
 
ALTER TABLE emp2
DROP COLUMN employee_id cascade constraints;
 
ALTER TABLE emp2
RENAME COLUMN employee_id TO eid;
 
ALTER TABLE emp2
RENAME constraint mktg_pk TO newmktg_pk;

commit;
 
INSERT
UPDATE
CREATE --create anında auto commit olur
DELETE
 
rollback; --create cümlesinin sonrasına dönebiliriz...
 
 
--for update, select ile gelen kolonları kilitliyor...
SELECT employee_id,
 salary,
 job_id
FROM employees
WHERE job_id = 'SA_REP'
FOR UPDATE
ORDER BY employee_id;
 
CREATE TABLE my_employee(
id NUMBER(4) NOT NULL,
last_name VARCHAR2(25),
first_name VARCHAR2(25),
userid VARCHAR2(8),
salary NUMBER(9,   2));
 
DESC my_employee;
 
INSERT INTO my_employee VALUES (1,'Patel','Ralph','rpatel',895);
 
INSERT INTO my_employee (id,last_name,first_name,userid,salary) VALUES
(2,'Dancs','Betty','bdancs',860);
 
INSERT INTO my_employee (id,last_name,first_name,userid,salary) VALUES
(&id,'&last_name','&first_name','&userid',&salary);
 
commit;
 
SELECT * FROM my_employee;
 
UPDATE my_employee
SET last_name ='Drexler'
WHERE id=3;
 
UPDATE my_employee
SET salary = 1000
WHERE salary<900;
 
SELECT * FROM my_employee;
 
DELETE FROM my_employee WHERE last_name='Dancs' AND first_name='Betty';
 
DELETE FROM my_employee
WHERE rowid='AAARW6AAEAAAAGPAAE';
 
commit;
 
savepoint A;
 
DELETE FROM my_employee;
 
rollback TO savepoint A;
 
commit;
 
INSERT INTO my_employee (id,last_name,first_name,userid,salary)
VALUES (&id,'&&last_name','&&first_name',lower(substr('&first_name',0,1))
|| lower(substr('&last_name',0,7)),&salary);
 
 
--number(3,2)  maximum 9.99 tutar
CREATE TABLE tbl(col1 NUMBER(3,   2) NOT NULL,   col2 VARCHAR2(20),
col3 DATE);
 
DESC tbl;
 
INSERT
INTO tbl
VALUES(1,   'Serdar',   sysdate);
 
SELECT *
FROM tbl;
 
CREATE TABLE tbl2(col1 NUMBER(3,   2) NOT NULL,   col2 VARCHAR2(20),
col3 DATE DEFAULT sysdate);
 
DESC tbl2;
 
INSERT
INTO tbl2 (col1,col2)
VALUES(1,   'Serdar');
 
SELECT * FROM tbl2;
 
 
-- data types
 
* varchar2              - değişken uzunluklu karakter tutmak içIN
* char                  - sabit uzunluklu DATA tutmak içIN 
(char varchar a göre çok yer tutar ama daha performanslıdır.)
* number                - sayı tutar
* date                  - tarif tutar
* long                  - değişken uzunluklu karakter DATA max 2gb
* clob                  - değişken uzunluklu karakter DATA max 4gb
* raw AND long raw      - raw BINARY DATA
* blob                  - BINARY DATA (max 4gb)
* bfile                 - BINARY DATA bir klasörde tutulur pathi alana yazılır.
 
* rowid                 - her bir satır içIN oluşturulan sıra numarasıdır. 
 
 
--constraints
 
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
 
--
 
ALTER TABLE emp5 READ only;
 
ALTER TABLE emp5 READ WRITE;