Posts by Ojuára • 1 point

• 0

  votes

  1

  answer

  21

  views

  A: You can do a PIVOT using SUBSTR

  Good evening guys! manage to solve my problem I will post to if someone has the same problem I had. WITH T_TEMP AS ( SELECT 'Total' AS "GALPAO", 'G' || SUBSTR(CD_ENDERECO, 1, 1) AS T_GALP,…

  query pl-sql oracle11g

  answered 3 years, 7 months ago Ojuára 1

• -1

  votes

  1

  answer

  21

  views

  Q: You can do a PIVOT using SUBSTR

  Hello everybody all good? I’m trying to do a PIVOT on oracle 11 by only getting the first character of a STRING. CREATE TABLE T_ESTOQUE( CD_ENDERECO VARCHAR(15), CD_PRODUTO VARCHAR(20), QT_ESTOQUE…

  query pl-sql oracle11g

  asked 3 years, 7 months ago Ojuára 1