2,971 reputation
21121
bio website datajini.com
location Frösön, Sweden
age 42
visits member for 2 years, 6 months
seen 1 hour ago

I'm an Oracle Database Specialist at DataJini, an Oracle consultancy that specialises in building solutions using MDD techniques.


1h
comment Exclusive access to edit rows
You should look into adding a column of type ROWVERSION to your table(s).
1h
comment select for loop result in oracle
What result are you expecting?
23h
comment Oracle StartUp Issue
Data corruption?
Jan
22
comment Insert All Columns from one table into another table MYSQL
Please show us what you tried.
Jan
22
comment Multiple Similar Tables vs One Master Table
What do you mean by "The integrity of Foreign Key constraint fails"? Please explain what you mean and/or show us (an) example(s).
Jan
21
comment JDBC connection error for SQL Server Database
Firewall? Are you certain SSMS connects using the same protocol?
Jan
20
comment Transpose MySQL rows as column names - DYNAMIC
Please at least show us what you tried.
Jan
19
comment SQL: how to scan an entire table sequentially from top to bottom
What do you think a select statement does?
Jan
19
comment Oracle instead of trigger update performance issue
Where is your for each row? Do you really want a statement level trigger or do you want a row level trigger?
Jan
19
comment What is {Oracle}… {Oracle Off}?
They are not "just performance optimizations".
Jan
19
comment Oracle stored procedure for PIVOT
Your "pivot_in_clause" is incorrect: it requires a list of items, not a single string containing comma separated items. You could just move your subquery there. Then your stored procedure body becomes just: open select * from (select ITEM_ID, VENDOR_ID, TOTAL from MF_QUOTATIONS) pivot (max(TOTAL) for VENDOR_ID in (SELECT DISTINCT VENDOR_ID FROM MF_QUOTATIONS));. You would do well to check the documentation at docs.oracle.com/cd/B28359_01/server.111/b28286/…
Jan
12
comment What's the best database if i want save data temporally?
Temporally? Or temporarily? (@SQLRockstar)
Jan
7
comment How do you mysqldump specific table(s)?
Yet one could list all the tables to exclude and it would dump just the ones remaining :-)
Jan
7
comment Postgres Error for table
I found this handy reserved word checker which checks in most of the major DBMSes: petefreitag.com/tools/sql_reserved_words_checker/?word=window
Dec
29
comment creating tablespace failed!
Did you read the error message? It says your diskgroup is full.
Dec
26
comment Upgrading mysql percona server from 5.5.40 to 5.6.71
This is just an error log. What did you do? What's your question?
Dec
22
comment How to unify three separate tables having same data, same columns but tuples in different languages. Only one key(caption) is common to all
One possible solution: Add a column -- and to the key of the table -- language.
Dec
19
comment Automating SQL Server Merge Replication Processes
Which DBMS are we talking about?
Dec
17
comment Best approach to get last value inserted
Number 3 works well for me. Make sure you have an index on (device_id, date_inserted desc).
Dec
16
comment postgres service suddenly not working after the computer crashed while working
I strongly doubt this would solve the problem the asker was having.