There can be only 1 Clustered index in a table

where as nonclustered index can be upto 249 

Clustered is physical sorted index..

non clustered is logical stored index is faster than 
clustered index

thats all i know

A cursor is a SELECT statement that is defined within the 
declaration section of your PLSQL code. We'll take a look 
at three different syntaxes for cursors.

Cursor without parameters (simplest)
The basic syntax for a cursor without parameters is:

CURSOR cursor_name
IS
    SELECT_statement;



For example, you could define a cursor called c1 as below.

CURSOR c1
IS
    SELECT course_number
      from courses_tbl
      where course_name = name_in;

The result set of this cursor is all course_numbers whose 
course_name matches the variable called name_in.



Below is a function that uses this cursor.

CREATE OR REPLACE Function FindCourse
   ( name_in IN varchar2 )
   RETURN number
IS
    cnumber number;

    CURSOR c1
    IS
       SELECT course_number
        from courses_tbl
        where course_name = name_in;

BEGIN

open c1;
fetch c1 into cnumber;

if c1%notfound then
     cnumber := 9999;
end if;

close c1;

RETURN cnumber;

END;

Try this...Hope this will give the Required Answer
create table testsamp(a char,b char,c char);
insert into testsamp values ('A','B','C');
insert into testsamp values ('A','B','X');

select a,b,c from(
 select a , b,
 c||lead(c,1) over (partition by a,b order by a,b) c from 
testsamp ) tmp where rownum=1;

Regards,
Murali

Try this,


update testsamp1 set c=decode
(c,'MALE','FEMALE','FEMALE','MALE');


Regards,
Murali

SP_Rename 'dbo.table_name.column_name','new column_name'.

23

Primary key:it can not be null

Unique:it can have only one null value in a table.

As database developer, you must have ever written 
subqueries in either SQL Server or any other database 
platform. This article will describe shortly about types of 
subquery.

  
A subquery is inner query that will be used by outer query. 
A subquery could return scalar value or a series of value. 
Based on query dependency, a subquery could be self-
contained or correlated one. A self-contained subquery is a 
subquery independent from outer query, and correlated 
subquery is a subquery that is referencing to a row in 
outer query.

  
Self-contained subquery is easier to debug than correlated 
subquery. And it is executed only once whereas correlated 
subquery is executed once for each row of outer query.

  
Sample of self-contained subquery that returns scalar value 
is shown below :

  
Select customerid

From dbo.orders

Where employeeid = (select employeeid from dbo.employees 
where lastname = ‘RAJ’);

  
This query returns customers list whose employee is RAJ.

SP_RENAME 'OLDTABLE NAME', 'NEW TABLE NAME'
eg:
SP_RENAME 'TBL_EMPLOYEE', 'TBL_EMP'

SELECT CASE WHEN instr(TASK_NUMBER,'NN')>0 THEN 'NN' ELSE 
null END FROM PA_TASKS;

sybase.com
infocenter.sybase.com
 except this sites