Reputation
3,187
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
9 22
Newest
 Informed
Impact
~325k people reached

14h
comment How to prevent insert row duplicate value in a column and equal the any value
And what if one row has 'ENABLE' and another has 'DISABLE' (with the same id) Are NULL values possible for status(they are, if I look at your table definition), are other values than 'ENABLE' and 'DISABLE' possible for status?
1d
comment Varchar array as an input to Oracle stored procedure
in your first query you use P_ACCOUNT , in your second you use P_ACCOUNT_NO. Is this a typo in this post or is this the reason for your problem?
1d
comment Can we take Backup on Disk and Tape at same time by RMAN?
What do you mean by 'at the same time'? In one statement or two different statements running at the same time?
2d
reviewed Edit Table does not exist even if there is one
2d
revised Table does not exist even if there is one
outline text; removed signature
2d
reviewed Approve MYSQL INSERT takes too long and each next portion takes more than previous
2d
reviewed Reject TDE on Replicated Databases
2d
comment Can I improve the performance of this MySQL query by adding an index?
1=1 and email is not null is redundant. So I think the query is created automatically by an application. And this application puts a '%' at the beginning and the end of the search string.
2d
comment Step by step establish a connection between SQL Server 2014 and Oracle 12c
Golden Gate is a tool to replicate data. That won't help you.
Aug
31
comment How to copy tablespace from one database to another database in Oracle 11g
@Paresh: Another option you have is to make an import t using a database link. Then all data is sent over the link directly from the source database to the target database abd no dumpfile is needed at all.
Aug
31
revised How to copy tablespace from one database to another database in Oracle 11g
added 142 characters in body
Aug
31
comment How to copy tablespace from one database to another database in Oracle 11g
@Paresh: No, that is wrong. The export file is small if you do as tranportable tablespace export.
Aug
31
revised How to copy tablespace from one database to another database in Oracle 11g
added 142 characters in body
Aug
30
answered ORA-01830: date format picture ends before converting entire input string
Aug
29
comment ORA-01830: date format picture ends before converting entire input string
note: the alter session is only necessary to demonstrate the result. It is not part of the solution.
Aug
29
comment Entity relationship problem
Maybe Departement, Classification (and even Worker) should be viewed as weak entities, all depending on Company. Then the Company key would be part of the keys of Departement, Classification and Worker. A weak entity is an entity whose existence depend on the existence of another entity.
Aug
29
reviewed Reject What is the right database for my use?
Aug
29
comment Defragmenting Indexes Bloats Log Files
@Aaron ALTER INDEX REBUILD is listed. Isn't that the operation the OP is using?
Aug
29
revised ORA-01830: date format picture ends before converting entire input string
format, tags
Aug
29
revised ORA-01830: date format picture ends before converting entire input string
format, tags