I want to list all tables and columns where any column value starts with http.I already did it by using cursor ,but cursor is very slow.Also dynamic query exceeds the length and throws the error.Is there any other approach?
I want to list all tables and columns where any column value starts with http.I already did it by using cursor ,but cursor is very slow.Also dynamic query exceeds the length and throws the error.Is there any other approach?
1条答案
按热度按时间3mpgtkmj1#
Below is written is just for select query purpose only.