12,246 reputation
12035
bio website ddbcinc.com
location Rochester Hills, MI
age 38
visits member for 3 years, 9 months
seen 1 hour ago
Oracle ACE

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
Feb
25
revised How to compare a result of a query to a number?
added 569 characters in body
Feb
22
revised Implement a deduplication trigger in Oracle
added 32 characters in body
Feb
1
revised Create Table with Int-attribute which can only use values between 6 and 36
added 589 characters in body
Jan
29
revised Change all datatypes in a table
added 90 characters in body
Jan
27
revised Change all datatypes in a table
Add the `char_used` predicate
Jan
9
revised Making data from one schema available to another schema
deleted 170 characters in body; edited title
Nov
25
revised Normalization: 'zip code' as a primary key
added 206 characters in body
May
3
revised Timezones in Oracle 10
added 1098 characters in body
May
2
revised Timezones in Oracle 10
added 1517 characters in body
Mar
21
revised Giving permission for each table within a database
added 51 characters in body
Mar
12
revised how to create and insert into a table in an anonymous block
added 376 characters in body