MAHIPUR SO , GOLIVE TODAY 29.01.2016

Mahipur SO under CBS plat form since 29.01.2016 . Inagurated by Bikash Kumar Pradhan , Ganeshwar Sahoo,Bibhu Prasad Mishra & Kabiraj Nayak , special thanks to all the CBS Team Puri Division.It's another grand success to the Dept. Of Posts.

JAVA

CLICK HERE

FINANCLE PRINTER SETTING

CLICK HERE

CBS WORK FLOW

CLICK HERE

Working Functional Keys in DOP finacle

Working Functional Keys in DOP finacle

The Functional / Shortcut keys are available in the Finacle software which is developed by Infosys. But the modified version of Finacle in DOP is limited to access the shortcut keys.

Some of the working keys are listed below 

In Date Field while Press the Ctrl + X to Enter the BOD/Current date. This option may not work in some of the fields which is not configured with above shortcut.

DOP Finacle Menu for Refund TDS Amount of SCSS Account

1. Invoke HRFTDS menu
2. Enter Report To - PM
3. Enter Refund CIF ID - SCSS A/C CIF ID
4. Enter From A/C ID
5. To A/C ID will appear automatically
6. Select Tran. Type - Transfer
7. Click on GO(F4)
8. Select the concerned month.
9. Click on Add each time for multiple months selection.
10. Enter Refund A/C ID for each selection

a) SOLID+0340 for cheque
b) Customer's SB A/C ID for SB Transfer

11.Click on SUBMIT(F10)

SQL PRIMARY KEY

SQL PRIMARY KEY Constraint on CREATE TABLE

The following SQL creates a PRIMARY KEY on the "P_Id" column when the "Persons" table is created:

MySQL:

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
PRIMARY KEY (P_Id)
)

SQL Server / Oracle / MS Access:

CREATE TABLE Persons
(
P_Id int NOT NULL PRIMARY KEY,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)

To allow naming of a PRIMARY KEY constraint, and for defining a PRIMARY KEY constraint on multiple columns, use the following SQL syntax:

MySQL / SQL Server / Oracle / MS Access:

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)
)

Note: In the example above there is only ONE PRIMARY KEY (pk_PersonID). However, the VALUE of the primary key is made up of TWO COLUMNS (P_Id + LastName).

---

SQL PRIMARY KEY Constraint on ALTER TABLE

To create a PRIMARY KEY constraint on the "P_Id" column when the table is already created, use the following SQL:

MySQL / SQL Server / Oracle / MS Access:

ALTER TABLE Persons
ADD PRIMARY KEY (P_Id)

To allow naming of a PRIMARY KEY constraint, and for defining a PRIMARY KEY constraint on multiple columns, use the following SQL syntax:

MySQL / SQL Server / Oracle / MS Access:

ALTER TABLE Persons
ADD CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)

Note: If you use the ALTER TABLE statement to add a primary key, the primary key column(s) must already have been declared to not contain NULL values (when the table was first created).

---

To DROP a PRIMARY KEY Constraint

To drop a PRIMARY KEY constraint, use the following SQL:

MySQL:

ALTER TABLE Persons
DROP PRIMARY KEY

SQL Server / Oracle / MS Access:

ALTER TABLE Persons
DROP CONSTRAINT pk_PersonID

SQL CREATE TABLE Syntax

The SQL CREATE TABLE Statement

The CREATE TABLE statement is used to create a table in a database.

Tables are organized into rows and columns; and each table must have a name.

SQL CREATE TABLE Syntax

CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
);

The column_name parameters specify the names of the columns of the table.

The data_type parameter specifies what type of data the column can hold (e.g. varchar, integer, decimal, date, etc.).

The size parameter specifies the maximum length of the column of the table.

Tip: For an overview of the data types available in MS Access, MySQL, and SQL Server, go to our complete Data Types Reference.

The SQL SELECT TOP Clause

The SQL SELECT TOP Clause

The SELECT TOP clause is used to specify the number of records to return.

