The unique software to manage Nursing School's Students information like Medical Transcription Records, Bio-Data, Leave Records, Admission Register. This software also manages Teaching Staff details and Library System with comprehensive data entry screens and reports for every option.

With this Nursing School Software, user would be able to enter their student's master data as well as their 3 years study records related to medical transcription, Examination details and Leave records. Nursing schools can also manage their teaching staff details and their school's whole library. The following are the screen shots and details of the software.

1. The Main Screen of the software which represents the whole Menu system.

This is the main screen of the software in which you can see left side is the Menu of the software like Nursing, Reports, Teaching Staff, Library Data Entry and right side are the utilities to create Student's rotation plan. With this Nursing school software users can create rotation plan reports which gives the information on student's rotation to hospital's department for their practices.

Nursing School Software To Manage Medical Transcription

2. Student's Master Data Entry

You can see the below screen which is having comprehensive data entry fields to enter full details of the student. User can enter their own Nursing School's admission numbers and GNM Registration numbers.
Student's master data entry option Nursing School software

 3. First Year Clinical Record Entry Screen

After entering student's master data user can enter student's study records entry as shown in below screen. The User will enter only Admission number of the students and it will fetch student's name and the batch year information and if the record entry already exists it will fetch the whole record in which user can edit, if not exists then it will allow user to create a new entry and this functionality follows in whole software for data entries.

Medical Transcription Record entry Nursing School Software

 4. Student's Leave Record Entry 

Nursing School software student's leave record entry

 5. Nursing School Examination Record Entry

Nursing school software examination record entry

 6. Create Certificate Entry

Nursing school software certificate entry

 7. Admission Register Entry

Admission Register Entry Nursing school software

 8. Medical Transcription Record Report Printing

Medical Transcription record report printing Nursing school software

 9. Reports Menu Screen

Report Menu of nursing school software

 10. Teaching Staff Record Entry

Teaching staff entry nursing school software

 11. Library Management System

Library Management System software

 How To Install

Just extract the zip file NursingSoft.zip to any drive of your computer, then you will find the folder NursingSoft, double click on that folder and locate NursingSoft.Exe the software executable file, right click on it then highlight Send to and then click on Desktop Create Shortcut to create the shortcut.

how to install nursing school software

 Run The Software

Now just double click on the NursingSoft shortcut icon to run the software.

Nursing School Software

Download The Software

The software cost is INR 999 and you can download the software with the following link:

Below is the step by step example is given to export data into CSV file in Oracle database using PL SQL procedure. In this example data is being exported from some fields of Emp table of Scott schema to a CSV file using UTL_FILE Oracle package.

Follow the below steps to export data from Oracle Database table to a CSV file.

1. Create a Directory Object in which you will write CSV file.

-- for windows systems create as following change the folder highlighted with your directory
-- for Unix/Linux systems create as following

Note: Change the folder location to your directory location e.g. c:\abc or /abc/.

