2,481 reputation
520
bio website
location Austria
age 57
visits member for 3 years, 6 months
seen 7 mins ago

7m
comment Sorting by two columns conditionally
So for rows with a not null column set_orders the set_orders value gives the position in the output. The column where set_orders is null are sorted category_id in the output. Why do you need such a strange sort order?
1d
awarded  Proofreader
1d
reviewed Edit insert inserted id to another table
1d
revised insert inserted id to another table
formatting.
1d
comment Equivalent data types in Oracle database for SQL Server 2008’s uniqueidentifier and timestamp
with timstampyou mean the rowversion datatype?
1d
comment Equivalent data types in Oracle database for SQL Server 2008’s uniqueidentifier and timestamp
@Raj: sys_guid is not ad datatype, it is a function
1d
comment Need help in incrementing the date in oracle
To change the format of a value the usage of a function would be more appropriate than changing the settings of the whole session an use an impliciat conversion. So use ` select '''' || to_char(to_date(:d, 'DD-MON-YYYY') + 1,'DD-MON-YYYY') || '''' from dual`
2d
comment sql query self outer join
I don't understand your erquirements, if "condition" then what?
Dec
19
reviewed Approve sql query self outer join
Dec
19
comment Phantom vs. Non-repeatable read
+1, if the answer to this question is 'opinion-based' then the statement of the Fowler book is not true.
Dec
19
revised ORA-02049 and ORA-02063 Errors
grammar
Dec
19
answered How to know my DB user?
Dec
19
comment How to know my DB user?
neither your answer nor the links you provided will help to find out the name of the uses of a session.
Dec
19
revised How to know my DB user?
grammar
Dec
16
revised How to store values from a loop and compare them?
declare instead of begin, code format
Dec
15
comment Message file not found when starting SQLPlus
Why do you think that the OP wants to install ODBC? Also he don't want install a client (neither instance client nor any other one). He has installed Oracle XE 11.2 on Fedora 18. You should not adatp the problem to your solution :-)
Dec
15
comment How do I maintain categories and products of an optical store?
You answer is not an answer but an aadditional information for you question, and therefor you should delete the answer.
Dec
15
comment How do I maintain categories and products of an optical store?
I transfered the text from you answer to the post where it belongs, becuase it is no answer. you should delete your answer.
Dec
15
revised How do I maintain categories and products of an optical store?
added the text from an answer
Dec
14
comment Database design for an exam system
I did not find Password_Hash in any picture but only PasswordHash. When I read Person_ID, Password_ID, SchoolYear_ID I cannot find any inconsistencies.