RSS Feed
Twitter- What is PL/SQL ?
November 06, 2017
CS Study
1. Compare SQL & PL/SQL
|
Criteria
|
SQL
|
PL/SQL
|
|
What it is
|
Single query or command execution
|
Full programming language
|
|
What it comprises
|
Data source for reports, web pages
|
Application language to build, format and display
report, web pages
|
|
Characteristic
|
Declarative in nature
|
Procedural in nature
|
|
Used for
|
Manipulating data
|
Creating applications
|
October 27, 2017
CS Study
IBPS Recruitment for IT Offcer Scale -1
For detailed Notification click here
For detailed Notification click here
September 18, 2017
CS Study
SEBI Recruitment for IT Officer
Click here for more
http://www.sebi.gov.in/sebiweb/other/careerdetail.jsp?careerId=98
Click here for more
http://www.sebi.gov.in/sebiweb/other/careerdetail.jsp?careerId=98
September 16, 2017
CS Study
Video Lecture : Boolean Algebra Part 2
Click Below Link -
https://www.youtube.com/watch?v=KTXBFqGMl00&list=PLs3a7KVCedy06OUDhUbt6fh3n3u4R3hzj&index=1
September 16, 2017
CS Study
Video Lecture- Digital Logic Subject || Part 2
Click below link
https://www.youtube.com/watch?v=Uy0Oy2-JGuQ&t=70s
Click below link
https://www.youtube.com/watch?v=Uy0Oy2-JGuQ&t=70s
September 08, 2017
CS Study
SQL supports few Set operations to be performed on table data. These are used to get meaningful results from data, under different special conditions.
Union
UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows from its result set. In case of union, number of columns and datatype must be same in both the tables.
Example of UNION
The First table,| ID | Name |
|---|---|
| 1 | abhi |
| 2 | adam |
| ID | Name |
|---|---|
| 2 | adam |
| 3 | Chester |
select * from First UNION select * from secondThe result table will look like,
| ID | NAME |
|---|---|
| 1 | abhi |
| 2 | adam |
| 3 | Chester |
Union All
This operation is similar to Union. But it also shows the duplicate rows.
Example of Union All
The First table,| ID | NAME |
|---|---|
| 1 | abhi |
| 2 | adam |
| ID | NAME |
|---|---|
| 2 | adam |
| 3 | Chester |
select * from First UNION ALL select * from secondThe result table will look like,
| ID | NAME |
|---|---|
| 1 | abhi |
| 2 | adam |
| 2 | adam |
| 3 | Chester |
Intersect
Intersect operation is used to combine two SELECT statements, but it only retuns the records which are common from both SELECT statements. In case of Intersect the number of columns and datatype must be same. MySQL does not support INTERSECT operator.
Example of Intersect
The First table,| ID | NAME |
|---|---|
| 1 | abhi |
| 2 | adam |
| ID | NAME |
|---|---|
| 2 | adam |
| 3 | Chester |
select * from First INTERSECT select * from secondThe result table will look like
| ID | NAME |
|---|---|
| 2 | adam |
Minus
Minus operation combines result of two Select statements and return only those result which belongs to first set of result. MySQL does not support INTERSECT operator.
Example of Minus
The First table,| ID | NAME |
|---|---|
| 1 | abhi |
| 2 | adam |
| ID | NAME |
|---|---|
| 2 | adam |
| 3 | Chester |
select * from First MINUS select * from secondThe result table will look like,
| ID | NAME |
|---|---|
| 1 | abhi |
September 08, 2017
CS Study
Software Engineering is an engineering approach for software
development.The basic principle of software engineering is to use structured,
formal and disciplined methods for building and using systems.The outcome of software
engineering is an efficient and reliable software product.
September 02, 2017
CS Study
The prime reason behind creation of Java was to bring portability and
security feature into a computer language. Beside these two major
features, there were many other features that played an important role
in molding out the final form of this outstanding language. Those
features are :
August 31, 2017
CS Study
Learning GIS programming: An overview
The
diversity of programming languages and tools being used in GIS (in
general in the Geospatial industry) today is truly staggering. Depending
on what the position requires, one would be expected to have expertise
in SQL, python, C++, Java or JavaScript, Flex and PHP (just to name a
few). Knowledge and competence in programming is a essential skill set
and a critical requirement for most Geospatial job opportunities these
days. A vast majority of job openings in the Geospatial industry
require some expertise in programming, application development and
software management.
As Geospatial
professionals/graduates/students, some of us overlook the importance of
programming in our careers. Some of us believe that our spatial skill
sets are niche enough to compensate for the lack of our programming
expertise. Well that might not be totally wrong. However, knowledge of
programming is most certainly going to open up a whole new array of
possibilities! It might be a good idea to have a look at recent job
postings in the Geospatial industry to get an overview of the
requirements
August 30, 2017
CS Study
- Comments are description given by the programmer within the program. So that if another programmer looks at the program,he can easily understand the program by reading the comments.
- The characters or words or anything which are given in comments section won’t be considered by java compiler for compilation process and will be ignored by java compiler during compilation.
August 30, 2017
CS Study
- Objects are anything that exists in the world. A Class is a blueprint to develop objects.
- If you consider creating objects like chair, table, cupboard, then you need to create class called Furniture.
- A class contains variables and methods.
- Variables are attributes or properties.
- Method perform functions or actions.
August 24, 2017
CS Study
A Database is a collection of related data organised in a way that data can be easily accessed, managed and updated. Any piece of information can be a data, for example name of your school. Database is actualy a place where related piece of information is stored and various operations can be performed on it.
August 22, 2017
CS Study
Linked List is
a linear data structure and it is very common data structure which consists of
group of nodes in a sequence which is divided in two parts. Each node consists
of its own data and the address of the next node and forms a chain. Linked
Lists are used to create trees and graphs.
August 20, 2017
CS Study
Queue is also an abstract data type or a linear data
structure, in which the first element is inserted from one end called REAR(also
called tail), and the deletion of existing element takes place from the other
end called as FRONT(also called head). This makes queue as FIFO(First in
First Out) data structure, which means that element inserted first will also be
removed first.
August 19, 2017
CS Study
A program in
the execution is called a Process. Process is not the same as program. A
process is more than a program code. A process is an 'active' entity as opposed
to program which is considered to be a 'passive' entity. Attributes held by
process include hardware state, memory, CPU etc.
Process memory
is divided into four sections for efficient working :
August 19, 2017
CS Study
Stack is an
abstract data type with a bounded(predefined) capacity. It is a simple data
structure that allows adding and removing elements in a particular order. Every
time an element is added, it goes on the top of the stack, the only element
that can be removed is the element that was at the top of the stack, just like
a pile of objects.
August 17, 2017
CS Study
Merge Sort follows the rule of Divide and Conquer. In merge
sort the unsorted list is divided into N sublists, each having one
element, because a list consisting of one element is always sorted.
Then, it repeatedly merges these sublists, to produce new sorted
sublists, and in the end, only one sorted list is produced.
August 16, 2017
CS Study
Quick Sort, as the name suggests, sorts any list very quickly. Quick sort is not a stable search, but it is very fast and requires very less additional space. It is based on the rule of Divide and Conquer(also called partition-exchange sort). This algorithm divides the list into three main parts :
August 16, 2017
CS Study
Selection sorting is conceptually the most simplest sorting algorithm. This algorithm first finds the smallest element in the array and exchanges it with the element in the first position, then find the second smallest element and exchange it with the element in the second position, and continues in this way until the entire array is sorted.
August 13, 2017
CS Study
SQL Join is
used to fetch data from two or more tables, which is joined to appear as single
set of data. SQL Join is used for combining column from two or more tables by
using values common to both tables. Join Keyword is used in SQL queries
for joining two or more tables. Minimum required condition for joining table,
is (n-1) where n, is number of tables. A table can also join to
itself known as, Self Join.
August 13, 2017
CS Study
TCP/IP means Transmission Control Protocol and Internet Protocol. It is the network model used in the current Internet architecture as well. Protocols are set of rules which govern every possible communication over a network. These protocols describe the movement of data between the source and destination or the internet. These protocols offer simple naming and addressing schemes.
August 13, 2017
CS Study
CPU scheduling is a process which allows one process to use the CPU while the execution of another process is on hold(in waiting state) due to unavailability of any resource like I/O etc, thereby making full use of CPU. The aim of CPU scheduling is to make the system efficient, fast and fair.
Subscribe to:
Posts (Atom)
