tag:blogger.com,1999:blog-33857414762624083902023-12-03T10:38:17.989-08:00Love Java BytesLove.Learn.CodeBlog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.comBlogger84125tag:blogger.com,1999:blog-3385741476262408390.post-59881805343391181312018-04-18T10:41:00.000-07:002018-04-18T10:41:00.571-07:00Write a program to sort string date with time in java<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial, Helvetica, sans-serif;">Here we used the Collections class to sort the list and wrote a comparator to compare string dates to impose an ordering on a collection of string dates.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>Code:</b></span></div>
<pre class="prettyprint" style="background: #f0f0f0; border: 1px dashed #cccccc; color: black; font-family: "arial"; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;">
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.List;
public class SortDates {
public static void main(String[] args) {
List<string> strDts1 = new ArrayList<string>();
strDts1.add("25/01/2018 $ 02:17 PM");
strDts1.add("23/02/2018 $ 03:32 PM");
strDts1.add("23/02/2018 $ 11:47 AM");
strDts1.add("25/01/2018 $ 09:34 PM");
strDts1.add("23/02/2018 $ 07:18 AM");
strDts1.add("23/02/2018 $ 04:45 AM");
strDts1.add("25/01/2018 $ 08:29 PM");
strDts1.add("25/01/2018 $ 07:55 AM");
Collections.sort(strDts1, new Comparator<string>() {
DateFormat df = new SimpleDateFormat("dd/MM/yyyy '$' hh:mm a");
@Override
public int compare(String s1, String s2) {
try {
return df.parse(s1).compareTo(df.parse(s2));
} catch (ParseException e) {
throw new IllegalArgumentException(e);
}
}
});
System.out.println(strDts1);
List<string> strDts2 = new ArrayList<string>();
strDts2.add("25/01/2018 # 02:17 PM");
strDts2.add("23/02/2018 # 03:32 PM");
strDts2.add("23/02/2018 # 11:47 AM");
strDts2.add("25/01/2018 # 09:34 PM");
strDts2.add("23/02/2018 # 07:18 AM");
strDts2.add("23/02/2018 # 04:45 AM");
strDts2.add("25/01/2018 # 08:29 PM");
strDts2.add("25/01/2018 # 07:55 AM");
//Java 8
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd/MM/yyyy '#' hh:mm a");
Collections.sort(strDts2, (s1, s2) -> LocalDateTime.parse(s1, formatter).
compareTo(LocalDateTime.parse(s2, formatter)));
System.out.println(strDts2);
}
}
</string></string></string></string></string></code></pre>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>Output:
</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">[25/01/2018 $ 07:55 AM, 25/01/2018 $ 02:17 PM, 25/01/2018 $ 08:29 PM, 25/01/2018 $ 09:34 PM, 23/02/2018 $ 04:45 AM, 23/02/2018 $ 07:18 AM, 23/02/2018 $ 11:47 AM, 23/02/2018 $ 03:32 PM]</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">[25/01/2018 # 07:55 AM, 25/01/2018 # 02:17 PM, 25/01/2018 # 08:29 PM, 25/01/2018 # 09:34 PM, 23/02/2018 # 04:45 AM, 23/02/2018 # 07:18 AM, 23/02/2018 # 11:47 AM, 23/02/2018 # 03:32 PM]</span><br />
<div>
<br /></div>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-12918247724333829922016-03-20T10:27:00.000-07:002016-03-20T10:27:52.680-07:00Write a program of Fibonacci series using Recursion in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;">Code:</span></b><br />
<pre class="prettyprint" style="background: #f0f0f0; border: 1px dashed #cccccc; color: black; font-family: "arial"; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> import java.util.Scanner;
public class FibonacciRecursion {
public static void main(String args[]) {
Scanner scanner = new Scanner(System.in);
System.out.println("Enter the number for Fibonacci series:");
int num = scanner.nextInt();
System.out.println("Fibonacci Series:");
for (int i=0;i<num;i++) {
System.out.print(fibonacci(i) + ",");
}
scanner.close();
}
public static int fibonacci(int num) {
if (num == 0) {
return 0;
} else if (num == 1) {
return 1;
} else {
return fibonacci(num-2) + fibonacci(num-1);
}
}
}
</code></pre>
<b><span style="font-family: "arial" , "helvetica" , sans-serif;">Output :</span></b><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">Enter the number for Fibonacci series:<br />8<br />Fibonacci series:<br />0,1,1,2,3,5,8,13,</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-61741225492800492962015-07-13T02:50:00.000-07:002015-07-23T06:18:00.289-07:00JSP declaration tag<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">A JSP declaration is used to declare variables and methods in a page’s scripting language.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">The syntax for a declaration is as follows:</span><br />
<b><span style="font-family: Arial,Helvetica,sans-serif;"><%! scripting-language-declaration %></span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Example for declaring Variable:</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;">index.jsp
</span><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> <html>
<body>
<%! int a=5; %>
<%= "Value of Integer a is "+ (++a) %>
</body>
</html>
</code></span></pre>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Example for declaring method :</b> </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">index.jsp </span><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> <HTML>
<BODY>
<%!
void getName()
{
System.out.println( "LoveJavaBytes" );
}
%>
Name is : <%= getName() %>
</BODY>
</HTML>
</code></span></pre>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-49456001130095986812015-07-13T02:33:00.003-07:002015-07-23T06:18:00.272-07:00JSP expression tag<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">A JSP expression is used to insert the value of a scripting language expression, converted into a string, into the data stream returned to the client using response object.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">The syntax for an expression is as follows:</span><br />
<b><span style="font-family: Arial,Helvetica,sans-serif;"><%= scripting-language-expression %></span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Example of JSP expression Tag :</b></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">On index.jsp, user enters name that send as request to user.jsp which prints username as output.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">index.jsp
</span><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> <html>
<body>
<form action="user.jsp">
<input type="text" name="username">
<input type="submit" value="Submit"><br/>
</form>
</body>
</html>
</code></span></pre>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">user.jsp
</span><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> <html>
<body>
<% ="Welcome! "+ request.getParameter("username") %>
</body>
</html> </code></span></pre>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-74731076888405246012015-07-09T02:13:00.000-07:002015-07-23T06:11:19.024-07:00Write a program to draw Pyramids using nested for loops in java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">We are providing here code for drawing 6 Pyramids with the help of inner or nested for loops in Java.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Code :</span></b><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> public class PrintPyramid {
public static void main(String args[])
{
//Pyramid One
for(int i=1;i<=5;i++)
{
for(int j=1;j<=i;j++)
{
System.out.print("@ ");
}
System.out.println();
}
//Pyramid Two
for(int i=1;i<=5;i++)
{
for(int j=1;j<=5-i;j++)
{
System.out.print("# ");
}
System.out.println();
}
//Pyramid Three
for(int i=1;i<=5;i++)
{
for(int j=1;j<=5-i;j++)
{
System.out.print(j);
}
System.out.println();
}
//Pyramid Four
for(int i=1;i<=5;i++)
{
for(int j=1;j<=i;j++)
{
System.out.print(i);
}
System.out.println();
}
//Pyramid Five
for(int i=1;i<=5;i++)
{
for(int j=1;j<=5-i;j++)
{
System.out.print(" ");
}
for(int k=1;k<=i;k++)
{
System.out.print("% ");
}
System.out.println();
}
//Pyramid Six
for(int i=1;i<=5;i++)
{
for(int j=1;j<=5-i;j++)
{
System.out.print(" ");
}
for(int k=1;k<=i;k++)
{
System.out.print("$ ");
}
for(int l=1;l<i;l++)
{
System.out.print("$ ");
}
System.out.println();
}
}
}
</code></span></pre>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Output :</span></b><br />
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDNynaJdiXg-SNCfvzi6k1T3uKwL_OSm8LLvP1DJp48z_c5iEiORb0EImg5cPIeKAjEo1T6MhJl4q5J5JWK9RHC27lLelwGgiyPrSJySKHDoROJMx5QyhFdHsnzQQiUHCpSp1pBoib/s1600/pyramids+codes+in+java+using+inner+nested+for+loops.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDNynaJdiXg-SNCfvzi6k1T3uKwL_OSm8LLvP1DJp48z_c5iEiORb0EImg5cPIeKAjEo1T6MhJl4q5J5JWK9RHC27lLelwGgiyPrSJySKHDoROJMx5QyhFdHsnzQQiUHCpSp1pBoib/s1600/pyramids+codes+in+java+using+inner+nested+for+loops.png" /></a></span></div>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-64205507361249046202015-07-05T02:58:00.005-07:002015-07-23T06:11:19.018-07:00Write FizzBuzz Program in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">Print numbers from 1 to 20, where print "Fizz" for multiple of 3, "Buzz" for multiple of 5, "FizzBuzz" for multiple of 3 and 5, and print numbers for others.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Code:</span></b><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> public class PrintMultiple {
public static void main(String args[])
{
printMulti();
}
public static void printMulti()
{
for(int i=1;i<=20;i++)
{
//Method one
/*if(i%3==0)
System.out.println("Fizz");
else if(i%5==0)
System.out.println("Buzz");
else if(i%15==0)
System.out.println("FizzBuzz");
else
System.out.println(i);*/
//Method Two
if(i%3==0 && i%5!=0)
System.out.println("Fizz");
if(i%5==0 && i%3!=0)
System.out.println("Buzz");
if(i%15==0) /* or else if(i%3==0 && i%5==0)*/
System.out.println("FizzBuzz");
if(i%3!=0 && i%5!=0 && i%15!=0)
System.out.println(i);
}
}
}
</code></span></pre>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Output :</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;">1<br />2<br />Fizz<br />4<br />Buzz<br />Fizz<br />7<br />8<br />Fizz<br />Buzz<br />11<br />Fizz<br />13<br />14<br />FizzBuzz<br />16<br />17<br />Fizz<br />19<br />Buzz</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-8413287139311623352015-07-05T02:50:00.001-07:002015-07-23T06:11:19.030-07:00Write a program to print Fibonacci series in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">Below is a program through which we are printing Fibonacci series in Java.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Code:</span></b><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> import java.util.Scanner;
public class Fibonacci {
public static void main(String args[])
{
int num;
Scanner scanner=new Scanner(System.in);
System.out.println("Enter the number for Fibonacci series:");
num=scanner.nextInt();
findFibo(num);
}
public static void findFibo(int num)
{
int fibo[]=new int[num];
fibo[0]=0;
fibo[1]=1;
for(int i=2;i<num;i++)
{
fibo[i]=fibo[i-2]+fibo[i-1];
}
System.out.println("Fibonacci series");
for(int i=0;i<num;i++)
{
System.out.print(fibo[i]+",");
}
}
}
</code></span></pre>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Output :</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Enter the number for Fibonacci series:<br />8<br />Fibonacci series<br />0,1,1,2,3,5,8,13,</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-54098041861708510482015-07-05T02:45:00.000-07:002015-07-23T06:11:19.002-07:00Write a program to print factorial of a number in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">The following is the code for printing Factorial of a number.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Code:</span></b><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> import java.util.Scanner;
public class Factorial {
public static void main(String args[])
{ int num;
Scanner in=new Scanner(System.in);
System.out.println("Enter a Number");
num=in.nextInt();
System.out.println("Factorial of "+num+" is : "+findFact(num));
}
public static int findFact(int num)
{
int fact=1;
for(int i=1;i<=num;i++)
fact=fact*i;
return fact;
}
}
</code></span></pre>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Output :</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Enter a Number</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">5</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Factorial of 5 is : 120</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-13678643384726595642015-07-02T14:32:00.000-07:002015-07-23T06:11:18.971-07:00Write a program to Reverse a Number using array in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">Here we are using array to reverse a number in Java.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Code:
</span></b><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> public class ReverseNumberA {
public static void main(String args[])
{
reverseNum(1203450);
}
public static void reverseNum(int num)
{
int length=String.valueOf(num).length();
int number[]=new int[length];
for(int n=0;n<=number.length-1;n++)
{
number[n]=num%10;
num=num/10;
}
System.out.println("Number after reverse :");
for(int n:number)
{
System.out.print(n);
}
}
}
</code></span></pre>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Output:</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Number after reverse :<br />0543021</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-46728573221429839422015-07-02T14:25:00.002-07:002015-07-23T06:11:18.990-07:00Write a program to Reverse a Number in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">Use the below given code to reverse a number in Java.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Code:</span></b><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> public class ReverseNumber {
public static void main(String args[])
{
System.out.println("Number after reverse :"+reverseNum(12345));
}
public static int reverseNum(int num)
{
int reverse=0;
while(num>0)
{
reverse=reverse*10 + num%10;
num=num/10;
}
return reverse;
}
}
</code></span></pre>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Output :</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Number after reverse :54321</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-21936641996842567122015-07-02T14:12:00.000-07:002015-07-23T06:11:18.983-07:00Write a program to find index where sum are equal from both ends in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">We are using an array of numbers and Printing both the index(start and end index position) where we find out that sum of numbers from both the ends are equal.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Code :</span></b><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> public class FindEqualSum {
public static void main(String args[])
{
int a[]={4,4,6,7,4,3};
findIndex(a);
}
public static void findIndex(int[] a)
{
int startindex=0;
int endindex=a.length-1;
int startsum=0;
int endsum=0;
while (true) {
if (startsum > endsum) {
endsum = endsum + a[endindex--];
} else {
startsum = startsum + a[startindex++];
}
if(startindex > endindex)
{
if (startsum == endsum) {
System.out.println("Match found on Start Index:"+ startindex);
System.out.println("Match found on End Index:"+ endindex);
break;
} else {
System.out.println("no match found");
break;
}
}
}
}
}
</code></span></pre>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Output:</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Match found on Start Index:3<br />Match found on End Index:2</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-1505420013431279942015-07-02T13:56:00.000-07:002015-07-23T06:11:18.978-07:00Write a program to Reverse a String using Recursion in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">We are writing a program using Recursion method for Reversing a String.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Code:</b></span><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> public class RecursiveReverseStr {
public static void main(String args[])
{
System.out.println(reverseStr("LoveJavaBytes"));
}
public static String reverseStr(String str)
{
String reverse="";
/* if (str.length() == 1)
return str;
else {
reverse = reverse + str.charAt(str.length() - 1)
+ reverseStr(str.substring(0, str.length() - 1));
return reverse;
}*/
if(str.length() >= 1)
{
reverse = reverse + str.charAt(str.length() - 1)
+ reverseStr(str.substring(0, str.length() - 1));
}
return reverse;
}
}
</code></span></pre>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Output :</b></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">setyBavaJevoL</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-60865253163096249442015-07-02T13:43:00.001-07:002015-07-23T06:11:19.013-07:00Write a program to Reverse a String in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">You can simply use <b>for</b> loop for printing reverse string using <b>charAt(index)</b> method.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>public char charAt(int index)</b></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Returns the char value at the specified index. An index ranges from 0 to length() - 1. The first char value of the sequence is at index 0, the next at index 1, and so on, as for array indexing.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Code:</span></b><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> public class ReverseString {
public static void main(String args[])
{
strReverse("LoveJavaBytes");
}
public static void strReverse(String str)
{
int size=str.length();
for(int i=size-1;i>=0;i--)
System.out.print(str.charAt(i));
}
}
</code></span></pre>
<b><span style="font-family: Arial,Helvetica,sans-serif;">Output:</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;">setyBavaJevoL</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-5146761781307907532015-07-02T13:27:00.000-07:002015-07-23T06:11:18.997-07:00Write a program to find Duplicate Number in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">Here we are adding 1 to 30 numbers in the List and one of the series number 29 is repeated. We need to find out that repeated or duplicate number.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Code :</b></span><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> import java.util.ArrayList;
import java.util.List;
public class FindDuplicateNum {
public static void main(String args[])
{
List<Integer> numbers=new ArrayList<Integer>();
for(int i=1;i<=30;i++)
{
numbers.add(i);
}
numbers.add(29);
System.out.println("Duplicate Number is:"+ duplicateNum(numbers));
}
public static int sum(List<Integer> numbers)
{ int sum=0;
for(int num:numbers)
{
sum+=num;
}
return sum;
}
public static int duplicateNum(List<Integer> numbers)
{
int n=numbers.size()-1;
int total=n*(n+1)/2;
int sum=sum(numbers);
return sum-total;
}
}
</code></span></pre>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Output:</b></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Duplicate Number is:29</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-55678569576917517182015-07-02T12:59:00.000-07:002015-07-23T06:11:19.008-07:00Write a program for Bubble Sort in Java<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">Bubble sort uses simple algorithm for sorting adjacent numbers with swapping each other by comparing both values one by one, which print order in the right manner. You can see the implemented code for Bubble Sort :</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Code :</b></span><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> public class BubbleSort {
public static void main(String args[])
{
int a[]={4,3,2,0,5,1};
System.out.println("Before Bubble Sort");
for(int i=0;i<a.length;i++)
{
System.out.print(a[i] + ",");
}
System.out.print("\n");
bubbleSort(a);
System.out.println("After Bubble Sort");
for(int i=0;i<a.length;i++)
{
System.out.print(a[i] + ",");
}
}
public static void bubbleSort(int a[])
{
int temp=0;
int n=a.length;
for(int i=0;i<n;i++)
{
for(int j=0;j<n-i-1;j++)
{
if(a[j]>a[j+1])
{
temp=a[j];
a[j]=a[j+1];
a[j+1]=temp;
}
}
}
}
}
</code></span></pre>
<span style="font-family: Arial,Helvetica,sans-serif;"></span>
<span style="font-family: Arial,Helvetica,sans-serif;"></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Output :</b></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Before Bubble Sort</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">4,3,2,0,5,1,</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">After Bubble Sort</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">0,1,2,3,4,5,</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-5498147232480337392015-06-29T03:32:00.003-07:002016-03-20T10:34:34.037-07:00Scripting elements in JSP Pages<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "arial" , "helvetica" , sans-serif;">We can use Java Programming Language statements in JSP pages using scripting elements. There are three types of scripting elements used in JSP.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>1. <a href="http://lovejavabytes.blogspot.com/2015/06/scripting-elements-in-jsp-scriplet-tag.html">Scriplet Tag</a></b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>2. <a href="http://lovejavabytes.blogspot.com/2015/07/jsp-expression-tag.html">Expression Tag</a></b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>3. <a href="http://lovejavabytes.blogspot.com/2015/07/jsp-declaration-tag.html">Declaration Tag</a></b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">There are three ways to create and use objects in scripting elements:</span><br />
<ul style="text-align: left;">
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Instance</b> and <b>class variables</b> of the JSP page’s servlet class are created in <b>declarations</b> and accessed in <b>scriptlets</b> and <b>expressions.</b></span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Local variables</b> of the JSP page’s servlet class are created and used in <b>scriptlets</b> and <b>expressions</b>.</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Attributes of scope objects</b> are created and used in <b>scriptlets</b> and <b>expressions.</b></span></li>
</ul>
<span style="color: #cc0000; font-family: "arial" , "helvetica" , sans-serif;"><b><br /></b></span>
<span style="color: #cc0000; font-family: "arial" , "helvetica" , sans-serif;"><b>JSP Scriptlets</b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">A JSP scriptlet is used to contain any code fragment that is valid for the scripting language used in a page. The syntax for a scriptlet is as follows:</span><br />
<b style="font-family: Arial, Helvetica, sans-serif;"><%</b><b style="font-family: Arial, Helvetica, sans-serif;"> <i>scripting-language-statements or Java code </i></b><b style="font-family: Arial, Helvetica, sans-serif;">%></b><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Example of JSP scriplet Tag :</b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">On index.jsp, user enters name that send as request to user.jsp which prints username as output.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">index.jsp
</span><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"><span style="font-family: "arial" , "helvetica" , sans-serif;"> <html>
<body>
<form action="user.jsp">
<input type="text" name="username">
<input type="submit" value="Submit"><br/>
</form>
</body>
</html>
</span></code></pre>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">user.jsp
</span><br />
<pre class="prettyprint" style="background: rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"><span style="font-family: "arial" , "helvetica" , sans-serif;"> <html>
<body>
<%
String uname=request.getParameter("username");
out.print("Welcome! "+uname);
%>
</body>
</html> </span></code></pre>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-52409971895322869972015-06-22T07:07:00.000-07:002015-07-23T06:52:03.591-07:00Create first JSP page in Eclipse IDE with Apache Tomcat Server<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">Following steps you need to follow to create your first JSP page in Eclipse IDE.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Step 1:</b> Create Server by following steps :</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Click on servers and then click on link to create a server.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjF1lka6HOblaFQ8KeYdXy_EDVohz5eHYIM6MlPCjYa1CySf9A8tZEC660jYJ1wvJMM9vSApPYlmBDHsQTTdaX1j67IKgrKeeJf-uK4_eMnhQDZFbFWUz9C78pXU9LvR1tgtiCvROXM/s1600/1+create+apache+tomcat+server.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="332" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjF1lka6HOblaFQ8KeYdXy_EDVohz5eHYIM6MlPCjYa1CySf9A8tZEC660jYJ1wvJMM9vSApPYlmBDHsQTTdaX1j67IKgrKeeJf-uK4_eMnhQDZFbFWUz9C78pXU9LvR1tgtiCvROXM/s640/1+create+apache+tomcat+server.png" width="640" /></a></span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"> </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Select Tomcat version in Apache folder which is installed in your system.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiv0XauGprCQGEc4Ih4vPMrSIJY8rc7dFRa_1ymIOEdEsxGOObZo3tFR8SDNiY-7DgD1-_Vn5UHhs0AhuRR7yjRpZcd3sL7J6Lw7GzNy11s4PBPdL_4fb4jqSWNZM-dYduM0d0PvnrX/s1600/2+Select+Tomcat+version+in+Apache+folder+which+is+installed+in+your+system.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiv0XauGprCQGEc4Ih4vPMrSIJY8rc7dFRa_1ymIOEdEsxGOObZo3tFR8SDNiY-7DgD1-_Vn5UHhs0AhuRR7yjRpZcd3sL7J6Lw7GzNy11s4PBPdL_4fb4jqSWNZM-dYduM0d0PvnrX/s640/2+Select+Tomcat+version+in+Apache+folder+which+is+installed+in+your+system.png" width="640" /></a></span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">Browse the Tomcat Server folder and Click Finish.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidOyFsEvgQSdINisyjPJJhnAibRNlSzQQfcIgyqE5ZnjLkS_GHht3NgmG_T_q3Wqa9gxgT7MVPKBzsleekXvXTLxhs0igVLYtdj84sT3XOtzI76xbFDyRby4yOAI_sOYhTMRzzjOWy/s1600/3+Browse+the+Tomcat+Server+folder+and+Click+Finish.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidOyFsEvgQSdINisyjPJJhnAibRNlSzQQfcIgyqE5ZnjLkS_GHht3NgmG_T_q3Wqa9gxgT7MVPKBzsleekXvXTLxhs0igVLYtdj84sT3XOtzI76xbFDyRby4yOAI_sOYhTMRzzjOWy/s640/3+Browse+the+Tomcat+Server+folder+and+Click+Finish.png" width="640" /></a></span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Step 2:</b> File > New > Dynamic Web Project</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1N2z2DiBHQR7YF3UyjL1o_gz92hMxQsyknUL9pK8EcfOcDd_DbBR9sbmNd3WUdXHKCrUC0-DBISB6sQZOlCq4vssO0ebExR1xrqDk6FCBEs139nZf7audfuTbExp5q9z7um0pnHWb/s1600/4+create+dynamic+web+project+in+eclipse+ide.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1N2z2DiBHQR7YF3UyjL1o_gz92hMxQsyknUL9pK8EcfOcDd_DbBR9sbmNd3WUdXHKCrUC0-DBISB6sQZOlCq4vssO0ebExR1xrqDk6FCBEs139nZf7audfuTbExp5q9z7um0pnHWb/s640/4+create+dynamic+web+project+in+eclipse+ide.png" width="640" /></a></span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">Give name HelloJSP then click Next > Next > Finish</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZNMx5JQp7zlbZyBizsFiHZSami6TfBcSmXwpnMluZiu5KIHj16hhR2X8jYCDhf0pA_vNnsvPk9C9RG5K0kJwbXzRqnn6EukRacQnTiN-1GmQyFmYqIn9x1Luxa2dC3pWIqQR9ng-d/s1600/5+name+dynamic+web+project.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="342" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZNMx5JQp7zlbZyBizsFiHZSami6TfBcSmXwpnMluZiu5KIHj16hhR2X8jYCDhf0pA_vNnsvPk9C9RG5K0kJwbXzRqnn6EukRacQnTiN-1GmQyFmYqIn9x1Luxa2dC3pWIqQR9ng-d/s640/5+name+dynamic+web+project.png" width="640" /></a></span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRNXWmf1qD8IYl_ULVmVEjxi5o4AjKCBh4IxvzTgg2fw32QEGd7omddDqkTsHZedqh1SwJbb7OBTT6M6c36p8D8bg6c53SdFAsSfHTWxMnatsiv8s-CJwk_iTsmShZFWnLjWTf4neg/s1600/6+jsp+project+src+folder.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRNXWmf1qD8IYl_ULVmVEjxi5o4AjKCBh4IxvzTgg2fw32QEGd7omddDqkTsHZedqh1SwJbb7OBTT6M6c36p8D8bg6c53SdFAsSfHTWxMnatsiv8s-CJwk_iTsmShZFWnLjWTf4neg/s640/6+jsp+project+src+folder.png" width="640" /></a></span></div>
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihhtCy9gTF3o0Z-3xkdmj_Tlyf2Dfwd5Nocf3PnsnCMjTMeg_CQgrYfsA3VfRnfQxa_YU2zFxKFKk3HOGVOhf36cU1sxLD4tsDZO_wfKCIV353sRSa5R70I6Wxb83ypwp2zA6t5ZD1/s1600/7+finish+jsp+project.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihhtCy9gTF3o0Z-3xkdmj_Tlyf2Dfwd5Nocf3PnsnCMjTMeg_CQgrYfsA3VfRnfQxa_YU2zFxKFKk3HOGVOhf36cU1sxLD4tsDZO_wfKCIV353sRSa5R70I6Wxb83ypwp2zA6t5ZD1/s640/7+finish+jsp+project.png" width="640" /></a></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmmeLHJei69y3ge7H6s6eUChWUESYS3PFtgdcGX1RVEwPt995QdxqOPZo9bOezuv0RfziyMu9rkVM3tD7xARhzIlvtv_AsEfMRHbVVbaqQaWv6MU7ivBr4E6S_oqFB9cL4e4sKG_pe/s1600/8+project+view+in+Project+explorer.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmmeLHJei69y3ge7H6s6eUChWUESYS3PFtgdcGX1RVEwPt995QdxqOPZo9bOezuv0RfziyMu9rkVM3tD7xARhzIlvtv_AsEfMRHbVVbaqQaWv6MU7ivBr4E6S_oqFB9cL4e4sKG_pe/s640/8+project+view+in+Project+explorer.png" width="640" /></a></span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Step 3: </b>Create JSP File</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">WebContent > New > JSP File</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJzRSjIOTu9AFgD4rlAzjET9Wf5RolnIjaUCD-IqU3S2LjT-LDr8urk0jGwBfPEeLeCZXO-UiNqLLQCiQAAFyzxzuzvtly0KFw_bhz8Msf6grCJs64X2c528SCCTM3JGbmkt7DaN_o/s1600/9+create+jsp+file+in+dnamic+web+project.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJzRSjIOTu9AFgD4rlAzjET9Wf5RolnIjaUCD-IqU3S2LjT-LDr8urk0jGwBfPEeLeCZXO-UiNqLLQCiQAAFyzxzuzvtly0KFw_bhz8Msf6grCJs64X2c528SCCTM3JGbmkt7DaN_o/s640/9+create+jsp+file+in+dnamic+web+project.png" width="640" /></a></span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">Give name index.jsp then click Next > Finish</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi277ydQHT_RUqwbqczTYAjzD_NVwIQYUC-O5_m2bHCUVKh57D2ba9YdN85psttP7F4g6MGwhyS2oJ_-GLl8xFgpVfmc9ibMQHFGDR-cYA4HVAyCx4BkrXj0ib1sRkf7qFhz3hk3w3x/s1600/10+name+jsp+file.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi277ydQHT_RUqwbqczTYAjzD_NVwIQYUC-O5_m2bHCUVKh57D2ba9YdN85psttP7F4g6MGwhyS2oJ_-GLl8xFgpVfmc9ibMQHFGDR-cYA4HVAyCx4BkrXj0ib1sRkf7qFhz3hk3w3x/s640/10+name+jsp+file.png" width="640" /></a></span></div>
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Write some code inside it.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwjrVCDIGfaZ1POOuX6aWzzyqXUZeKam-nV5DOxQrtDEpnjfvKpOmnrvV4tCah_eFYylnxGPRorTyHBQDDZ_X23SfqFcQJ_K5vsdgvN73IgHMJyaI-TQBln8uTWJpXC0fkfNFHyMI7/s1600/11+write+code+inside+JSP+page.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="344" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwjrVCDIGfaZ1POOuX6aWzzyqXUZeKam-nV5DOxQrtDEpnjfvKpOmnrvV4tCah_eFYylnxGPRorTyHBQDDZ_X23SfqFcQJ_K5vsdgvN73IgHMJyaI-TQBln8uTWJpXC0fkfNFHyMI7/s640/11+write+code+inside+JSP+page.png" width="640" /></a></span></div>
<b><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></b>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Step 4:</b> Deploy it over the Server</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Right Click on Project Name > Run As > Run on Server</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_xCfvXHjK879xIduqpM-NUFIxmDg7ddHRaFTZbqPiviA2QjnS4EwJaBXJZm-SviALwxtuD0BMItSF6L38gLip_IiiXxLDyE1vzjgobhsWbbgRK0pkCHk-8IFbZjztrOQN8px9WIMm/s1600/12+deploy+over+tomcat+server.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="342" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_xCfvXHjK879xIduqpM-NUFIxmDg7ddHRaFTZbqPiviA2QjnS4EwJaBXJZm-SviALwxtuD0BMItSF6L38gLip_IiiXxLDyE1vzjgobhsWbbgRK0pkCHk-8IFbZjztrOQN8px9WIMm/s640/12+deploy+over+tomcat+server.png" width="640" /></a></span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">Click on Finish.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKCYJvM4frkG8tIqJtQqzH6Yi_Lb1nkX5DZODZlXLehgwXBCl6bHVhqS86tu9O4kKKrHqgdsaMNGXNIAY7-3UO_lTotQrg_jNFzNSDQYKaPgPlDqKubPecQzvzr8Xy3E3PtgL8Q6xG/s1600/13+click+on+finish+to+run+tomcat+server.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKCYJvM4frkG8tIqJtQqzH6Yi_Lb1nkX5DZODZlXLehgwXBCl6bHVhqS86tu9O4kKKrHqgdsaMNGXNIAY7-3UO_lTotQrg_jNFzNSDQYKaPgPlDqKubPecQzvzr8Xy3E3PtgL8Q6xG/s640/13+click+on+finish+to+run+tomcat+server.png" width="640" /></a></span></div>
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">Output of your First JSP page on Web Browser.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1eP_vAna7vyesYpSH-RBviPsb9Yc7AB-jSMiYvVKm3XJmwLyp-Me5xB6LzaXnvqfxq81r8Vpy6b3Km7c9pE6ibEk0TdOcTYUZKqY8X6-gByYy0KAepSQWOmQws4gDS4QwH8YdOlal/s1600/14+Output+of+your+First+JSP+page+on+Web+Browser.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1eP_vAna7vyesYpSH-RBviPsb9Yc7AB-jSMiYvVKm3XJmwLyp-Me5xB6LzaXnvqfxq81r8Vpy6b3Km7c9pE6ibEk0TdOcTYUZKqY8X6-gByYy0KAepSQWOmQws4gDS4QwH8YdOlal/s640/14+Output+of+your+First+JSP+page+on+Web+Browser.png" width="640" /></a></span></div>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-32530676499337695502015-06-21T12:54:00.000-07:002015-07-23T06:18:00.267-07:00JavaServer Pages (JSP) API Packages<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;">JavaServer Pages API has the following packages :</span><br />
<ol style="text-align: left;">
<li><span style="font-family: Arial,Helvetica,sans-serif;"><b>javax.servlet.jsp</b></span></li>
<li><span style="font-family: Arial,Helvetica,sans-serif;"><b><b>javax.servlet.jsp.tagext</b> </b></span></li>
</ol>
<div style="text-align: left;">
<span style="font-family: Arial,Helvetica,sans-serif;">
<span style="color: #cc0000;"><b><span style="font-size: large;">Package javax.servlet.jsp </span></b></span></span></div>
<div style="text-align: left;">
<br /></div>
<span style="font-family: Arial,Helvetica,sans-serif;">Following are the <b>interfaces</b> include by javax.servlet.jsp package.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>1. HttpJspPage :</b> The HttpJspPage interface describes the interaction that a JSP Page Implementation Class must satisfy when using the HTTP protocol.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Method of HttpJspPage interface: (a) </b></span><span style="font-family: Arial,Helvetica,sans-serif;"><b>public void _jspService()</b></span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>(a) public void _jspService() :</b> The _jspService()method corresponds to the body of the JSP page. This method is defined automatically by the JSP container and should never be defined by the JSP page author. _ (underscore) stands that this method can not be override.
</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>2. JspPage :</b> The JspPage interface describes the generic interaction that a JSP Page Implementation class must satisfy; pages that use the HTTP protocol are described by the HttpJspPage interface.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>Methods of JspPage interface: (a) </b></span><span style="font-family: Arial,Helvetica,sans-serif;"><b>public void jspInit () (b) </b></span><span style="font-family: Arial,Helvetica,sans-serif;"><b>public void jspDestroy()</b></span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>(a) public void jspInit () : </b>The jspInit() method is invoked when the JSP page is initialized. It is the responsibility of the JSP implementation that at this point invocations to the getServletConfig() method will return the desired value. A JSP page can override this method by including a definition for it in a declaration element. A JSP page should redefine the init() method from Servlet. </span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>(b) public void jspDestroy() : </b>The jspDestroy() method is invoked when the JSP page is about to be destroyed. A JSP page can override this method by including a definition for it in a declaration element. A JSP page should redefine the destroy() method from Servlet.
</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">Following are the <b>classes</b> include by javax.servlet.jsp package.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>1. JspEngineInfo :</b> The JspEngineInfo is an abstract class that provides information on the current JSP engine.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>2. JspFactory :</b> The JspFactory is an abstract class that defines a number of factory methods available to a JSP page at runtime for the purposes of creating instances of various interfaces and classes used to support the JSP implementation.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>3. JspWriter :</b> The actions and template data in a JSP page is written using the JspWriter object that is referenced by the implicit variable out which is initialized automatically using methods in the PageContext object.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>4. PageContext :</b> A PageContext instance provides access to all the namespaces associated with a JSP page, provides access to several page attributes, as well as a layer above the implementation details.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">Following are the <b>exceptions</b> include by javax.servlet.jsp package.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>1. JspException : </b>A generic exception known to the JSP engine; uncaught JspExceptions will result in an invocation of the errorpage machinery.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>2. JspTagException : </b>Exception to be used by a Tag Handler to indicate some unrecoverable error.</span><br />
<h2>
<span style="font-family: Arial,Helvetica,sans-serif;"> </span></h2>
<div style="text-align: left;">
<span style="color: #cc0000;"><b><span style="font-family: Arial,Helvetica,sans-serif; font-size: large;">Package javax.servlet.jsp.tagext </span></b></span></div>
<div style="text-align: left;">
<br /></div>
<span style="font-family: Arial,Helvetica,sans-serif;">Following are the<b> interfaces</b> include by javax.servlet.jsp.tagext package.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>1. BodyTag :</b> The BodyTag interface extends IterationTag by defining additional methods that let a tag handler manipulate the content of evaluating its body.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>2. IterationTag : </b>The IterationTag interface extends Tag by defining one additional method that controls the reevaluation of its body.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>3. Tag :</b> The interface of a simple tag handler that does not want to manipulate its body.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>4. TryCatchFinally :</b> The auxiliary interface of a Tag, IterationTag or BodyTag tag handler that wants additional hooks for managing resources.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;">Following are the <b>classes</b> include by javax.servlet.jsp.tagext package.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><b>1. BodyContent :</b> An encapsulation of the evaluation of the body of an action so it is available to a tag handler.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>2. BodyTagSupport : </b>A base class for defining tag handlers implementing BodyTag.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>3. PageData :</b> Translation-time information on a JSP page.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>4. TagAttributeInfo :</b> Information on the attributes of a Tag, available at translation time.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>5. TagData :</b> The (translation-time only) attribute/value information for a tag instance.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>6. TagExtraInfo : </b>Optional class provided by the tag library author to describe additional translation-time information not described in the TLD.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>7. TagInfo :</b> Tag information for a tag in a Tag Library; This class is instantiated from the Tag Library Descriptor file (TLD) and is available only at translation time.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>8. TagLibraryInfo :</b> Translation-time information associated with a taglib directive, and its underlying TLD file.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>9. TagLibraryValidator :</b> Translation-time validator class for a JSP page.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>10. TagSupport : </b>A base class for defining new tag handlers implementing Tag.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>11. TagVariableInfo :</b> Variable information for a tag in a Tag Library; This class is instantiated from the Tag Library Descriptor file (TLD) and is available only at translation time.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>12. ValidationMessage :</b> A validation message from a TagLibraryValidator.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>13. VariableInfo :</b> Information on the scripting variables that are created/modified by a tag (at run-time).</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-25655363483478455432015-06-21T02:54:00.002-07:002015-07-23T06:18:00.261-07:00Life cycle of JavaServer Pages (JSP)<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;">A JSP page services requests as a servlet. Thus, the life cycle and many of the capabilities of JSP pages (in particular the dynamic aspects) are determined by Java Servlet technology.</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;">When a request is mapped to a JSP page, the web container first checks whether the JSP page’s servlet is older than the JSP page. If the servlet is older, the web container translates the JSP page into a servlet class and compiles the class. During development, one of the advantages of JSP pages over servlets is that the build process is performed automatically.</span></div>
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-family: Arial,Helvetica,sans-serif;">The steps in the life cycle of jsp page are:</span></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-family: Arial,Helvetica,sans-serif;"> </span> </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>1. Translation</b> of JSP page into Servlet</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>2. Compilation</b> of Translated JSP pages (which creates Class file)</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>3. Loading</b> of Class file</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>4. Instantiation</b> the servlet class</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>5. Initialization</b> by invoking jspInit() method (To initialize the instance of servlet class)</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>6. RequestProcessing</b> by invoking _jspService() method</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>7. Destruction</b> by invoking jspDestroy() methods (To destroy the instance of servlet class)</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-109552727808527072015-06-21T02:48:00.001-07:002015-07-23T06:18:00.256-07:00Introduction to JavaServer Pages (JSP) <div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1ai1VHbrQhLQKuyCOu1Yrnm5iqlEMxVf86z3JJsx7-Bujurn2wWlfszpPQzjd8AW4EqOjDhyphenhyphenunsqeShKzQvA4oZgnz2TllpH5dqJ-XxjFIeTJdzDK3VTff-uasbHqRik70xpN-BRP/s1600/intro-jsp-tutorial.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1ai1VHbrQhLQKuyCOu1Yrnm5iqlEMxVf86z3JJsx7-Bujurn2wWlfszpPQzjd8AW4EqOjDhyphenhyphenunsqeShKzQvA4oZgnz2TllpH5dqJ-XxjFIeTJdzDK3VTff-uasbHqRik70xpN-BRP/s1600/intro-jsp-tutorial.jpg" /></a><span style="font-family: Arial,Helvetica,sans-serif;">JSP stands for JavaServer Pages released in 1999 by Sun Microsystems. It is a technology to create dynamic web pages same as Servlet but it is extension to Servlet technology because it has more features than Servlet like HTML tags, JSP tags, JSTL, Expression Language, Custom tags etc.</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;">Previous to JSP, we have to use Servlet to create dynamic web application but it consists presentation logic and business logic on the same page and JSP made it easier by separating designing and development code so JSP is much easier to maintain and use comparison to Servlet.</span></div>
<br />
<b><span style="font-family: Arial,Helvetica,sans-serif;">Lets understand JSP with a simple example :</span></b><br />
<br />
<b><span style="font-family: Arial,Helvetica,sans-serif;">jspFirst.jsp</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;">JSP page uses .jsp as an extension like .html for html page. In the example for static code html tags are being used and for dynamic code scriplet tag <% %> is being used which will be discussed in the upcoming tutorials.</span><br />
<pre style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> <html>
<body>
<% out.print(“My first JSP page”); %>
</body>
</html>
</code></span></pre>
<span style="font-family: Arial,Helvetica,sans-serif;">This code will give “My first JSP page” as an output on web browser.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br /></span>
<br />
<b><span style="font-family: Arial,Helvetica,sans-serif;">Advantages of JSP :</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>1.</b> JSP provides implicit objects, Action tags, JSTL, expression language, custom tags which helps programmer to write less code than Servlet.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>2.</b> JSP separates Presentation and development code which makes it easy to read, maintain and use.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>3.</b> JSP can use all the addition features with all the servlet features.</span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-1447579963026139672014-07-08T01:45:00.002-07:002015-07-23T07:08:56.847-07:00Unlock Database User Account in Oracle 10g XE using SQL Command Line<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">Following are the Steps that how we can unlock any Database User Account(eg. HR).</span></b></span><br />
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">Before
Unlocking any user account that user must be in the Database and must
be Locked and to unlock that user you need DBA(Database Administrator)
Privileges that's why I firstly connected as SYSDBA.</span></b></span>
<br />
<br />
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">Press win+R( For Run) and type cmd then ok.then you need to write SQLPLUS/NOLOG as shown below to reach SQL Command Line.</span></b></span><br />
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">OR</span></b></span><br />
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">you can directly go to SQL Command Line</span></b></span><br />
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">Start-> All programs-> Oracle 10g Express Edition -> Run SQL Command Line</span></b></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><b><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuHS6l9s8A_f0AyeCoEGAdTSBPbWqWgqUcc8XporN8sCuR7R68rzNt-aXWo912BgPv6d0b3yq1sriKsX8Gq-_vjX2Jfph0MA7n8put7xmRq4b2r2m_B06CHjBdy0g7z-6-LgM7V8XO/s1600/Oracle+10g+Express+Edition+run+sql+command+line.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuHS6l9s8A_f0AyeCoEGAdTSBPbWqWgqUcc8XporN8sCuR7R68rzNt-aXWo912BgPv6d0b3yq1sriKsX8Gq-_vjX2Jfph0MA7n8put7xmRq4b2r2m_B06CHjBdy0g7z-6-LgM7V8XO/s1600/Oracle+10g+Express+Edition+run+sql+command+line.png" /></a></b></span></div>
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">Why we need to Unlock HR User:</span></b></span><br />
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">When
you try to work(eg. create table) with HR User First Time then you
wouldn't be able to connect HR User because by default it remains Locked that's why we need to unlock it.</span></b></span><br />
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">you can also see this error while connecting to HR Locked Account.</span></b></span><br />
<span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;">"Error,account is locked,Warning, you no longer connected to Oracle"</span></b></span><br />
<div class="MsoPlainText">
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-size: large;"><b><span style="font-family: Arial,Helvetica,sans-serif;"><code style="color: black; word-wrap: normal;"> C:\>SQLPLUS/NOLOG
SQL>CONN/AS SYSDBA
connected
SQL>CONN HR/HR
Error,account is locked
warning,you no longer connected to oracle
SQL>CONN/AS SYSDBA
connected
SQL>ALTER USER HR IDENTIFIED BY HR;
user altered
SQL>ALTER USER HR ACCOUNT UNLOCK;
user altered
SQL>ALTER USER HR IDENIFIED BY HR ACCOUNT UNLOCK;
user altered
SQL>CONN HR/HR
connected <span style="font-family: Arial,Helvetica,sans-serif;">
</span></code></span></b></span></pre>
</div>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-71669425203474510652014-07-06T23:24:00.001-07:002015-07-23T06:42:48.218-07:00How to use Foreign Key and other Constraint in Oracle 10g XE<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">Foreign key is a
non-key attribute which depends on a Primary key column of another table.</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">Here in below
given example in table EMPL, DEPTID is foreign key column and there is another
table named DEPTL which is Primary key table and DEPTID</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">is Primary Key
Column.</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">If Foreign Key is
present in same Primary Key table then it called Self Referential Integrity.</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">Primary Key and
Unique Key both uniquely define a tuple(Row).</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">but the
difference is that Primary key can't take null values and Unique Key can take
Multiple null values.</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">Step 1: Create a
Primary Key table DEPTL with DEPTID as Primary Key Column.</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span>
<br />
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><code style="color: black; word-wrap: normal;"> CREATE TABLE DEPTL(DEPTID NUMBER(4) PRIMARY KEY,DEPTNAME VARCHAR2(20))
</code></span></span></pre>
</div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">Step 2: Create a
table EMPL</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span>
<br />
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><code style="color: black; word-wrap: normal;"> CREATE TABLE EMPL(ID NUMBER(20) NOT NULL,EMAIL VARCHAR2(20) CONSTRAINT EMPL_EMAIL_UK UNIQUE,
SALARY NUMBER(8,2) CHECK(sALARY>1000),DEPTID NUMBER(4),
CONSTRAINT EMPL_ID_PK PRIMARY KEY(ID),
CONSTRAINT EMPL_DEPT_FK FOREIGN KEY(DEPTID)
REFRENCES DEPTL(DEPTID))
</code></span></span></pre>
</div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">NOTE: NOT NULL
Constraint can't be apply as a Table Level Constraint.</span></span></div>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-86599214062026250922014-07-05T00:54:00.001-07:002015-07-23T06:42:48.231-07:00How to work with Export and Import commands with Oracle Database<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">Following are
the commands for performing Export and Import a backup file form one
system to another by using command prompt. Here we are taking Oracle 10g
express edition as an example.</span></span><br />
<br />
<span style="color: red;"><span style="font-family: Arial,Helvetica,sans-serif;"><b><span style="font-size: large;">Export command
</span></b></span></span><br />
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><code style="color: black; word-wrap: normal;">
c:\users\Sone>EXP SYS/SYS TABLES=EMPLOYEES,DEPARTMENTS FILE=EXP1.DMP
USERNAME:SYS/SYS AS SYSDBA </code></span></span></pre>
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><b><br /></b></span></span>
<span style="color: red;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><b>Export Manual way
</b></span></span></span><br />
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><code style="color: black; word-wrap: normal;">
c:\users\Sone>EXP
USERNAME:HR/HR
Enter Array fetch buffer size:4096>4096
Export File:EXPDAT.DMP>EXP1.DMP
(2)U(sers),or(3)T(ables):(2)U>t
Export table data(yes/no):yes>y
Coompress extents(yes/no):yes>y
Table(T) or Partition(T:P) to be exported:(Return to quit)>EMPLOYEES,DEPARTMENTS
Export terminated successfully. </code></span></span></pre>
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">Copy EXP1.DMP from Sone(System one) to Stwo(System two)
</span></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b><span style="font-size: large;"><br /></span></b></span>
<span style="color: red;"><span style="font-family: Arial,Helvetica,sans-serif;"><b><span style="font-size: large;">Import Command
</span></b></span></span><br />
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><code style="color: black; word-wrap: normal;">
c:\users\Stwo>IMP SYS/SYS FILE=c:\users\Stwo\EXP1.DMP TABLES=EMPLOYEES,DEPARTMENTS FROMUSER=SYS
USERNAME:SYS/SYS AS SYSDBA
Import terminated successfully.
</code></span></span></pre>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">NOTE: Here we are
exporting dmp file from hr and sys schema but importing only in sys schema.It
is because employees and
departments tables are already present in hr schema.</span></span></div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-73350723223906443282014-07-03T22:23:00.002-07:002015-07-23T06:42:48.222-07:00How to Add and Drop Foreign Key and other Constraints in Oracle 10g XE<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">Foreign key is a
non-key attribute which depends on a Primary key column of another table.</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">Here in below
given example in table EMPL, DEPTID is foreign key column and there is another
table named DEPTL which is Primary key table and DEPTID</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">is Primary Key
Column.</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">If Foreign Key is
present in same Primary Key table then it called Self Referential Integrity.</span></span></div>
<div class="MsoPlainText">
<span style="color: red;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></span></div>
<div class="MsoPlainText">
<span style="color: red;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">1: Adding
Constraint After table created</span></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">ON DELETE SET
NULL:sets child value null</span></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">ON DELETE CASCADE: Child row will delete</span></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">eg.</span></span></div>
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><code style="color: black; word-wrap: normal;"> ALTER TABLE EMPL ADD CONSTRAINT FOREIGN KEY EMPL_DEPTID_FK FOREIGN KEY(DEPTID) REFRENCES DEPTL(DEPTID) ON DELETE SET NULL </code></span></span></pre>
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><code style="color: black; word-wrap: normal;"><span style="line-height: normal; white-space: normal;">
</span></code></span></span></pre>
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><code style="color: black; word-wrap: normal;">
ALTER TABLE EMPL ADD CONSTRAINT FOREIGN KEY EMPL_DEPTID_FK FOREIGN KEY(DEPTID) REFRENCES DEPTL(DEPTID) ON DELETE CASCADE
</code></span></span></pre>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="color: red;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">2: Dropping
Constraint</span></span></span><br />
</div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">ALTER TABLE
TABLENAME CONSTRAINT CONSTRAINT-NAME</span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
<div class="MsoPlainText">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;">eg.</span></span></div>
<div class="MsoPlainText">
<pre style="background: none repeat scroll 0% 0% rgb(240, 240, 240); border: 1px dashed rgb(204, 204, 204); color: black; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><code style="color: black; word-wrap: normal;"> ALTER TABLE EMPL DROP CONSTRAINT EMPL_DEPTID_FK
</code></span></span></pre>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: large;"><br /></span></span></div>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0tag:blogger.com,1999:blog-3385741476262408390.post-48685158875210152422014-07-02T22:18:00.000-07:002015-07-23T07:09:20.636-07:00Joins for SQL or Oracle Database<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAT1wd5YIF3Ll2-aGWQRvzllyVV843ViR9IJQr_TZiuB7BPem5YVaNobvSQ0zPbJ35S78paiLeJhrt_AoHpJjXAqSHhhIj9pCx8ocHp6mGVOhpiCud1zarLF1AIRBX_CYRGPzYOQCy/s1600/sql+and+oracle+10g+joins.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAT1wd5YIF3Ll2-aGWQRvzllyVV843ViR9IJQr_TZiuB7BPem5YVaNobvSQ0zPbJ35S78paiLeJhrt_AoHpJjXAqSHhhIj9pCx8ocHp6mGVOhpiCud1zarLF1AIRBX_CYRGPzYOQCy/s1600/sql+and+oracle+10g+joins.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Joins: </b>When We need to combine two or more tables from database then we use Joins.</span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Step 1:</b> Here we are using Oracle 10g to execute oracle and sql commands. so run 'sql command line'</span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;">connect to hr schema.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaXzAoYF3xCX8p06RrSyKEB89VWipamfUaDTXAHyM2i4XkgOHGK4kbF6EmMpjP503Ss0IIDu2veO5lTJO6w2HrnxlG-CYFwKMTZy-848GaOKsBzxDjvNywrBlAx1rTwqDZqBSM8eoH/s1600/1+CONNECTION+HR.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaXzAoYF3xCX8p06RrSyKEB89VWipamfUaDTXAHyM2i4XkgOHGK4kbF6EmMpjP503Ss0IIDu2veO5lTJO6w2HrnxlG-CYFwKMTZy-848GaOKsBzxDjvNywrBlAx1rTwqDZqBSM8eoH/s1600/1+CONNECTION+HR.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Step 2: </b>Two tables named Employees and Departments are already present in this schema and we are performing join over these two tables.</span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Employees Table:</b></span></span> <br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMfY4JBtxvjELE9uzlHfFrI6nZXK1rkqCDWj1xdYdGXbIlTC7Sq8nzHKL0eqFN3-RkL9g5m48TnpUapjQ-w1zWUxgOF6rTFKwIVilIEclpOIUQRqjCAlXgU6mPwKteLRbRQrlmKQHs/s1600/2+EMPLOYEES+TABLE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMfY4JBtxvjELE9uzlHfFrI6nZXK1rkqCDWj1xdYdGXbIlTC7Sq8nzHKL0eqFN3-RkL9g5m48TnpUapjQ-w1zWUxgOF6rTFKwIVilIEclpOIUQRqjCAlXgU6mPwKteLRbRQrlmKQHs/s1600/2+EMPLOYEES+TABLE.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Departments Table:</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuURc7xitmLXBiignroGoaVYUMJsU7uyGMXVlOaS74b4ccpdLCFqxmPaMhIYbVZZyoLR669UmMHq0BntdqvUkBMzmJVePCtH-bEdHOISh_GIfN0pfi4F9XFh_ZMxx2JMN0RMtG5OPJ/s1600/3+DEPARTMENTS+TABLE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuURc7xitmLXBiignroGoaVYUMJsU7uyGMXVlOaS74b4ccpdLCFqxmPaMhIYbVZZyoLR669UmMHq0BntdqvUkBMzmJVePCtH-bEdHOISh_GIfN0pfi4F9XFh_ZMxx2JMN0RMtG5OPJ/s1600/3+DEPARTMENTS+TABLE.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;">Following are the commands for Different Joins:</span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Cartesian Product:(for Oracle) </b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTdda4pI5E-u0f4827wW4UUYu5hzYz2M89C07ocHXty0vbU_sjYj3nDeOu2TZe0nr25b6dzKtRZ_FS885JBi9ZCI2wgsVdEotPm7mtkkRwYNLGOw_NGrC75Uo7gnQMaM6uvL4kspjk/s1600/4+CROSS+JOIN+ORACLE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTdda4pI5E-u0f4827wW4UUYu5hzYz2M89C07ocHXty0vbU_sjYj3nDeOu2TZe0nr25b6dzKtRZ_FS885JBi9ZCI2wgsVdEotPm7mtkkRwYNLGOw_NGrC75Uo7gnQMaM6uvL4kspjk/s1600/4+CROSS+JOIN+ORACLE.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Cross Join:(for sql/oracle) :</b></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b> </b>It
is a join which does not include Where Clause and the result of this
join is number of rows in First Table multiply by number of rows in
Second Table.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghOH9ZkB5Cbc9Ej_jUdj-DKdYrN5wjiELXW_VBlLRRjupdAqvn4pHTie-VJIrAPxuoprmQ1j4b86szs5Rk2fzFyFHmrYbv7tXOqjazDYNvTMD9450mYdjGpoeA7HVhyOtmFovxcNgJ/s1600/6+CROSS+JOIN+SQL+ORACLE+BOTH.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghOH9ZkB5Cbc9Ej_jUdj-DKdYrN5wjiELXW_VBlLRRjupdAqvn4pHTie-VJIrAPxuoprmQ1j4b86szs5Rk2fzFyFHmrYbv7tXOqjazDYNvTMD9450mYdjGpoeA7HVhyOtmFovxcNgJ/s1600/6+CROSS+JOIN+SQL+ORACLE+BOTH.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Output of Cartesian Product and Cross join are same</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirTSluxPkLnOZWgYb5LeVZinK7_Sc7Jbg74g1MF19HymYtFEVh8FoliiA0SlirEpVqjNlwy_uMBFJQTyM9oqZMpthOdXKjGlR_o9CFcZhy7UebNlXP5x7fSXiec5V5pqjuhzp0WWCn/s1600/5+CROSS+JOIN+EXAMPLE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirTSluxPkLnOZWgYb5LeVZinK7_Sc7Jbg74g1MF19HymYtFEVh8FoliiA0SlirEpVqjNlwy_uMBFJQTyM9oqZMpthOdXKjGlR_o9CFcZhy7UebNlXP5x7fSXiec5V5pqjuhzp0WWCn/s1600/5+CROSS+JOIN+EXAMPLE.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b><br /></b></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Natural Join (Inner Join):</b></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b> </b>It
is a Join where exists at-least one column name in both the Tables and
that get Implicitly Compared and if you are selecting that common column
then there is no need to mention from which Table you are going to
select that column<b>(DEPARTMENT_ID is common column here)</b></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;">but in the case of <b>on clause</b> we need to mention it(see Query <b>E.DEPARTMENT_ID</b> where E is Alias of table Employees)</span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggY6MYNZAOIYeRlzj0jx7GFjcEZbDLdIIE1WKnw6cwl5E-HnymDyB87JO8ySHPsp_WnVi5e0insgOmkwoEUZp52YY4tyuZOuEpX1hS2aB9Y5rUVTZGmmIq159kbVVMOphgGYejl4E-/s1600/7+NATURAL+JOIN.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggY6MYNZAOIYeRlzj0jx7GFjcEZbDLdIIE1WKnw6cwl5E-HnymDyB87JO8ySHPsp_WnVi5e0insgOmkwoEUZp52YY4tyuZOuEpX1hS2aB9Y5rUVTZGmmIq159kbVVMOphgGYejl4E-/s1600/7+NATURAL+JOIN.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Natural Join with Using Clause:</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC7Z78MBw1M2bhhceBsrSAU4TQUlSnosvLC-toaVXArDaWaFOpiyleQ8g8gCJf_jQ1lmzkTYrljDRZ_FHT3vMDEFmh25-ce01ua2LItqLEk8IhwoViWT2Sf5xdtY_aC4uaep_ObOhH/s1600/9+NATURAL+JOIN+USING+CLAUSE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC7Z78MBw1M2bhhceBsrSAU4TQUlSnosvLC-toaVXArDaWaFOpiyleQ8g8gCJf_jQ1lmzkTYrljDRZ_FHT3vMDEFmh25-ce01ua2LItqLEk8IhwoViWT2Sf5xdtY_aC4uaep_ObOhH/s1600/9+NATURAL+JOIN+USING+CLAUSE.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b><br /></b></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Natural Join with on Clause:</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8XL9dV_Ba6kDq_AyznjW_OTOyVh0wBAGRzGu9JovIPri9eQjtwOpxJyHqsqOulrKGKZXHBePm8pa_56c2j8-uOhGK2d6JS27tZa0NlcR4qIqb8GyRcC3BP0lb5cip__h-iBfPc6lo/s1600/11+ON+CLAUSE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8XL9dV_Ba6kDq_AyznjW_OTOyVh0wBAGRzGu9JovIPri9eQjtwOpxJyHqsqOulrKGKZXHBePm8pa_56c2j8-uOhGK2d6JS27tZa0NlcR4qIqb8GyRcC3BP0lb5cip__h-iBfPc6lo/s1600/11+ON+CLAUSE.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Equi Join:(For Oracle)</b></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;">It is a Join Where comparison takes place Explicitly. E and D are Alias for Tables Employees and Departments respectively.</span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Example 1</b>.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzt_XJbcz8yWzVFSTJ1JpH2ouJ7BE7Z3AP8O3H6wRmmOTi4RhSnpOu5__BlwqpksDHaPQyYcG_ylZwXRSWDGfOlEoQq8AbSrm0oibhXEX-nw4A3jO5CMyzdxKOrdV8u9C9qG1AgD9s/s1600/8+EQUI+JOIN.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzt_XJbcz8yWzVFSTJ1JpH2ouJ7BE7Z3AP8O3H6wRmmOTi4RhSnpOu5__BlwqpksDHaPQyYcG_ylZwXRSWDGfOlEoQq8AbSrm0oibhXEX-nw4A3jO5CMyzdxKOrdV8u9C9qG1AgD9s/s1600/8+EQUI+JOIN.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Example 2.</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjT67S9hzfwX4Wr8Hw7T6s8JHvDCVUb2zlmKQGxSIiIu1wbH10CFL7kAw3k_7wbskl176sW_SmJve2_WRPZcbJsQKdJre-tbKjhxNThyzqpQ5rcA7gr1vLC9aFGEdeARqIs4_Jf7xXk/s1600/10+EQUI+JOIN+SAME+AS+USING+CLAUSE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjT67S9hzfwX4Wr8Hw7T6s8JHvDCVUb2zlmKQGxSIiIu1wbH10CFL7kAw3k_7wbskl176sW_SmJve2_WRPZcbJsQKdJre-tbKjhxNThyzqpQ5rcA7gr1vLC9aFGEdeARqIs4_Jf7xXk/s1600/10+EQUI+JOIN+SAME+AS+USING+CLAUSE.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Outer Join: SQL</b></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Left Outer Join:</b></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;">Returns All Rows from Left Table whether corresponding values are available or not. </span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJZ0Ds9vzdv8pFgla3jl7iO31iU-BD8GjXxpwFL3XuHdPoswZNrCAQ3AfjnYEoXHguVKogUvbIFLUqeFYxir4ZSjwQcDcGx_VI7q0-AfqFV5HSHnPcH_i3wV6xQtEYUHelUEFX-ExX/s1600/16+LEFT+OUTER+JOIN+SQL+ORACLE+BOTH.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJZ0Ds9vzdv8pFgla3jl7iO31iU-BD8GjXxpwFL3XuHdPoswZNrCAQ3AfjnYEoXHguVKogUvbIFLUqeFYxir4ZSjwQcDcGx_VI7q0-AfqFV5HSHnPcH_i3wV6xQtEYUHelUEFX-ExX/s1600/16+LEFT+OUTER+JOIN+SQL+ORACLE+BOTH.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Right Outer Join:</b></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;">Returns All Rows from Right Table whether corresponding values are available or not. </span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaZGbxTI6qiTP35FeqVIcHbaMdqsN8figL96wXEOnmD06yomjyMQiG4jYfsTb9KqXKonVRuot7UdvZbPqfWyF_b7DiDHEPLkuttkOjxW_QOvm_KQrLUlhqCTUusRRgSvbDHsOVJUvf/s1600/17+RIGHT+OUTER+JOIN+SQL+ORACLE+BOTH.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaZGbxTI6qiTP35FeqVIcHbaMdqsN8figL96wXEOnmD06yomjyMQiG4jYfsTb9KqXKonVRuot7UdvZbPqfWyF_b7DiDHEPLkuttkOjxW_QOvm_KQrLUlhqCTUusRRgSvbDHsOVJUvf/s1600/17+RIGHT+OUTER+JOIN+SQL+ORACLE+BOTH.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Full Outer Join:</b></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;">Returns All Rows from Right Table<b> </b>and Left Table whether corresponding values are available or not.<b> </b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGnu8zbchuBLY-VmWurFcyiImocY_v5oPL4WZxVZbM0ByCrw8pyu1X6AWZmYX63EKh1UQ38eHz6VpgSgS7ckvuiV1BOoSl2cAC5rr6ZgQYQpoN-bNH2mf2A8Woh4YfnppFk4vLIkcX/s1600/18+FULL+OUTER+JOIN+SQL.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGnu8zbchuBLY-VmWurFcyiImocY_v5oPL4WZxVZbM0ByCrw8pyu1X6AWZmYX63EKh1UQ38eHz6VpgSgS7ckvuiV1BOoSl2cAC5rr6ZgQYQpoN-bNH2mf2A8Woh4YfnppFk4vLIkcX/s1600/18+FULL+OUTER+JOIN+SQL.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Outer Join: Oracle</b></span></span><br />
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Left Outer Join:</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMpLSLWZwAhzq13NHRy8yqGfDuISra5NQ1C2BtmuebJJ91jFgN42P3ntkir4nwjU3HCnqfIpkCSXBZV1hnrM4H9dG6rOzzd9hejh2dcXVuVgHibO_ooqH0lZHhq1mH1mRErip_4AtF/s1600/12+LEFT+OUTER+JOIN+ORACLE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMpLSLWZwAhzq13NHRy8yqGfDuISra5NQ1C2BtmuebJJ91jFgN42P3ntkir4nwjU3HCnqfIpkCSXBZV1hnrM4H9dG6rOzzd9hejh2dcXVuVgHibO_ooqH0lZHhq1mH1mRErip_4AtF/s1600/12+LEFT+OUTER+JOIN+ORACLE.png" /></a></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;">output:</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1N1MIuCgNokykFAX5UxUHMkmZbDNuPp2meY1UsCYEgTKguGOVq-AzZrGgFePcBbh-qXJxVInXoo3p9_wuYE_T05nRJWL_V0cs42w-s4tOEz0lcJRon24QfG1poQQLEc9SdM-7Ikp8/s1600/13+LEFT+OUTER+JOIN+EXAMPLE+ORACLE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1N1MIuCgNokykFAX5UxUHMkmZbDNuPp2meY1UsCYEgTKguGOVq-AzZrGgFePcBbh-qXJxVInXoo3p9_wuYE_T05nRJWL_V0cs42w-s4tOEz0lcJRon24QfG1poQQLEc9SdM-7Ikp8/s1600/13+LEFT+OUTER+JOIN+EXAMPLE+ORACLE.png" /></a></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><br /></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><b>Right Outer Join:</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf47sf0fz_BL9aB2ROSlRZT8WZJSIPCLR5ulF3TaSOLcNEIyo-ZLQgCnk-CYGKGjybLPQxM5fPw5Xyul1-TpEU1tdj5h6o5d8Jb4ZqGab0OfHvgRj_PyfupIZhzZ3vI3925_x0GEDx/s1600/14+RIGHT+OUTER+JOIN+ORACLE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf47sf0fz_BL9aB2ROSlRZT8WZJSIPCLR5ulF3TaSOLcNEIyo-ZLQgCnk-CYGKGjybLPQxM5fPw5Xyul1-TpEU1tdj5h6o5d8Jb4ZqGab0OfHvgRj_PyfupIZhzZ3vI3925_x0GEDx/s1600/14+RIGHT+OUTER+JOIN+ORACLE.png" /></a></span></span></div>
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;">output:</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: Arial,Helvetica,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUJV6sm5zwVb6BIv9YbI4h00OmkKtNdG2JUNs0s52ItBPa5yhp3NgGcv7E7CRXvJkVGOPejV8TELFIjN0DNEx7QG7SK0YOLlgMK3iHCvw8OedNSsLxgTXGbI8VRQd1UwgFiSbRdnAZ/s1600/15+RIGHT+OUTER+JOIN+ORACLE+EXAMPLE.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUJV6sm5zwVb6BIv9YbI4h00OmkKtNdG2JUNs0s52ItBPa5yhp3NgGcv7E7CRXvJkVGOPejV8TELFIjN0DNEx7QG7SK0YOLlgMK3iHCvw8OedNSsLxgTXGbI8VRQd1UwgFiSbRdnAZ/s1600/15+RIGHT+OUTER+JOIN+ORACLE+EXAMPLE.png" /></a></span></span></div>
</div>
Blog Adminhttp://www.blogger.com/profile/00826406596115760683noreply@blogger.com0