2. Create a Database Procedure in Scott schema or if you are creating in other schema then make sure you have Emp table in that schema, else you need to change the Cursor and the field references for any other table.

   v_file     UTL_FILE.file_type;
   v_string   VARCHAR2 (4000);

   CURSOR c_emp
      SELECT empno,
        FROM emp;
   v_file :=
      UTL_FILE.fopen ('CSVDIR',
   -- if you do not want heading then remove below two lines
   v_string := 'Emp Code, Emp Name, Dept, Salary, Commission';
   UTL_FILE.put_line (v_file, v_string);

   FOR cur IN c_emp
      v_string :=
         || ','
         || cur.ename
         || ','
         || cur.deptno
         || ','
         || cur.sal
         || ','
         || cur.comm;
      UTL_FILE.put_line (v_file, v_string);

   UTL_FILE.fclose (v_file);
      IF UTL_FILE.is_open (v_file)
         UTL_FILE.fclose (v_file);
      END IF;

3. Now run the procedure as following:


You can now check your directory you specified in Create Directory command that the file empdata.csv must exists with the table data.

Export data into csv in Oracle Database

How to check semaphores in Linux/Unix ? How to display semaphores in Linux/Unix ? How to view semaphores in Linux/Unix ?

About Semaphores

Semaphores are used to access to shared system resources. They act as gatekeepers to ensure that particular shared system resources are not accessible by multiple processes at the same time. Oracle Databases use semaphores to manage access to operating system resources such as shared memory.

Display Semaphores Existing Values

When we install Oracle Documentation it recommends to set semaphores to some values, so before modifying semaphores values we must check semaphores parameters. 

To view the semaphores information you need to display the contents of /proc/sys/kernel/sem file. Below is the example is given to view the semaphores data using cat command:

$ cat /proc/sys/kernel/sem
340 44000 300 234

You can see above that there are 4 values which represents the following 4 semaphores kernel values:

semmsl - Maximum number of semaphores per set
semmns - Maximum number of semaphores on entire system
semopm - Maximum operations for semop system call
semmni - Maximum number of semaphore arrays on entire system

How to check semaphores in linux/unix

You can check how many users logged in Linux or Unix systems. To check currently logged in users in Linux/Unix there are multiple commands are available like who, w, finger and pinky. Below is the example to display the users logged in Linux/Unix box with who command:

$ who

The following is the sample of four columns 1st is user name, 2nd is terminal name, 3rd is logged in time and the 4th is from where they logged in:

vkapoor   pts/3 Nov 01 12:23 (xyz.com)
foxuser    pts/5 Nov 01 13:22 (xyz.ip)

Use the am i option to view the current user information as shown below:

$ who am i

There is another command w the alternative to who command and gives the information in more details. Below is the example to check the currently logged in users Linux with w command:

$ w

To view a specific user's logged in details with w command, use the w command with user name, as showing in the following example:

$ w vkapoor

You can use the finger command also to list the users logged in, as shown in below example:

$ finger

Similarly use the pinky command to list out the users logged in Linux:

$ pinky

How to check how many users logged in linux/unix

The following are the top 3 selling books for EcmaScripts (Javascripts ES6). You must read at least any one from these books to gain good knowledge in EcmaScript language.

Learning ECMAScript 6

Learn all the new ES6 features and be amongst the most prominent JavaScript developers who can write efficient JS programs as per the latest standards. Learn a powerful approach to writing object-oriented JavaScript code using ES6. Create and use ES6 modules to learn to write smart, modularized JavaScript code. The book will take you step-by-step through a wide array of examples, giving you tips on how to make the best use of the latest ES6 features.

ECMAScript 6

Learn One of The Most Powerful Scripting Languages that is implemented in the Form of JavaScript, JScript and ActionScript The development of Javascript was solely based on ECMAScript (ES). This is a scripting language which is used on the client side of the web. The language introduced numerous features which programmers can use to develop complex libraries. ECMAScript comes in different versions. 

JS.Next: ECMAScript 6

S.next is the most significant change to JavaScript since its initial release in 1995. This practical book educates JavaScript developers, from novice to expert, about the impact that JS.next has had on the language, and demonstrates the powerful new constructs that are accessible in the JS.next API. Complete with code examples, the references and explanations will bring your knowledge of JavaScript into the now, and will jump start any developer's ability to code in modern JavaScript.

Top 3 books to learn ecmascript 6

The following are the details of best 3 books to learn AngularJS.

Pro Angular JS

AngularJS is the leading framework for building dynamic JavaScript applications that take advantage of the capabilities of modern browsers and devices. AngularJS, which is maintained by Google, brings the power of the Model-View-Controller (MVC) pattern to the client, providing the foundation for complex and rich web apps. It allows you to build applications that are smaller, faster, and with a lighter resource footprint than ever before.

Best-selling author Adam Freeman explains how to get the most from AngularJS. He begins by describing the MVC pattern and the many benefits that can be gained from separating your logic and presentation code. He then shows how you can use AngularJS's features within in your projects to produce professional-quality results. Starting from the nuts-and-bolts and building up to the most advanced and sophisticated features AngularJS is carefully unwrapped, going in-depth to give you the knowledge you need.

Unraveling AngularJS 1.4

AngularJS is a great technology to create dynamic web sites with the Single Page Application model. From this book you can learn not only the fundamentals, but you will also grasp the essence of internal mechanisms that drive Angular.

Professional AngularJS

Most of the existing guides to AngularJS struggle to provide simple and understandable explanations for more advanced concepts. As a result, some developers who understand all the basic concepts of AngularJS struggle when it comes to building more complex real-world applications. Professional AngularJS provides a thorough understanding of AngularJS, covering everything from basic concepts, such as directives and data binding, to more advanced concepts like transclusion, build systems, and automated integration testing. In addition to explaining the features of AngularJS, this book distills real-world experience on how these features fit together to enable teams to work together more effectively in building extraordinary apps.
3 Must read books for angularJS

Log user's login and logout details in to table through Oracle Forms using POST-LOGON and PRE-LOGOUT triggers to track the user's login and logout activity for auditing purposes.

Track user login logout activity in Oracle Forms
In this example one table and a sequence object is used to log the data in to table called login_out and the login information would be logged through Post-Logon trigger and logout information would be logged through Pre-Logout trigger in Oracle Forms. Follow the below mentioned steps to perform this task.

1. Create a Sequence object in Oracle Database.


2. Create a Table in Oracle Database.

CREATE TABLE login_out
   srlno     NUMBER (10) PRIMARY KEY,
   loguser   VARCHAR2 (20 BYTE),
   indate    DATE,
   outdate   DATE

3. Create a Post-Logon Trigger at Form Level in Main Form of Your Application.

   v_seq    NUMBER (10);
   v_user   VARCHAR2 (20) := GET_APPLICATION_PROPERTY (username);

   /* this global variable is created to use on pre-logout trigger to update the correspondent record. */
   :Global.login_seq := v_seq;
   INSERT INTO login_out (srlno, loguser, indate)
       VALUES (v_seq, v_user, SYSDATE);

      RAISE form_trigger_failure;

4. Create a Pre-Logout Trigger at Form Level in Main Form of Your Application.

   v_seq    NUMBER (10) := :GLOBAL.login_seq; 

   Update login_out 
      set outdate = SYSDATE
      where srlno = v_seq;

-- No need to commit here it will do automatically

      RAISE form_trigger_failure;

Now run the form and after that you can check the login_out table to view the data as following:

  FROM login_out
Note: These triggers should added into Main Form only of your application, not in every form.

To kill any process in Linux or Unix box use kill command. Below is the example is given which will first list out the processes with ps command as described in previous chapter, then it will kill the process using kill command by passing process id as parameter.

To list the process, give the ps command as following:

$ ps -ef | grep pmon

The sample output of the above command is:

oracle 1982 1 0 Dec 02 ? 09:01 ora_pmon_fox
oracle 8339 1 0 Dec 02 ? 09:08 ora_pmon_vin

Now suppose you want to kill the process with id 8339 use the kill command as following:

$ kill -9 8339

The -9 option will send a kill signal to the process to terminate.

You can view all the signal available with kill command as following:

$ kill -l

example of kill process in linux/unix

To list all the processes running or started in Linux/Unix use ps command. Below is the simple example of ps command without any parameters to view all the processes started by the user you are logged in:

$ ps

It will show the output something like this:

33214 pts/3 0:00 ps
14897 pts/4 0:00 bash

To view all the processes running in Linux or Unix box use -e and -f option with ps command to display every process in full format:

$ ps -ef

To view all the process containing the string pmon use pipe (|) and grep to filter the search for processes as shown in below example:

$ ps -ef | grep -i pmon

The above command will list out all the processes containing string pmon in it.

listing processes example of linux/unix

You can use the following commands in Linux and Unix to list or view the environment variables. With the same command you can view a particular environment variable in Linux/Unix and to list all environment variables in Linux/Unix operating systems. The below is the list of commands and their examples:
  • printenv
  • env
  • set
  • export
  • echo
To display all variables set in current environment you can use any of the following commands without any option e.g. printenv, env, set and export

The following example will list all environment variables in Linux or Unix shell:

$ printenv

If you know the particular variable name then you can view the content of that variable with printenv command as following:

$ printenv USER

You can use echo command also to view the content of an environment variable but in echo command you have to use dollar sign ($) with variable names, as shown in following example:

$ echo $USER

list environment variables in Linux/Unix shell

You can type a long command in multiple lines in Linux/Unix shell by using backslash (\). Suppose you have a long command to type in a small screen area then you can split that long command over multiple lines in Linux or Unix shell.

The following is the example to split long command in multiple lines in bash shell:

$ /usr/foxhome/oracle/product/10.2.1/db_2/bin/rman \
> target / \
> catalog rman/admin@mydb1 \
> cmdfile=/home/oracle1/scripts/rmanchk.rmn \
> msglog=/home/oracle1/rmanlog/rmanlog01.log append

As you can see in above command that backslash is used to split the line followed by Enter key or Return key and when you press the enter key the line will be preceded by the > character, this shows that the command extended to the next line.

Linux/Unix command examples

It makes very irritating sometimes when we want to delete the previous character using backspace key in Linux/Unix and it shows characters like ^?  or ^] etc. instead of deleting the character. To get rid of this backspace key problem in Linux or Unix shell, use stty command to set the backspace key to erase the previous character.

The following is the example to set the backspace key to delete the previous character in shell, type stty erase then give two space and then press backspace and then press enter, your whole command will be something like this:

$ stty erase ^?

The above command will solve this problem but in some older versions of Linux and Unix you may need to run this command as following:

$ stty erase ^H

Backspace key problem solution for linux/unix

When we executes a command in Linux/Unix shell then it displays the output on screen and if you want to capture the output also in a log file (text file) then you can use the tee command. The tee command generates the shell command output on screen and as well as in a text file.

The below example is given to run the ls command to list all files in a directory on the screen and also saves the output to a file ls123.log, which can be viewed later:

$ ls -altr /myfolder/files | tee /home/files/log/ls123.log

You can see in above command that pipe | is used to separate and add to tee command. Before pipe is a your command and after pipe is to log the output of a command in a log file.

Now you can move to directory /home/files/log/ to see the contents of a ls123.log file, generated from the command.

Linux/Unix Command Examples

It is difficult to type long command frequently in Linux/Unix and then we need to make it short for our convenient. You can make the commands short in Linux/Unix by creating aliases for it. Below is the example given to create alias for a command in Linux and Unix.

Suppose you need to type the following command to navigate to the particular directory again and again:

$ cd /oracleapp/myprojects/20121010/file1/forms

