StackRating

An Elo-based rating system for Stack Overflow
Home   |   About   |   Stats and Analysis   |   Get a Badge
Rating Stats for

Andrew Sayer

Rating
1556.89 (6,204th) 		Reputation
2,256 (74,632nd)
Page: 1 2
Title Δ
Return boolean inside a create procedure pl sql +3.82
nolock hint is not working when update inside transaction 0.00
Grouping values in Group By clause -3.30
PLS-00307: Too Many Declarations of "X" Match This Call +3.49
How to find what data caused Oracle function failure? +3.97
SQL question using Cursor - case study on taking First Transaction -3.92
I have an oracle table which has date in dd-mm-yyyy and dd/mm/yyyy... +5.26
ORACLE Error report ORA-01422: exact fetch returns more than reques... +4.76
PL/SQL Oracle Package error when executing functions 0.00
How to find missing data in table Sql 0.00
How to insert date in SQL date type column? -4.19
Oracle : Create session sequence? +1.94
Using Union All performance degrades in Oracle View +3.49
I am getting this error :ORA-12560: TNS:protocol adapter error in w... -0.33
Strange WHERE statement that behaves like a GROUP BY? -3.54
Missing right parenthesis Oracle Issue -1.92
How can I tune my Oracle SQL query to run faster? -3.14
Might transactional backup cause the operations to be deadlock, etc? 0.00
Oracle SQL or PLSQL. Select rows by partitions which values have sp... +4.90
calculate running total with a date range in where clause using ora... +0.53
Get maximum of sequence +5.14
update table statement - Violation of Primary Key constraint 0.00
Materialized view in oracle DB 0.00
Reason for data inconsistency if UTL_FILE is not closed after writi... 0.00
Where clause of Sql - may it read a stale data? 0.00
How to execute alter command within select statement in a loop in O... -2.34
Self-join with "and" in on clause +3.69
Tired of typing SQL scripts like "SELECT TOP 10 * FROM" a... -0.28
How to get max of one date in a table in sql 0.00
"Incorrect syntax near 'maxprice'." 0.00
Oracle Nested SUBSTR Compare 0.00
Problem with stored procedure in SQL Developer - no "refreshin... +1.74
SQL query to change column names to single column value +4.87
Fetch records who see a change in value over time -3.54
SQL Creating a procedure, but it doesn't see my tables +4.14
SQL JOINS AND SUBQUERY 0.00
OFFSET and FETCH NEXT in sql: Can't return less number of recor... 0.00
Problem with trigger for avoiding insert (Oracle SQL) +4.11
SQL - Oracle subquery filtering out data +4.66
PL/SQL : Ignoring -942 EXCPETION issues - still bombs on PACKAGE Co... -3.87