No. of vowels and consonants in a given string in PL/SQL
Sarfraz Alam
August 20, 2018
I have done this question by two methods By using loops declare counts number :=0; counts1 number :=0; str1 varchar2(500) :=...
Monday 20 August 2018
Draw basic shapes using graphics
Sarfraz Alam
August 20, 2018
#include<graphics.h> #include<conio.h> main() { int gdd = DETECT,gmm,leftt=100,topp=100,rightt=200,bottomm=200,xx=...
Reverse a String in PL/SQL
Sarfraz Alam
August 20, 2018
Method 1 : By using FOR loop in PLSQL DECLARE l_string1 VARCHAR2 (100) := 'deeps sti dna thgil neewteb kcuts si emit ehT';...
Sunday 19 August 2018
Draw Circles using using Polar form equations on mouse Click
Sarfraz Alam
August 19, 2018
package draw; import java.awt.Color; import java.awt.Graphics; import java.awt.event.MouseEvent; import java.util.ArrayList; import ja...
Java : Convert Date to String example
Sarfraz Alam
August 19, 2018
Example import java.text.DateFormat; import java.text.SimpleDateFormat; public class DateToStringConve...
Java program to get the IP address of localhost
Sarfraz Alam
August 19, 2018
Below example shows how to get IP address of a host or machine. You can get it by using InetAddress class. getLocalHost() method returns t...
C program to print pascal triangle
Sarfraz Alam
August 19, 2018
#include<stdio.h> long factorial(int); Pascal Triangle int main() { int i, n, c; printf("How many rows you want ...
Saturday 18 August 2018
Login form with PHP and MySQL
Sarfraz Alam
August 18, 2018
First create a login form in html you can use any editoe i prefer Notepad++ Save the file with .htm extension. Here is the code for Form...
ORACLE: Group by clause
Sarfraz Alam
August 18, 2018
Group By clause The SQL GROUP BY Clause is used along with the group functions to retrieve data grouped according to one or more col...
Friday 10 August 2018
PL/SQL: extract digits from a number
Sarfraz Alam
August 10, 2018
In this PL/SQL program i use nested table to store the digits and then print them in reverse order declare type arr_num is table of ...
