Diksha IT Training Centre

  Explicit Cursor and For Cursor loop with Examples in PL/SQL Anonymous Block. Hello Everyone, Today we will see some examples of both Explicit and FOR CURSOR loop with some practical examples in Oracle PL/SQL Anonymous Block. Please see my previous blogs where I discussed about syntax and some basic examples of Cursor and also idea about %type and % rowtype uses in PL/SQL block for your reference. https://dheeraj60.blogspot.com/2020/05/cursor-in-database-and-importance-of.html https://dheeraj60.blogspot.com/2020/05/benefits-and-advantage-of-using-type.html   Now let’s start first with explicit cursor with one Program, as we know in Explicit Cursor programmers are allowed to create named context area to execute their DML operations to get more control over it. Explicit cursor is created on a SELECT Statement which returns more than one row. We can provide a suitable name for the cursor for reference so that we can use that cursor name in PL/SQL block. The steps involved in creat

  Basic Shell Programming in Unix. Hello Everyone, Today we will discuss about how to write simple shell program in Unix and in next blog we will discuss more about shell scripts. Before starting basic shell programming please go through my below blog related with Unix command so that you can able to write basic shell programs. https://dheeraj60.blogspot.com/2020/08/basic-and-some-advance-command-in-unix.html https://dheeraj60.blogspot.com/2020/08/basic-and-some-advance-command-in-unix.html https://dheeraj60.blogspot.com/2020/08/advance-unix-command-part1-dotcmdb.html https://dheeraj60.blogspot.com/2020/08/advance-unix-command-part-2-dotcmdb.html   I am writing one basic simple script which will list all the files in the current directory , also it will show the present working directory name as well as all the process running in the system. Suppose we create a test.sh script , the scripts would have the .sh extension. Before you add anything else to your script, you need to alert

Advance Unix Command Part 2. Hello Everyone, In my Previous blogs I already discussed about several commands which commonly used in Unix . Today I will discuss some more command which commonly used in Unix . Before starting new commands I will suggest you to please go through my below blogs for Unix command . https://dheeraj60.blogspot.com/2020/08/advance-unix-command-part1-dotcmdb.html https://dheeraj60.blogspot.com/2020/08/basic-and-some-advance-command-in-unix.html https://dheeraj60.blogspot.com/2020/08/basic-and-commonly-used-command-in-unix.html   Let’s start with Unix command : Connect to a remote mysql database. Below is the command to connect remote mysql database as well as local mysql database. Note : You should first now the host name to connect mysql database as well as password. $ mysql -u u255474504_root -p -h 127.0.0.1 Connect to a local mysql database. $ mysql -u   u255474504_root –p Below is the output of above command in putty Terminal.   How to change y

  Advance Unix Command Part1 .   Hello Everyone, In Previous blogs I discussed about basic Unix command which is commonly used. Today I will discuss some advance command of Unix which is mostly used in organization.   Please see my below blogs related to Basic Unix command for your reference. https://dheeraj60.blogspot.com/2020/08/basic-and-some-advance-command-in-unix.html https://dheeraj60.blogspot.com/2020/08/basic-and-commonly-used-command-in-unix.html Let’s Start with Unix command. Find Command to find the modified files 30 days ago. Note : We can give any number of days Important : -mtime +30 means you are looking for a file modified 30 days ago and -mtime -30 means less than 60 days. Command is as below: find /home -iname "*.txt" -mtime - 30 –print Find Command to Display   content of file on screen that were last modified 30 days ago. find /home/   -iname "*.txt" -mtime -30 -exec cat {} \; Below is the output of above commands in putty Termina

                  Basic and some Advance Command in Unix    Hello Everyone, In my Previous Blog we discussed about some basic command of Unix which is commonly used. Today I will discuss more about some more important command which is commonly used. Before starting new commands please go through my previous blog for your reference. https://dheeraj60.blogspot.com/2020/08/basic-and-commonly-used-command-in-unix.html Control Command in Unix : In Unix we have some key command through which we can terminate as well as command can run in background. Below are the key command and it’s uses in terminal. Control-C: Command terminates the currently running foreground process. Control-D: Command terminates the currently running login or terminal session. Control-Z: Command suspends the currently running foreground process to the background.   To see the process by using ps –ef command : This command shows every process running , and result shows with PID. I am running this command in Pu