Posts by Joice • 1 point

• 0

  votes

  1

  answer

  60

  views

  Q: Error using ALIAS in select

  In the select below, I would like to use the alias novonome in the second column (instr). select substr(titulo, 1, 20) AS **novonome**, instr(**novonome**, ' ')+1 from conteudo; But I get the…

  sql oracle

  asked 5 years, 12 months ago Joice 1