You can create the alias for the above command to create a shortcut to accomplish the same task. In the below example we will use the alias myd for the command and make sure the alias must not the reserve word of Linux or Unix.

$ alias myd='cd /oracleapp/myprojects/20121010/file1/forms'

Now you can enter just myd to navigate to the target directory.

create shortcut in linux unix from command line

A very nice and time saving feature of the Bash shell is that it has many ways for editing and running previous commands in Linux and Unix, but remember sometimes it does not work automatically and then you have to give the command bash in command prompt to let shell come in that mode. The following are some methods by which you can execute previous command in Linux/Unix quickly.

1. Scrolling with the up and down arrow keys
2. Using Ctrl+P and Ctrl+N
3. Listing command history

Scrolling with the Up and Down Arrow Keys

You can use the up and down arrow key to scroll though your previously executed commands in bash shell.

Pressing Ctrl+P and Ctrl+N

Use Ctrl+P to display your previously entered command and use Ctrl+N to scroll back command stack.

Listing Command History

Use the history command to display commands that have been previously entered, as shown in below example:

$ history 3

It will show you previously entered 3 commands, below is the example:

125 ls *.ctl
126 cp abx.txt \usr\abc\
127 history 3

To run any command from above list, type an exclamation mark followed by the history number eg. to run the first command of the list which is having 125 number, do the following:

