Reputation
4,050
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 13 24
Newest
 sql
Impact
~201k people reached

2d
reviewed Edit How can I import the contents of an Oracle database into Visio to create an Entity Relationship Diagram?
2d
revised How can I import the contents of an Oracle database into Visio to create an Entity Relationship Diagram?
adding tag: visio
2d
reviewed Reviewed Use cases of Key-Value NoSQL databases
2d
reviewed Leave Closed Looking for 3NF conversion of an unnormalized table
2d
reviewed Approve Exporting SSRS report to Excel
2d
reviewed No Action Needed how to insert into tables in sql server?
2d
reviewed Leave Open Identify Purchases or Redemptions with the Same Single Trade Profile but Attributed to Multiple Channels
2d
reviewed Close how to insert into tables in sql server?
2d
comment SQL actually executed as planned in ORACLE?
Same here. Personally I don't like the direction Oracle is going: adding layer upon layer of complexity to mask or try to fix fundamental design flaws. Moving to PostgreSQL has been a revelation for me.
2d
revised MySql - Reorder primary key with auto-increment
deleted 13 characters in body
2d
reviewed Close MySql - Reorder primary key with auto-increment
2d
comment SQL actually executed as planned in ORACLE?
@Vérace Adaptive Joins in 12c is one example, but I believe some other changes could be made on the fly in older versions too. blogs.oracle.com/optimizer/entry/what_s_new_in_12c
2d
comment SQL actually executed as planned in ORACLE?
Broadly speaking this answer is correct, but each DBMS has salient differences to beware of.
2d
comment SQL actually executed as planned in ORACLE?
Yes, the question is ambiguous: it could mean 1) Does the executor do something else than what was planned? or 2) Does a subsequent execution always choose the same plan (and execution)?
2d
comment SQL actually executed as planned in ORACLE?
I have it at home in a folder from a course given by Jonathan Lewis. I'll try to dig it out.
2d
comment SQL actually executed as planned in ORACLE?
Wrong: Oracle can and does change execution plan once starting execution in certain cases.
2d
comment SQL actually executed as planned in ORACLE?
Hmm, two answers saying essentially the opposite!
2d
revised Can't drop UNDO TABLESPACE
added 25 characters in body
2d
revised Connect to different databases on the same server
Delete wrong tags.
2d
revised XML vs. Relational databases?
deleted 11 characters in body