SHR's user avatar
SHR's user avatar
SHR's user avatar
SHR
  • Member for 8 years, 1 month
  • Last seen more than a week ago
  • Israel
8 votes
1 answer
67k views

How to connect to oracle 12c from sqlplus without password in command line

7 votes
1 answer
88 views

What can be the purpose of this trigger?

6 votes
2 answers
11k views

"If not exists" using OBJECT_ID() doesn't work for views and triggers. why?

6 votes
2 answers
9k views

SQL Server: trigger for insert update and delete caught when no data been changed?

5 votes
1 answer
2k views

Can TRUNCATE TABLE be overloaded on SQL Server?

4 votes
1 answer
5k views

Insert into multi table View in SQL SERVER

4 votes
1 answer
6k views

How to prevent Deadlock on SELECT queries?

2 votes
1 answer
2k views

Can I prevent deadlock using `WITH(NOLOCK)`?

2 votes
1 answer
6k views

How can Inner join be optimize? [closed]

2 votes
2 answers
154 views

Slow Select with indexes. How can be improved?

2 votes
2 answers
12k views

How to sync MySQL's time with system time without mysql restart?

2 votes
1 answer
2k views

Sync oracle DBs using archive log when not connected to each other

1 vote
1 answer
539 views

Oracle: Query gives different answer when running from procedure

1 vote
0 answers
315 views

How can I "buffered" mine Oracle logs using LogMiner with 'committed data only' option properly?

1 vote
0 answers
867 views

Conditional flow in sqlplus

1 vote
0 answers
293 views

How to recover LogMiner after its tablespace had been deleted?

1 vote
3 answers
3k views

How can a trigger be bypassed?

1 vote
1 answer
1k views

connect to Oracle Cloud from SQLPlus and Instant Client

1 vote
0 answers
552 views

Can I see failed SQL queries text?

1 vote
1 answer
99 views

What is the fastest way to (session) lock table?

1 vote
1 answer
2k views

How can I check if BULK INSERT is running on a table?

1 vote
2 answers
388 views

Select failed from V$LOGMNR_CONTENTS when called from a procedure

0 votes
1 answer
723 views

How to select from pdbs with a cdb user?

0 votes
1 answer
240 views

Is it possible to give PDB name to a procedure and select from it?

0 votes
0 answers
25 views

Is it possible to select from procedure\function when the PDB is an argument without connect?

0 votes
2 answers
988 views

"user does not exist " when calling DBMS_LOGMNR.START_LOGMNR

0 votes
1 answer
603 views

How to quota a CDB only tablespace to a CDB user?

0 votes
1 answer
1k views

Rotate MySQL log files

0 votes
1 answer
51 views

Is there an option to turn existing global variant to constant in MySQL or MariaDB?

0 votes
1 answer
2k views

How to increment identity without add a row and get the skipped value?