Posts by V.Bregalda • 46 points
2 posts
-
2
votes2
answers42
viewsA: SQL formatting field
If the field is char: Select REPLICATE('0', 4 - LEN('23')) + RTrim('23')
-
1
votes2
answers2257
viewsA: ORA-00907: Missing right parenthesis error
In addition to placing the AND in the second Where condition add comma between the table objects: (SELECT SUM( SCORE + GRADE ) FROM QUIZ_DETAILS, Q1 DADOS D1 WHERE Q1.STUD_ID = QUIZ_DETAILS.STUD_ID…