Jayant R Shobhawat

An Entrepreneur

[itsjustsciencee]

#Quotes

[itsjustsciencee]

There is nothing like truth. You are the truth.

~JK

[itsjustsciencee]

आंधी...

मेरा बचपन मुझे इसलिए याद आता है क्योंकि वहा मेरे सपने थे पर उसके पीछे पागलपन नही था । एक अजीब सा सुकून था या शायद वक़्त ने मुझे ये सोचने पर मजबूर कर दिया है की आज जो ज़िन्दगी है उसमे वो सोच ही ही बस सुकून है ।

एक अजीब सी आंधी चल रही है हर तरफ, मैं बस चलता जा रहा हु बल्कि दौड़ता जा रहा हु । इस आंधी में न कुछ दिखाई देता है ना कुछ सुनाई देता है । बस दूर चमकती एक रौशनी है ।

मंज़िल नही पाने का डर ही नही है क्योंकि मुझे खुद नही पता कि मेरी मंज़िल कहा है । एक अजीब सी झूठ वाली ज़िन्दगी है जहाँ सिर्फ मैं हु और मैं ही हु।

[itsjustsciencee]

sequence in shell script

[itsjustsciencee]

SQL Quick Reference 

  SQL Statement Syntax AND / OR SELECT column_name(s) FROM table_name WHERE condition AND|OR condition ALTER TABLE ALTER TABLE table_name  ADD column_name datatype

or

ALTER TABLE table_name  DROP COLUMN column_name

AS (alias) SELECT column_name AS column_alias FROM table_name

or

SELECT column_name FROM table_name  AS table_alias

BETWEEN SELECT column_name(s) FROM table_name WHERE column_name

View On WordPress

[itsjustsciencee]

USE a Cursor FOR loop

USE a Cursor FOR loop

USE a Cursor FOR loop.

View On WordPress

[itsjustsciencee]

USE a Cursor FOR loop

USE a Cursor FOR loop

      Declare

cursor c_group_discount is 

      select distinct s.course_no from section s, enrollment e

      where s.section_id = e.section_id

      group by s.course_no, e.section_id, s.section_id

       having count(*) >=8;

begin

     for r_group_discount in c_group_discount

     loop

     update course

        set cost = cost*.95

        where course_no = r_group_discount.course_no;

end loop;

View On WordPress

[itsjustsciencee]

a way to transfer a file using ftp from a shell script:

a way to transfer a file using ftp from a shell script:

This is very useful because variables are evaluated during this operation. Here is a way to transfer a file using ftp from a shell script:

#!/bin/sh # Usage: # ftpfile machine file # set -x SOURCE=$1 FILE=$2 BFILE=`basename $FILE` ftp -n $SOURCE <<EndFTP ascii user anonymous $USER@`hostname` get $FILE /tmp/$BFILE EndFTP

View On WordPress

[itsjustsciencee]

How to assign output of select statement in a varible in shell script.

  count=`sqlplus -s usrid/password@databasename <<END          set VERIFY OFF          set pagesize 0          set feedback off          set heading off           select column_name from table;       exit       END`         echo $count

View Post

[itsjustsciencee]

TOP Command in unix

TOP Command in unix.

View Post

[itsjustsciencee]

TOP Command in unix

top – display top CPU processes

=======================================

Linux / Unix Command: top C…

View Post

[itsjustsciencee]

Cut command to print a column in unix or linux

View Post

[itsjustsciencee]

Oracle PL/SQL CheatsheetSymbols; Semicolon.Statement terminator% Percent signAttribute indicator

Oracle PL/SQL Cheatsheet Symbols ; Semicolon. Statement terminator % Percent sign Attribute indicator (cursor attributes like %ISOPEN and indirect declaration attributes like %ROWTYPE). Also used as multibyte wildcard symbol, as in SQL. _ Single…

View Post

[itsjustsciencee]

Difference between > and >> operator?

The “>” sign is used for redirecting the output of a program to something other than stdout (standard output, which is the terminal by default).

The >> appends to a file or creates the file if it doesn’t exist. The > overwrites the file if it exists or…

View Post

[itsjustsciencee]

how to delete empty line in unix file

how to delete empty line in unix file.

View Post

[itsjustsciencee]

how to delete empty line in unix file

sed -i '/^$/d' foo

down vote accepted

sed -i '/^$/d' foo

This tells sed to delete every line matching the regex ^$ i.e. every empty line. The -i flag edits the file in-place, if your seddoesn’t support that you can write the output to a…

View Post

[itsjustsciencee]

create a empty file with size in unix

mkfile 10m output.dat

-rw——- 1 jshobhaw sdindia 10485760 Jun 6 15:04 output.dat

View Post