MySQL Forums
Forum List  »  Oracle

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


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

Written By
Assign the variable in show tables.
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.