Introduction to Database Oracle

Comments

Post a Comment

Popular posts from this blog

Standard Input/output Functions in C

  Standard input/output functions   1. character based functions             1.getchar()             2.getche()             3.getch()             4.gets(char*)             5.putchar(char)             6.puts(char*)          2. format based function       scanf() - for accept       printf() - for display       1. format specifier       2. address of variable       In case printf there is no fixed number of argument       printf("hello")       int n1=5,n2=10       Sum of 5 and 10 is 15       printf("Sum of %d and %d is %d",n1,n2,n1+n2)      to disy n values the number of argument is n+1
Read more

SQL Operators

Operator The purpose operators is to perform the manipulations with attributes. These Operators are following 1. Relational Operators - for comparing purpose 2. Arithmetic Operators - for mathematical operations 3. Logical Operators - for compare with multiple conditions or opposition conditions 3. Special Operator - for special purpose comparison Relational Operators >, <, >=, <=, =, !=, <> Examples: Display the details about employee whose name is SMITH select *from emp where ename='SMITH'; Display the details about employees whose salary is greater than 3000 select *from emp where sal > 3000; Display the details about employees except MANAGER select *from emp where job <>'MANAGER' ; or select *from emp where job !='MANAGER' ; Arithmetic Operators +, -, *, / Logical Operators and, or , not Example Display the details about MANAGERS whose salary is greater than 2500 select ename, job, sal from emp where job='MANAGER' and sal...
Read more

Example Programs for Control Flow Statements

Image
  //Find out sum of two numbers is even or odd main() { int n1,n2,sum; printf("value for n1"); scanf("%d",&n1); printf("value for n2"); scanf("%d",&n2); sum=n1+n2; if(sum%2==0) printf("\n%d is even",sum); else printf("\n %d is odd",sum); } //Accept a character and check whether it is vowel or not main() { char c1; printf("Enter a character"); scanf("%c",&c1); switch(c1) { case 'a': case 'A': case 'e': case 'E': case 'i': case 'I': case 'o': case 'O': case 'u': case 'U': printf("\n%c is vowel",c1);           break; default:printf("\n%c is not vowel",c1);           break; } } // display the numbers between 1 and 10 main() { int n; for(n=1;n<=10;n++) printf("%d ",n); } // display the numbers between 1 and 10 usi...
Read more