![]() |
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| High Level Programming Post questions about C, C++, Java, SQL, and other programming languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| pass a variable to sql | mac4rfree | Shell Programming and Scripting | 0 | 3 Weeks Ago 04:17 AM |
| Pass variable to sql | killboy | Shell Programming and Scripting | 3 | 08-02-2009 06:17 AM |
| ksh variable pass to awk | meman1188 | Shell Programming and Scripting | 4 | 05-10-2009 01:30 AM |
| How do I pass a variable to awk? | eja | UNIX for Dummies Questions & Answers | 12 | 04-03-2007 06:46 PM |
| Pass variable to sed? | kristy | Shell Programming and Scripting | 2 | 04-04-2002 04:14 PM |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
How to pass table_name as variable
i need to delete the data from all the tables where a column appears
Eg column_name = ABCD Now i do get all the tables where a column like ABCD appears and stores it in another table say temp There are around 800+ tables i get so my temp table has two fields table_name column_name now i want to delete data from these tables based upon condition so my query is Now taking the table_name from temp table in a cursor how do i pass the table_name dynamically or using as variable in a cursor eg: delete from @table_name where some condition |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|