v can use top in sqlserver 2000
but it is not possible in oracle
it vl fetch u data of top 10 elment
select columname from tablename group by rownum ,column name
having rownum >enter the rownum above which u want
order by rownum ,colum name desc...
Sandya
Last Activity: Mar 12 '08, 05:54 AM
Joined: Apr 13 '07
Location:
-
u can find the common field in the two table and use join to fetch the data from two table...Leave a comment:
-
U cant u use check in select statement ............... It is used while creating table or altering the table to add constraint
u need to modify like this
CREATE or REPLACE PROCEDURE add_order (vorderid IN number, vstoreid IN number, vcustomerid IN number, vorderdate IN date, vshipperid IN varchar)
AS
Newshipperid varchar(10);
BEGIN
If newshipperid = (select shipperid from RAHorders...Leave a comment:
-
/* it fetch u top 10 elements */
select top 10 column name from table name order by column name desc
/it vl fect u bottom 10 elements */
select top 10 column name from table name order by column name asc...Leave a comment:
-
select top 10 column name from table name...Leave a comment:
-
to find diff b/w time
How to find the diff b/w time using PLSQl in Oracle......... ............ -
No activity results to display
Leave a comment: