Add

Use Reliance Jio Sim Card in any mobile

Use Reliance Jio Sim Card in any mobile.

Reliance Jio sim card is currently available for all LYF,selected Samsung and LG Handsets. These sim cards are not available for retails sale. So you cannot get these sim cards for any other mobile phones.

To get the Jio sim cards, you have to install all the jio applications.After installig all the apps you have to open myjio app and then you will get the option of get jio sim , simply click and fill up the forms , and you will get the promo code. Take the promo code to the Reliance Digital Store and get the new Jio Sim Cards for your phone.

But now you will not get the options of get Jio sim in any mobiles except the selected ones. Because they have updated the My Jio applications.

But then also you will generate the promo code by following the simple steps.

Step 1: First of all you have to uninstall all the installed jio apps.

Step 2: Now download and install the myjio app from the below link only don't update the myjio app.

Download

Step 3: open the myjio app and click on install all app.

Step 4: After installing all the apps restart the phone. After Restarting switch of data connection. and open my jio app then only you will get the option of get Jio Sim.

Step 5: Switch on the data connection and select the get Jio sim option.

Step 6. Fill up the forms and submit, then you will get the promocode.

Step 7. Take the promocode to the reliance digital store and get the new jio sim card.


Hope this will helps....

Group Function or Aggregate Functions in Oracle

Group Function or Aggregate Functions:-


1. max()
2. min()
3. avg()
4. sum()
5. count(*)
6. count(column_name)
In all databases group functions are operated over number of values in a column and returns a single value.

1. max():-
It will return maximum values from a column
eg. sql> select max(sal) from emp;
output: 5400

2. min()
It will return minimum values from a column
eg. sql> select min(sal) from emp;
output: 800

3. avg()
It will return the average of number datatypes column
eg: sql> select avg(sal) from emp;
output: 2266.07143

In oracle by default all group functions ignores null values except count(*) function . if we want to count the null values we must use nvl() function.

eg. sql>select avg(nvl(comm)) from emp;
output: 157.142

4. sum()
it will return the sum of number datatypes column
eg. sql> select sum(sal) from emp;

5. count(*)
It will return the number of rows in a table including null values
eg. sql> select count(*) from emp;
output: 14

6. count(sal)
It will return the no. of not null values in a column.
eg. sql> select count(comm) from emp;
output: 4

eg. sql> select count(distinct(deptno)) from emp;
output: 4



Check Armstrong Number in Java

Check Armstrong Number in Java

Armstrong number is a three digit number that the sum of the cube of its individual digits is equal to the number itself. for eg. 371. 3*3*3+7*7*7+1*1*1

class CheckArmstrong{
 public static void main(String[] args)  {
   int a,b=0,temp;
   int input=153;
   temp=input;
   while(input>0)
   {
   a=input%10;
   input=input/10;
   b=b+(a*a*a);
   }
   if(temp==b)
   System.out.println("armstrong number");  
   else
       System.out.println("Not armstrong number");  
  }

Factorial Program in Java

Factorial Program in Java

Factorial is a product of all the positive integer less than or equal to the given value.

class PrintFactorial{
public static void main(String args[]){
 int a,factorial=1;
 int input=4;
 for(a=1;a<=input;a++){  
     factorial=factorial*a;  
 }  
 System.out.println("Factorial of "+input+" is: "+factorial);  
}
}  

Check Prime Number Program in Java

Check Prime Number Program in Java

The prime number is greater than 1 and whose factors are only 2 numbers 1 and the number itself. for eg. 2 3 5 7 11...


class CheckPrime{
public static void main(String args[]){
int a,b=0,flag=0;
int input=17;
b=input/2;
 for(a=2;a<=b;a++){
  if(input%a==0){
  System.out.println("Number is not prime");
  flag=1;
  break;
  }
 }
 if(flag==0)
 System.out.println("Number is prime");
}
}

Fibonacci Series Program in Java

Fibonacci Series Program in Java

In Fibonacci Series is the sum of the previous 2 numbers for eg.  0 1 1 2 3 5 8 13 21 34.......


class FibonacciSeries{
public static void main(String[] args)
{  
int no1=0,no2=1,no3,i, input=10;  
System.out.print(no1+" "+no2);  
    for(i=2;i<input;++i)
{  
 no3=no1+no2;  
 System.out.print(" "+no3);  
 no1=no2;  
 no2=no3;  
}  
}
}  

Palindrome Number program in java

Palindrome Number program in java

Palindrome number is same if it is reversed as well. live 121,212.12321, etc.


///Program Starts

class PalindromeNumber{
 public static void main(String args[]){
  int remainder,sum=0,temp,input=454;  //input to check the number.  

 
  temp=input;  
  while(input>0){  
   remainder=input%10;  // we get remainder
   sum=(sum*10)+remainder;  
   input=input/10;  
  }  
  if(temp==sum)  
   System.out.println("palindrome number ");  
  else  
   System.out.println("not palindrome");  
}
}

///Program Ends

Mortal Kombat X free Download

Mortal Kombat X

Mortal Kombat X free download full pc game.

Mortal Kombat X is developed by the High Voltage Software. Mortal Kombat X is released on 14th Apr 2015.
Mortal Kombat X is a fight between two players and can use different weapons, A from the previous release it has introduced some more new characters. And also the scorpian has retained.

Features:
You can use different parts of Environment as weapons.
You can use various types of attacks, moves and techniques.

System Requirements:

Operating System:  windows 7/8/10
Processor: Core i3/i5/i7
Ram: 2GB +
HDD: 40GB +
Graphics : 2GB +

Mortal Kombat Free Download
  Mortal Kombat X free download link. It is the direct link of Mortal Kombat X

Link: Download
Reliance Jio 4G

                        Reliance Jio has started offering the Jio sim cards to the selected samsung and xiaomi mi users with 90 days unlimited plan benefits. To avail this offer you have to download all the application from the MyJio app. Then only you will get the option to "Get Jio Sim".  Sometimes it is not visible , After installing all the application simply switch off the internet connection and open Myjio app then you will get the option of " Get Jio Sim". after getting the option simply enable the data. and proceed for process.

Jio has already partnered with the LYF mobile for the supply of handsets. Jio is offering the unlimited plan with the purchase of this handset....It is truly unlimited. No barring or speed capping for 90 days.

It has not released the plan till yet..but from some sources , it came to know that , it will offer 10 GB of data at 93 rs....

Grand Thief Auto 5

Grand Thief Auto 5 (gta 5)

GTA V is developed by rockstar and it is released in 14th April 2015.

Gta 5 direct download link with resume facility.

You can Download GTA 5 directly from the below link.
Download


Fix download for  GTA 5 windows 7, 8,8.1

Download

Grand Thief Auto Vice City free download


Grand Thief Auto Vice City free download full version

gta vice city

It is light weight games working in P4 pc as well.

Download GTA vice city

Download

Free Android 6.0 Marshmallow for pc download

Free Android 6.0 Marshmallow for pc download

Download Android 6.0 Marshmallow full iso offline installer for pc.

Android 6.0 Marshmallow is the latest operating system by google for smart phones. It is also released for the pc edition for x86 platform.

Features.
Battery Saving Features.
App Standby for saving battery.
Improved security.
bluetooth SAP for calling from remote devices.

System Requirement

OS:None
RAM: 512 MB
HDD: 2 GB


Direct download Android 6.0 marshmallow for pc full offline installer.

Download

Download Free Microsoft Expression Web 4

Download Free Microsoft Expression Web 4

Microsoft Expression Web 4 full Standalone ISO Free Download.

Microsoft Expression Web 4 is full of featured Application, which is used for creating web applications.

Creating a good looking website requires lots of time and tools. Microsoft Web Expression 4 is one of them which helps in creating websites within less time and efforts.

It helps in designing website from the beginning. 
It supports multiple programming languages like, php, html, JavaScript,Ajax and many more.

You can add animations, colors, and images with just some clicks.

You can install components as required.

Technical Details.
Full Name: Microsoft Expression Web 4
Setup file name : Web_Trial_en.exe
File Size : 100MB(Approx.)
License: Free ( Now Microsoft made it free for all).

Software Requirements.
OS: Win 7/8/10
RAM : 1GB
HDD: 512MB

Download free Full Standalone setup of Microsoft Expression Web 4.

Download

Sql Server 2014 Developer Edition Free Full ISO Download




Sql Server 2014 Developer Edition Offline Full ISO download.

SQL Server is developed by Microsoft corporation.It is designed so that it can run on any devices from lower end devices to large multiprocessor servers. 

Security and backup features have been improved.

Providing encryption and compression on backups.

Supports in-memory data processing for faster transactions.

Technical Details :
File Name: SQLServer2014SP1-FullSlipstream-x86-ENU.iso
Full Name: SQL Server 2014
Licence: Free Trial
Architecture: 32/64 bit

System Requirements
OS: Win 7/8/10
RAM: 512MB
HDD: 6GB

Download the SQL Server 2014 Developer Edition  Full Standalone ISO.

* Register on Microsoft Website to get free Developer Edition Licence.

Download

Download free Intel Parallel Studio XE 2016



Download the Intel Paralle Studio XE 2016 full Standalone offline installer.

Intel Parallel Studio is launched on 25th aug 2015 for High performance computing application. It helps the c++ Developers for deveoping high performance application with the help of optimized compileres, libraries, and threading error checking. 
It provides data access across MATLAB,SPARK and etc.

It has various new features like.
Math Library
Data Analytics Library
Threading Library
Numerical analysis Functions.

Helps in making more reliable softwares and applications.

Technical Details
Full Name : Intel Parallel Studio XE 2016
Architecture : 32/64 bit
Licence : free trial
Developers: HomePage 
File Size : 3GB(Approx.)

Minimum requirements
OS: Win 7/8/10
RAM: 1GB
HDD: 4 GB

Intel Parallel Studio XE 2016 standalone free download.

Download Link.
Intel Parallel Studio XE 2016 + Update 1.zip - 2.9 GB

Data Recovery or File Recovery Softwares.

Free Pandora Recovery Software download

Pandora Recovery Software