$ ! 125
To run the last command you can use !!, as following:
$ !!

Search command history in linux/unix shell

You can send your blog posts immediately after when you publish them, to up to 10 email addresses in Blogger blogspot blog. This option can be used to inform other authors of your blog and owner of your blog or any other special people to whom you want to get updated immediately after publishing of your blog posts. Generally your blog posts are being send by Feedburner after one day of publishing to your subscribers but through this option you can send to specific email addresses to whom you want to inform.

Sent Automatic mail on publish of post in blogger blogspot
To set this option in blogger follow these steps:

1. Go to the Settings > Mobile and Email option and click on Add link adjacent to Email Posts To option as shown in below image:

2. Then type up to 10 email addresses separate them with comma and then save the settings.

You are done and now whenever you publish the blog post it will automatically send to these email addresses immediately.

Add Google Custom Search (CSE) in SNEWS theme for blogger blog by following steps, but remember the only Overlay layout of Google custom search will work in snews theme. Below is the screen shot of layout option in which you will choose Overlay type.
Add Google custom search option in snews theme
1. Goto Google Custom Search Engine and create your engine with Overlay layout and get the engine id from Setup option as shown in below image.
Get google cse engine id

2. Then goto Layout section in blogger and choose Change Default Settings option from the header section and type cseid in New Site Name field and add your cse id in New Site URL field as shown in below image.
Add cse id in snews blogger theme

Save it and it will work.

In this post you will learn how to specify any condition in enter query mode of Oracle Forms. Whenever Enter_Query command executes Oracle Forms comes into enter query mode and in that mode you can specify some criteria to filter the records and after that when you execute query using Execute_Query command then the records would be fetched based on that condition you specified.

Enter_Query built-in usage example:
[code type="PL/SQL"]Begin
The below is the screen shot from which records would be filtered in this example.
using enter_query command in oracle forms
Note you can specify the search condition only when Oracle Forms is in Enter Query Mode. The following are some search criteria examples:

Search only those records where Emp Name containing AR 

Specify %AR% in Emp Name column to fetch the records where AR exists in Emp Name.
filter name field in enter query mode of oracle forms
oracle forms enter_query example

Search only those records where second letter of Emp Name is L

Specify one underscore for first any letter and then L% eg. _L%
enter_query tricks in oracle forms
how to specify condition in enter query mode in oracle forms

Search only those records where Hire Date is greater than 01st Oct 2015

Specify greater than sign and the date in single quotes:
specify criteria in enter query mode of oracle forms
oracle forms enter_query built-in example

Search only those records where Salary is greater than 5000

Specify greater than sign and the value eg. > 5000
how to use enter query in oracle forms
oracle forms enter query mode example

Search only those where Job is equal to CLERK and Salary is less than 4000

Specify CLERK in job column and less than sign and the value in Salary column You can also specify = sign and value in single quote in Job column eg. ='CLERK' 
search records in data block in oracle forms
specify condition in data block in oracle forms

Execute_Query command is used to fetch all the records for current database data block in Oracle Forms, actually its executes query in current data block.


Clears the current block, opens a query, and fetches a number of selected records.

EXECUTE_QUERY (keyword_one VARCHAR2); 
EXECUTE_QUERY(ALL_RECORDS) performs the same actions as EXECUTE_QUERY but Oracle Forms fetches all of the selected records.

EXECUTE_QUERY(ALL_RECORDS, FOR_UPDATE) performs the same actions as EXECUTE_QUERY but it lock all of the selected records immediately and fetches all of the selected records.

EXECUTE_QUERY(keyword_one VARCHAR2, keyword_two VARCHAR2); 

