Member Avatar for Shantel

I'm getting this (errorORA-00936: missing expression) when I input this into the sql commands:

select || 'The promotion began on the' || to_char(start_date,'ddth')' of 'to_char(start_date,'Month YYYY')
from f_promotional_menus
where code=110;

I tried googling for answers but came up with nothing. Can someone help me figure out what I am doing wrong?

  • 2 Contributors
  • 1 Reply
  • 91 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by AndrisP
Member Avatar for AndrisP

Your mistake is concatenate simbol before first string "||"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.