How can I extract table name from the different DDL statement like
ALTER TABLE
CREATE TABLE etc
Basically I have to parse thr the any of the DDL statement and verify if that DDL statement is implemented by DBA or not.
how can i do this efficiently in Kornshell scripting.
Really impossible to give any suggestions without a sample of what you need to parse. Please post ten lines or so of the input text that you'll need to parse, and exactly what portions of the data, from which records (if there are multiple types of records in the data), that you'll need. It's also important to put the sample input inside of code tags (use the # button in the edit frame) so that spacing is preserved.
1 Like
Agama, I have updated the other thread(Pass a DDL statement to a KSH script) with some more details.
Appreciate if you could help me to get this working.