The SELECT TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on performance.

Note: Not all database systems support the SELECT TOP clause.

SQL Server / MS Access Syntax

SELECT TOP number|percent column_name(s)
FROM table_name;

SQL DELETE STATEMENT

The SQL DELETE Statement

The DELETE statement is used to delete rows in a table.

SQL DELETE Syntax

DELETE FROM table_name
WHERE some_column=some_value;

SQL UPDATE STATEMENT

The SQL UPDATE Statement

The UPDATE statement is used to update existing records in a table.

SQL UPDATE Syntax

UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

insert into in SQL

The SQL INSERT INTO Statement

The INSERT INTO statement is used to insert new records in a table.

SQL INSERT INTO Syntax

It is possible to write the INSERT INTO statement in two forms.

The first form does not specify the column names where the data will be inserted, only their values:

INSERT INTO table_name
VALUES (value1,value2,value3,...);

The second form specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);

SQL ORDER BY Syntax

SELECT column_name, column_name
FROM table_name
ORDER BY column_name ASC|DESC, column_name ASC|DESC;

IMPORTANT SQL COMMANDS

Some of The Most Important SQL Commands

• SELECT - extracts data from a database
• UPDATE - updates data in a database
• DELETE - deletes data from a database
• INSERT INTO - inserts new data into a database
• CREATE DATABASE - creates a new database
• ALTER DATABASE - modifies a database
• CREATE TABLE - creates a new table
• ALTER TABLE - modifies a table
• DROP TABLE - deletes a table
• CREATE INDEX - creates an index (search key)
• DROP INDEX - deletes an index

ABOUT SQL

What is SQL?

• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL is an ANSI (American National Standards Institute) standard

---

What Can SQL do?

• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, and views

---

SQL is a Standard - BUT....

Although SQL is an ANSI (American National Standards Institute) standard, there are different versions of the SQL language.

However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

---

Using SQL in Your Web Site

To build a web site that shows data from a database, you will need:

• An RDBMS database program (i.e. MS Access, SQL Server, MySQL)
• To use a server-side scripting language, like PHP or ASP
• To use SQL to get the data you want
• To use HTML / CSS

---

RDBMS

RDBMS stands for Relational Database Management System.

RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

The data in RDBMS is stored in database objects called tables.

A table is a collection of related data entries and it consists of columns and rows.

ALTER DB QUARRIES

The ALTER TABLE Statement

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

SQL ALTER TABLE Syntax

To add a column in a table, use the following syntax:

ALTER TABLE table_name
ADD column_name datatype

To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column):

ALTER TABLE table_name
DROP COLUMN column_name

To change the data type of a column in a table, use the following syntax:

SQL Server / MS Access:

ALTER TABLE table_name
ALTER COLUMN column_name datatype

My SQL / Oracle (prior version 10G):

ALTER TABLE table_name
MODIFY COLUMN column_name datatype

Oracle 10G and later:

ALTER TABLE table_name
MODIFY column_name datatype

Common Use of Function Key (F1 to F12)in Window

Common Use of Function Key (F1 to F12)in Window

Common Use of Function Key  (F1 to F12)in Window

You might be Using Windows since long time but i am sure majority of you guys don’t know all the features and Uses of F1-F12 keys on your keyboard. We all know Common shortcuts like CTRL+C to Copy and CTRL+V to Paste, But you might not know what F1, F2,F3…….F12 keys actually do and where and when to use them.

In this article we will see Common features and Uses of F1-F12 keys , and also how these keys can be used with the Combination of CTRL and ALT keys.

USES OF F1 KEY:

• F1 key almost everywhere is used for “Help”. if you are using windows OS and want help anywhere then press F1 key, this will open up help window for you.
• Sometimes F1 key is used to enter the BIOS (press F1 when your computer is about to boot).
• Combination of Win + F1 keys will open the “Help and Support» Microsoft Windows.

USES OF F2 KEY:

• Rapidly rename the chosen file or folder. Works in all adaptations of Windows.
• Alt + Ctrl + F2 – Opens the Document as a Microsoft Word.
• Ctrl + F2 – Opens the Preview window in Microsoft Word.
• Frequently to enter the BIOS.

USES OF F3 KEY:

• In the MS-DOS charge line or in Windows, press F3 to rehash the last summon.
• Win + F3 – Advanced Search window opens in Microsoft Outlook.
• Shift + F3 – Changes the content in Microsoft Word, from upper to lower case or capital letters at the start of each one expression.
• In the event that I am not mixed up it is the F3 key which will cause the Application«Control» computers Apple, running Mac OS X.

USES OF F4 KEY:

• This opens the location bar, in the event that you press F4 in Windows Explorer and Internet Explorer.
• Rehash the last activity (MS Word )
• Ctrl + F4 – Closes the window open in the present window, for example, a tab in the program
• Alt + F4 – Closes the system window in Windows.

USES OF F5 KEY:

• Refreshes the present page (works in all advanced programs), and additionally redesign the desktop or open organizers in Windows.
• Running a slide demonstrate in Powerpoint.

USES OF F6 KEY:

• Move the cursor in the location bar (additionally works in numerous advanced programs).
• Ctrl + Shift + F6 – opens Document in Microsoft Word

USE OF F7 KEY:

• Mostly used for spelling and grammar in a document programs Microsoft (Word, Outlook, etc.)

USE OF F8 KEY:

• Pressing F8 key while your PC is about to boot will result into booting your PC in Safe mode.

USE OF F9 KEY:

• The F9 key does not have any functionality in Windows. It may, however be used in some individual programs. To find out if it is available in the program you are using, bring up the program’s help screen and type in the words function key.

USES OF F10 KEY:

• Activates “Menu” in the open organizer window.
• Shift + F10 – works same as the right mouse click.
• Pressing F10 while your system is booting will show you BIOS Information.
• F10 is used to enter the hidden recovery partition on computers Sony.

USE OF F11 KEY:

• F11 Key will take you to Full screen mode and it can be used and work in any Browser.

USES OF F12 KEY:

• Opens the “Save As” in Microsoft Word.
• Shift + F12 – Saves a document in Microsoft Word.
• Ctrl + Shift + F12 – Prints a document in Microsoft Word.
• F12 key will open up Inspect element box in any Browser.

Fn + F1 or F2 or …. F12 keys will normally do the task that is Printed on the respective keys, This is basically for Laptop Users.

With this it Concludes my list of uses of F1-F12 keys in windows, if you know any more uses then please add to this article by Commenting Below.

Constitution of an Empowered Committee of Secretaries to process the recommendations of the 7th Central Pay Commission

Constitution of an Empowered Committee of Secretaries to process the recommendations of the 7th Central Pay Commission

Press Information Bureau
Government of India
Cabinet13-January-2016 16:37 IST

Constitution of an Empowered Committee of Secretaries to process the recommendations of the 7th Central Pay Commission 

The Union Cabinet, chaired by the Prime Minister Shri Narendra Modi, has given its approval for setting up an Empowered Committee of Secretaries under the Chairmanship of Cabinet Secretary, in order to process the recommendations of 7th Central Pay Commission (CPC) in an overall perspective.

The Empowered Committee of Secretaries will function as a Screening Committee to process the recommendations with regard to all relevant factors of the 7th CPC in an expeditious detailed and holistic fashion.

Revision of Cycle Maintenance Allowance of GDS MC / MD - Reg

Revision of Cycle Maintenance Allowance of GDS MC / MD - Reg

Grant of scholarship for Post Graduation in Technical Course to the wards of GDS - reg

Grant of scholarship for Post Graduation in Technical Course to the wards of GDS - reg

SQL QUARIES FOR UPDATE DB

UPDATE (YOUR TABLE NAME)
SET (VALUE REQUIRED)
WHERE(VALUE TO BE UPDATED)