Reputation
15,403
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 28 42
Newest
 Nice Answer
Impact
~1.0m people reached

Apr
25
revised Is it possible to perform skip N rows and fetch M rows without full scan
edited tags
Apr
11
revised Virtual Private Database: Create Policy function/s so that a user can view his own records or records inserted by other users with the same company ID
added 75 characters in body
Feb
16
revised How to display the number of days elapsed between two dates denoted in columns-specifically those exceeding 30 days?
added 126 characters in body
Nov
3
revised SQL for Inserting the system date and a fixed time (not the system time) in a column
deleted 6 characters in body
Oct
5
revised How to turn VARBINARY within PeopleSoft into a string?
added 4 characters in body; edited tags
Sep
30
revised Single Clustered Index Concept
edited title
Sep
30
revised Single Clustered Index Concept
deleted 180 characters in body; edited tags
Aug
29
revised column values combination
added 54 characters in body
Aug
8
revised Oracle Jobs: Can I create a job that will not overlap with itself?
added 425 characters in body
Mar
2
revised ON DELETE CASCADE not deleting entry for foreign key
added 56 characters in body
Dec
14
revised Dual site active-active highly available database
edited tags
Aug
13
revised Exporting scheduled jobs in Oracle
@ik_zelf was right, that the JOB parameter won't work (at least when I tried in 11.2). Amending my answer to use the old PROCOBJ trick.
Jun
25
revised Row Level security or Multiple Tables
added 1361 characters in body
Jun
24
revised Block user access to certain tables
Since you link to the MySQL documentation, I've added the MySQL tag. Different databases will have different features
Jun
24
revised Row Level security or Multiple Tables
edited body
Apr
25
revised Parking Lot table for employees
deleted 17 characters in body; edited tags
Apr
10
revised what is better in terms of allocated space in Oracle Tables: NUMBER or BINARY_FLOAT?
added 725 characters in body
Apr
4
revised How to know DB size using backup file without restoring it
edited tags
Apr
1
revised HOW does ROWNUM work with this “optimization”
added 1095 characters in body
Mar
28
revised Is there any disadvantage to using Oracle's Easy Connect syntax?
added 1279 characters in body