retrieve a value from database

[Varun Rajput]

I have concatenate Complaint no( primary attribute) with sysdate,branch( attribute) and sequence and I want to retrieve last Complaint no from oracle database.
please send me correct code for it
I am using PHP Technology with Oracle database.

[Luuk]

Why do you do this?

I have concatenate Complaint no( primary attribute) with sysdate,branch( attribute) and sequence

If you want to accomplish this.....

I want to retrieve last Complaint no from oracle database.

Try:

SELECT MAX(Complaint) FROM <your_table_name>

to get the last Complaint from that table..