 Pandora Recovery Software finds and recover deleted files of any type for free. When the file is deleted from the hdd, actually the file is not erased from the hard disk, insted of it only the reference to the file in Master File Table is marked as deleted. Which means that we can recover the deleted file and make it visible once again.

It allows you to find and recover the recoverable deleted files from the hard-disk. You can easily recover any types of files with its extension. Pandora Recovery scan your hard-disk and creates the index file with the existing and deleted files and directories. Once the scanning is completed you can view and recover the deleted files. 
Even you can use search function to find the specific files into the directory. 

Pandora Recovery allows you to view the files before recovery, which saves the lot of time.

To download Visit
Download

Free 7 Data Recovery Software download

7-Data Recovery
It is the All in One data recovery software. It can recover the file under any condition. including accidentally deleted, damaged or from formatted hard-drive.You can use it to recover the files from usb storage, memory cards,mobile phones,etc.

With the free version of this software you can recover only 1 GB of data at a time.

Features:
Recovery of Accidentally deleted files.
Recovery from local and external devices
Recovery from deleted partitions

To download Visit:
Download

Free EaseUs Data Recovery Software


EaseUs Data Recovery Software

EaseUs Data Recovery Wizard is the best free data recovery software. It is capable of recovering the lost file from pc after accidentally deleted or from formatted pc.

EaseUS Data Recovery software is capable of recovering the data from the memory card, mp3 players, pen drives, and other types of storage media.
EaseUs provides simple to use interface, so that the novice can also understand easily.

EaseUs provides 2 types of scanning mode, quick and deep scan, with the quick scanning you can easily recover the deleted files. and with the deep scanning it is capable of recovering the inaccessible, formatted or lost files.

It supports pause and continue. with free version it can recover files upto 2 GB only.
EaseUs data recovery supports preview of the file before saving. You can specify the types of file before scanning.

To download Visit:
Download

Free Mini Tools Power Data Recovery software.


MiniTools Power Data Recovery Software
Power Data Recovery software is provided from minitools, it contains five modes. 
1. Undelete Recovery of files.
2. File Recovery from CD/DVD files.
3. File Recovery from digital Media
4. File Recovery from damaged partitions. 
5. File Recovery from the lost partitions.

As compared to other recovery softwares , it the capability to recover files from the CD/DVD Driver. Withe this free version you can recover only 1 GB of data.

To Download Visit:
Download

Date Functions in oracle

Date Functions:- 
The default date format is DD-MON-YY.
Oracle supports the following date functions.
1. sysdate
2. last_day()
3. add_months()
4. next_day()
5. months_between()

How to display current system date in oracle ?

Sysdate:-
It displays the current system date in oracle date format.ie. DD-MON-YY.
ex: 
sql> select sysdate from dual;
output:
28-04-2016

How to display last day of the month in oracle ?

last_day():-
It displays the last day of the specified month in oracle.

ex:
sql> select last_day(sysdate) from dual;
output:
30-apr-2016

How to add or substract months in oracle ?

add_months():-
It is used to add or substract the number of months of the specified date based on the second parameter.

ex:
sql> select add_months(sysdate,1) from dual;
output:
28-may-2016

ex 2:
sql> select add_months(sysdate,-1) from dual;
output:
28-mar-2016

How to display next day from the specified date ?

next_day():-
It is used to display the next occurence day from the specified date based on the second parameter.

ex: 
sql> select next_day(sysdate,'fri') from dual;
output:
29-Apr-2016

How to display the number of months in between the specified date ?

months_between():-
It is used to display the number of months in between the two specified dates.
* date1 must be greater than date2

ex:
sql> select months_between(sysdate,'10-jan-2016') from dual;
output:
3.60154981

* you can add date with any number.
* you can substract date with any number.
* you can not add two dates.
* you can substract two dates.

How to Run WhatsApp on pc ?


To run WhatsApp on pc, you have to download android virtualization software.

Follow the below links to download the android virtualization software

Link1

Link2

Andy Android Virtualization Software


Andy Android Virtualization Software

