Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 115
  • Last Modified:

delete value with / in table

hi i what to delete only value with / in my table from example i have jjuu/33222d,uuiiijjj i what to delete all value s who got / am in oracle 11gR2
0
chalie001
Asked:
chalie001
1 Solution
 
chaauCommented:
You can use the operator LIKE:
DELETE FROM myTable Where myColumn LIKE '%/%'

Open in new window

0
 
chalie001Author Commented:
correct
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now