Tag: oracle11g

i`m trying to do something…. I have to insert some data in to a table but….. So here is where I end up… any suggestion… Answer You cannot refer to an alias in the SELECT or WHERE clauses of a sub-query where it is defined. Generate the data in a sub-query (or a sub-query factoring clause) and then refer to

I`m trying to list only the vat numbers which look like DDDDDDDDDLLDDDD else i have to list NULL https://i.stack.imgur.com/4PYR8.png Pretty sure that I`m close but still missing something 🙁 Answer You can use the regular expression ^d{9}[A-Z]{2}d{4}$ to match the start-of-the-string, then any 9 digits, then any 2 upper-case letters, then any 4 digits and, finally, the end-of-the-string: If you

I’ve tried search for this and I’m not sure I’m using the correct terminology, but is it possible to have a nested WHERE AND clause?: So the nested AND would “and (age != 18 and hair_colour != black)” so you could have: first_name = ‘Jay’ evaluate to true last_name = ‘McDonald’ evaluate to true (age = 18 and hair_colour =

is there any new way to rewrite the SQL Query to find the first_name starting from A to P Answer Use regexp_like: The regex breakdown: ^ means “start of text” [a-p] means “any character in the range à to p inclusive” The i flag means “ignore case”

I wonder is it able to terminate or stop the Insert if it hits the exceptions. The trigger coding will be: Answer This is how I understood it; though, it is not clear what UPDATE TABLE in your code represents. Update which table? How? With which values? Anyway: sample data: Trigger: Testing: