MySQL Forums
Forum List  »  Oracle

Assign the variable in show tables.
Posted by: Kannan kumar
Date: July 25, 2013 01:33AM

hi,

This is query for find the table in database.
show tables from db_name where tables_in_client='table_name';

i want to store this query into the one variable using procedure and then check using if/else.
if table name is exists return 1 else 0;

kindly help me how can do.

Options: ReplyQuote


Subject
Views
Written By
Posted
Assign the variable in show tables.
2033
July 25, 2013 01:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.