Anuj Singh Oracle DBA
Monday, 10 October 2011
Oracle table , col and index Statistics
›
Script for table , col and index Statistics Script table col index table stat index stat col stat prompt table_info.sql -- Author : ...
Oracle wait info
›
Oracle wait info .sql wait.sql REM Author : Daniel W. Fink OptimalDBA.com wait.sql SET LINESIZE 132 PAGESIZE 100 FEEDBACK OFF COLUMN t...
Oracle Create user script
›
Oracle create user script .... I am creating script to create scott user . edit user_script.sql script as per your requirement . ...
Sunday, 9 October 2011
Oracle insert into Loop
›
Oracle insert through Loop DECLARE count NUMBER := 0; total NUMBER := 0; CURSOR del_record_cur IS SELECT ...
Oracle Sql col to row
›
Oracle sqlplus Change Row into Column? sqlplus Change Row into Column? CREATE or replace TYPE strings1 AS TABLE OF VARCHAR2(100); / CREATE o...
Friday, 7 October 2011
Unix find list of first line of sql
›
List the first lines of sql files through find find /home/anujs/Downloads/Script -name \*.sql -exec head -n 1 -v {} \; > report.txt out p...
Thursday, 6 October 2011
SQL Test Case Builder
›
SQL Test Case Builder capture the information for particular SQL related problem, along with the exact environment under which the problem ...
‹
›
Home
View web version