
May 7th, 2011, 01:56 PM
|
|
Registered User
|
|
Join Date: May 2011
Posts: 13
Time spent in forums: 2 h 33 m 44 sec
Reputation Power: 0
|
|
|
Insert into table if not exist otherwise return error
Hello,
I am using oracle 10g to create a user register application.
what i want is to insert the user information (like Email ,username, password, etc.) into a table. i am able to insert the data into the table but what i want is to check before inserting that same email,and username doesnt exist. if it does it should return some error like the email or username already exist.
please help and suggest some solution.
it will be highly appreciated.
thanks and regard,
Kunal
|