hi.. i need to make a function that returns a table that is populated within the function... i can't create any object types:mad:.. so i...
Solution: SELECT regexp_replace(g.name, '\&'||'amp;', '&') FROM groups g
does anyone know how replace or regexp_replace '&' or any other ampersand string? my first stab at it was this SELECT replace(g.name,...
if anyone's interested the solution i came up for with this is to query for the distinct members of the child column... i then loop through...
does anybody have an easy solution to finding looped references? not sure if i've chosen the right words so i'll give an example...
i've been trying to use the truncate command to no avail.. truncate keeps claiming their are foreign key records in another table.. however it...
can anyone find the error in this select? select * from dbo_contacts c WHERE (first_name IS null OR trim(first_name) = '')...
thank the lord.. i haven't tried it out yet to see the time difference but i'm certainly optimistic that i can finally pull off the deletes in a...
post script.. the reason i've got to ask this is because it's beginning to take up to an hour to empty out all my tables..
is there a better way to empty a large table than DELETE FROM atable; COMMIT;?? i've been working on migration scripts and so i've been...
Separate names with a comma.