Regarding insertion of records

[deepthithallada]

Hi,

While inserting records in the table, is there any way we can change the order in which we insert the records.

Eg: Say i have 3 columns in a table, while inserting the records can i make the system such that rather than inserting the records in a first come first serve basis they are inserted based on ascending or descending order of any column value.

[205210864]

you can try inserting data implicitly


example; insert into emp(name,surnam e)
values('john',' james')
where.......

by including the column names in the insert ststement you can control what column gets its value inserted first that means, if name is first as it is it gets its value first or if surname is first it gets its value first.

[rushdishams]

just clarifying the previous answer-

if you have table called name with fields firstname, surname then if you just make the following querie-

INSERT INTO name (firstname, surname) values ('Rushdi', 'Shams');
 

it will give you the same functionality as the following one-

INSERT INTO name (surname, firstname) values ('Shams, 'Rushdi');
 

Cheers!

[debasisdas]

Hi,
asper the basic ruleof RDBMS the physical position is not at all important.
While inserting records in the table, there can be several way you can change the order in which you insert the records.
the only thing is that the order of the columns ans there corresponding values should match thats all