Creating database tables during the application run time

Hi,

I'm doing a project using jsp, java script, HTML as front end and sql server as backend.

i want to create my database inn runtime. while doing so ,

1. how do i check for an already existing class
2. if there is an already existing class then i need to update the table .

how do i do this. can any one guide through this.

vidhya

Questions by vidhya165   answers by vidhya165

Showing Answers 1 - 4 of 4 Answers

Gopal

  • May 9th, 2006
 

Hai vidhya,

can you be more specific about the problem. I am not sure which existing class you are looking for? you can create table in the database at run time and also check for the existing table in the database.

regards

Gopal

  Was this answer useful?  Yes

Janardhan

  • May 21st, 2006
 

u can easily find the existing tables, and create runtime tables

  Was this answer useful?  Yes

vidhya

  • May 21st, 2006
 

s i know it can be done........but how to check it during runtime........i need the exact syntax...can u explain with an example.vidhya

  Was this answer useful?  Yes

Raghav

  • Oct 13th, 2006
 

You can try by giving this condition "Select table_name from all_tables where table_name='YOUR TABLE NAME'    ". If the output of this is null then, it is not existing. If it returns some value, then it exists.

Remember, you can access all_tables table only if you hv permission else you can use user_objects instead of all_tables. You have to specify the tablename that you want to search in CAPS only

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions