abdulsamedkayaduman

DECLARE
   c_id hr.employees.employee_id%type;
   c_name hr.employees.first_name%type;
   c_surname hr.employees.last_name%type;
 
   CURSOR c_employees is
      SELECT employee_id, first_name, last_name FROM hr.employees;
BEGIN
   OPEN c_employees;
   LOOP

abdulsamedkayaduman

CREATE TABLE Table6(
t_number number,
t_name varchar2(30)
) PCTFREE 90
PCTUSED 10;


DECLARE
BEGIN
FOR i in 1 .. 10000 loop

abdulsamedkayaduman

package oarcle;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
 
public class OracleJDBCExample {
	

abdulsamedkayaduman

DECLARE
beforeNolog  TIMESTAMP;
afterNolog  TIMESTAMP;

BEGIN
beforeNolog  := SYSTIMESTAMP; -- Başlangınç Zamanını atadık

EXECUTE IMMEDIATE 'CREATE /*+ append nologging */ TABLE Staj_new4 AS SELECT * FROM Staj';

afterNolog := SYSTIMESTAMP;

abdulsamedkayaduman

DECLARE
beforeNolog  TIMESTAMP;
afterNolog  TIMESTAMP;

BEGIN
beforeNolog  := SYSTIMESTAMP; -- Başlangınç Zamanını atadık
FOR i in 1 .. 1000000 loop
INSERT /*+ append nologging */ INTO 
Staj VALUES ('2dasdasd','dsads');
--SELECT * FROM Staj_2017;

abdulsamedkayaduman

DECLARE
i NUMBER;
Time_second NUMBER;
timeStart  TIMESTAMP;
timeStop  TIMESTAMP;
timeCommit  TIMESTAMP;
timeRollback  TIMESTAMP;
BEGIN
timeStart  := SYSTIMESTAMP; -- Başlangınç Zamanını atadık
FOR i in 1 .. 2000000 loop 

abdulsamedkayaduman

package snippet;
import java.io.File;

public class main
{
  public static void main(final String[] args)
  {
    File aDirectory = new File("C:/deneme");

    String[] filesInDir = aDirectory.list();

abdulsamedkayaduman

CREATE OR REPLACE DIRECTORY samed_data AS 'C:\deneme';
GRANT READ, WRITE ON DIRECTORY samed_data to PUBLIC;

DECLARE
    name_column varchar2(3);
    column_size number(15);
    i_inCounter number(12);
    line_size number(10);
    i_count number(3);