EXECUTE_QUERY(keyword_one VARCHAR2, keyword_two VARCHAR2, locking VARCHAR2);
Can be set to NO_WAIT anytime that you use the FOR_UPDATE parameter. When you use NO_WAIT, Oracle Forms displays a dialog to notify the operator if a record cannot be reserved for update immediately. Without the NO_WAIT parameter, Oracle Forms keeps trying to obtain a lock without letting the operator cancel the process. 


[code type="PL/SQL"]BEGIN
Earlier I have given many example to perform query in Oracle Forms and below are the links that you can check for more details.

Define Custom Query Criteria Before Performing Query In Oracle Forms

If Value Exists Then Query Else Create New Record Example Oracle Forms

Sorting Data Block On Query in Oracle Forms

Oracle Forms Execute Query Example using Execute_query

Do you want to login into Blogspot .com to access blogspot login page for sign up with blogspot to create a blog? The blogspot is actually a domain name in Blogger, when you create a blog in blogger .com with any name then the blogspot would be added automatically to that name. For example you created a blog with name mycookingrecipes then the full name of your blog would be mycookingrecipes.blogspot.com.

So if you want to login into blogspot to access a blog or to sign up with blogspot, then you have to login into blogger.com. Blogger is a Google's product in which you can create a blog for free. You can use the following link to login into blog spot.
Login to blogspot.com

An amazing free online SQL tool "livesql.oracle.com" is launched by Oracle to learn, test and share SQL queries and scripts online. There is an option to learn category wise SQL tutorials with free example scripts shared by community members. You can also be the part of this community and can share your scripts. Use this tool by login in with your Oracle user id and password.
free online sql tool by oracle
This tool is developed on Oracle Apex technology and following are the screen shots of Community code and SQL worksheet screens.
Free online sql tutorials and examples

Free online SQL testing tool by oracle
Subscribe To Get Email Notifications For Latest Updates Like This:
Enter your email address:

Delivered by FeedBurner

Connect any Oracle Forms version including Oracle Forms 12c to Oracle Database 12c using the following steps. 

First add the connection information of your Pluggable Oracle 12c Database in Tnsnames.ora file using the following format:
[code type="Text"]MYPDB =
Now your pluggable database must be open to get connect with it, so open it using the following commands:
[code type="SQL"]Alter Session Set Container = MYPDB;
Alter Database Open MYPDB; [/code]
Now you are ready to connect Oracle Forms Builder to Oracle Database 12c. You can check the following link to learn, how to create pluggable database in Oracle Database 12c.

Create Local User In Oracle Database 12c
Connect Oracle Forms D2k, 12c to Oracle Database 12c
Subscribe To Get Email Notifications For Latest Updates Like This:
Enter your email address:

Delivered by FeedBurner

Example is given below to sort detail data block data (toggle asc or desc) with push buttons used as header of grid, by setting ORDER_BY property of data block using SET_BLOCK_PROPERTY command.

The following is the screen shot of this example and this form can be downloaded from the below link:
Sort Detail data block example Oracle Forms

In this example two data block are being used, one is to contain push buttons to sort data and one is to hold the data in detail block.

On every push button of header the following code is written on When-Button-Pressed trigger:
[code type="PL/SQL"]Begin
 If Nvl(Get_Block_Property('scott_emp', order_by), 'ENAME ASC') = 'ENAME ASC' then
    Set_Block_Property('scott_emp', order_by, 'ename desc');
   Set_Block_Property('scott_emp', order_by, 'ename asc');
 End if;
You see in above example when I am getting the current setting of order by property of the block, I am reading it in upper case because it returns in upper case even if I am setting the property in lower case.

On every button the code is the same but only the field name difference is there for every column, you can see in the source code fmb, which I am providing with this example.
Subscribe To Get Email Notifications For Latest Updates Like This:
Enter your email address:

Delivered by FeedBurner

V. Kapoor

{picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
Fox Infotech. Powered by Blogger.