                              It is a virtualization software of android . It lets to connect your  mobile devices and desktop pc together. With this software there is no limitation in the storage capacity, it can extend max upto the free space in your pc.

It provides freedom to play all the android games to your pc.

Features:
It provides synchronization between desktop and mobile devices.
It allows you to connect windows with android apps for launching.
It allows you to download any app from any desktop browser to andy os.
Provides most upto dated Android.


You can use your phone as a remote controller while playing games. It enables to run all the communication related apps (whats app, skype, wechat,fb,etc) from desktop pc.

To download visit:
Download

Website:
http://www.andyroid.net/

Keyboard Shortcuts

Keyboard Short-cuts.

Alt + Tab
This command will switch between opened programs in forward directions only.ex. Suppose you have opened word,excel and powerpoint at a time, and working in excel, and want to switch to word. Then you can easily switch it by pressing Alt + tab.

Ctrl + Tab
This command is used to switch between opened tabs on the browser.

Shift + Alt + Tab
This command is used to switch between opened programs in backword directions.

Ctrl + BackSpace
This command is used to delete complete word at a time.

Ctrl + Right or Left
This command is used to move the cursor one word forward or backword.

Ctrl + S
This command is used to save the opened document.

Ctrl + Home
This will move the cursor to the beginening of the document.

Ctrl + End
This will move the cursor to the end of the document.

Ctrl + P
Opens the printing settings page for printing.

Ctrl + C / Ctrl + Insert
Both the above commands will copy the selected text or the selected items.

Ctrl + X 
This command is used to cut the selected text or items inseted of copy.

Ctrl + V / Shift + Insert
Both the above command is used to paste the copied text or the text which is present in the clipboard.

Ctrl + Z
This command is used to undo any changes.This command is possible to use multiple times.

Ctrl + Y
This command is used to redo any changes. It can be done as possible times.

Download Managers