Oracle most infamous error messages

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT
   p.Title,
   p.Id,
   Answered = CASE WHEN p.AcceptedAnswerId IS NOT NULL THEN 'Yes' ELSE 'No' END,
   p.AnswerCount,
   p.ViewCount,
   p.CommentCount,
   UpVote = SUM(CASE WHEN vt.name = 'UpMod' THEN 1 ELSE 0 END), 
   Favorite = SUM(CASE WHEN vt.name = 'Favorite' THEN 1 ELSE 0 END),
   OtherVote = SUM(CASE WHEN vt.name NOT IN ('UpMod', 'Favorite') THEN 1 ELSE 0 END)
   FROM Posts p
      INNER JOIN Votes v ON p.Id = v.PostId
      INNER JOIN VoteTypes vt ON v.VoteTypeId = vt.Id
   WHERE vt.Name NOT IN ('DownMod', 'Offensive', 'Deletion', 'Spam')
   AND p.Tags LIKE '%oracle%' AND (p.title LIKE '%ORA-%' OR p.title LIKE '%TNS-%')
   GROUP BY p.Title, p.Id, p.AcceptedAnswerId, p.ViewCount, p.AnswerCount, p.CommentCount
   ORDER BY ViewCount DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results