soorajsk_84

 Profile Answers by soorajsk_84 Questions by soorajsk_84

• Dec 19th, 2007

autonomous transaction  are independent transaction exCREATE OR REPLACE PROCEDURE a1ASPRAGMA AUTONOMOUS_TRANSACTION; BEGININSERT INTO table1 VALUES('autonomous transaction');COMMIT; END;D...

Answer Question  Select Best Answer

senkum123

 Profile Answers by senkum123 Questions by senkum123

• Aug 12th, 2007

PRAGMA AUTONOMOUS_TRANSACTION is used to commit the transaction in the PL/SQL block which is inside another PL/SQL block which is on the verge of rolling back.To make an independent transaction within a PL/SQL block

soorajsk_84

 Profile Answers by soorajsk_84 Questions by soorajsk_84

• Aug 9th, 2007

An autonomous transaction is used to create a seprate transaction which when commited will commit data only belongs to that transactionExample PROCEDURE Proc 1  IS  .  INSERT&...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

muralir02  

 Profile Answers by muralir02 Questions by muralir02

• Member Since Mar-2006 | Mar 20th, 2006

---

select max(sal) from emp where sal<(select max(sal) from emp);

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Select salry from Hello h where 2=(select count (distinct salry) from hello where h.salry

srivathson

• Feb 20th, 2012

Code
SELECT max(Salary) WHERE salary<Select max(Salary) FROM employees 

Improve Answer

Read Best Answer

Editorial / Best Answer

Rohan  

 Profile Answers by Rohan Questions by Rohan

• Member Since Nov-2005 | Feb 18th, 2006

---

#include <stdio.h>
#include <conio.h>
#include <string.h>

void main()
{
   char *str;
   int i,len;

  //not using any temp variable and assume we can use only string array and   length

   printf("Enter String : ");
   scanf("%s",str);
   len=strlen(str)-1;
   for(i=0;i<strlen(str)/2;i++)
   {
         str[i]+=str[len];
         str[len]=str[i]-str[len];
         str[i]=str[i]-str[len--];
   }
   printf("Reverse String is : %s",str);
   getch();
}

naveen

• Jun 17th, 2017

Code
#include<stdio.h>
#include<conio.h>
#include<string.h>
 
void main()
{
char str[10],temp;
int i,len;
printf("enter string: ");
scanf("%s",str);
len=strlen(str)-1;
for(i=0;i<strlen(str)/2;i++)
{
temp=str[i];
str[i]=str[len];
str[len--]=temp;
}
printf("reverse string : %s" ,str);
getch();
}
 

Gurjyot Singh

• Dec 5th, 2016

Here`s the answer

Code
#include<stdio.h>
#include<conio.h>
#include<string.h>
int main()
{
        char A[20];
        int i;int C=0;
        printf("Enter String : 
");
        gets(A);
        for(i=0;A[i]!=;i++)
        {
                C++;
        }
        for(A[C]=;C>=0;C--)
        {
                printf("%c",A[C]);
        }
 
        getch();
        return 0;
}
 

Improve Answer

..........

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

SQL is a language to insert update delete the record where oracle is a database

vijaypati

 Profile Answers by vijaypati Questions by vijaypati

• Mar 3rd, 2010

SQL stands for Structured Query Language. SQL is used for accessing and manipulating databases. SQL can execute queries against a database. SQL can Retrive, insert, update & delete from ...

Answer Question  Select Best Answer

laxmi

• Nov 24th, 2015

Test alphabets, alphabets with caps lock & shift, numlock, special characters with shift button, tab button F1,F2,...F12, & pagup enter, etc; like that all keys in keyboard are checking whether its work or not.

Nguyễn Thị Xuân Hạnh

• Feb 4th, 2013

Check if all individuals button are proper by manually typing and verifying them on the screen (checking functionality of buttons).

Answer Question  Select Best Answer

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls.

soorajsk_84

 Profile Answers by soorajsk_84 Questions by soorajsk_84

• Aug 9th, 2007

A table can have any number unique keys but a single primary key

Thriveni P

• Mar 14th, 2006

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls.Unique key cannot be used to create referential integrity whereas primary key can do.

Answer Question  Select Best Answer

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

SELECT ename, sal FROM (select ename,sal,dense_rank() OVER (order by sal desc) dr FROM emp) WHERE dr =n;

chirla_pavan

 Profile Answers by chirla_pavan Questions by chirla_pavan

• Sep 12th, 2008

Select * from employee where 1=(select count(*) from employee as e where employee.sal<e.sal)

Answer Question  Select Best Answer