2,840 reputation
2921
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 2 years, 3 months
seen 22 hours ago

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


Oct
20
comment how to order a field based on two parts of the row value
What do you have so far?
Oct
20
comment Is there anyway to search PL/SQL reserved words with contains function?
Why do you want to do this?
Oct
17
comment Performance first low, then high after adding index, then keep high after drop index
Which DBMS are you talking about?
Oct
16
comment How to handle big table?
Please post information on the exact problem you're trying to solve. This question is going to be closed as "unclear" or "too broad".
Oct
16
comment Error when reorganizing the autonumber in Postgresql
Are you using some tool? Which one? Very light on details here...
Oct
16
comment Oracle Concurrent Insertion
And the reason why is described in the Oracle Concepts manual. You should really read that.
Oct
15
comment Restore an oracle dmp file
You need to either precreate the tablespaces with the same names, or make sure that the server you're importing to has the same directory structure so that the tablespaces can be created by the import program.
Oct
15
comment Importing CSV Files with Date Columns
Apex is a development tool; this is a development question and belongs on Stack Overflow.
Oct
14
comment Trying to search using MATCH and AGAINST keyword
What do you mean by "not working"? Gives the wrong results? Gives an error? Which DBMS are you using?
Oct
10
comment Why does Oracle not support an autonumber data type?
Sequences have been around since version 6! See orafaq.com/wiki/Sequence
Oct
9
comment can't execute opatch even I'm in the oinstall group with -rwx--x---
I'm pretty sure the group also needs "r" to be able to execute; I mean, you can't execute something that you can't read, right?
Oct
9
comment Updating every cell of of a table?
I'm guessing the asker is wondering if there's an easy way to write the SQL for all columns.
Oct
2
comment Export data tables from SQLPlus
dba.stackexchange.com/questions/1479/…
Oct
2
comment Export data tables from SQLPlus
You don't need DBA privileges to use exp.
Oct
2
comment Populate one table with data from another one on selected cells
Surely as simple as adding AND users.email IS NULL to the where clause?
Oct
2
comment Postgres: error message “does not exist” when dropping existing trigger
Looks like your trigger has been created with a mixed-case name using a name enclosed in double quotes.
Oct
1
comment how to group data against more than one conditions
Can you provide sample data and expected output to help us understand your question? Also, which DBMS are you using?
Sep
29
comment How to perform MongoDB CRUD operations through javascript?
I'm no Javascript language guru, but maybe it should be db.tags().remove ?
Sep
29
comment Mysql remove binary log
Temporarily add some disk space?
Sep
29
comment How to perform MongoDB CRUD operations through javascript?
What language is this? This looks like a programming issue -- belonging on Stackoverflow.