886 reputation
45
bio website
location
age
visits member for 3 years, 7 months
seen Apr 26 at 2:05

Oct
27
awarded  Necromancer
Apr
24
comment RETURNING syntax with multiple columns
You might be better off with INSERT ... SELECT ... WHERE NOT EXISTS ... and UPDATE ... WHERE EXISTS .... Never do slow-by-slow when it can be avoided.
Apr
21
awarded  Yearling
Mar
7
comment Why does Oracle store time in DATE column?
or with TRUNC(departure_date) if you wish to preserve the date-time nature of the value.
Mar
7
answered What are the arguments against or for putting application logic in the database layer?
Jan
16
answered In Oracle, why would an OR / LIKE(A,B) take far longer than running the same query for each condition separately and unioning
Dec
23
comment monitoring of alert log file
@Raj, rather than try to remember where you are, you can rotate the alert log by moving it to a different location in the OS. Then you have a small alert log since the last alert, and you have a comprehensive alert log history.
Aug
29
answered Getting the employee history of Sales department from HR database in Oracle
Aug
29
comment CASE Statement - 1st case is being ignored
The short answer is that the scalar queries in the SELECT clause don't get evaluated until AFTER the WHERE clause has been evaluated.
Aug
25
answered Reverse connect by prior level value for arbitrarily-deep hierarchy
Aug
20
answered Help with Oracle Pipelined function
Jul
22
comment Compare two Oracle database roles
It's not an answer, but consider Oracle's hierarchical (CONNECT BY) queries using DBA_ROLE_PRIVS to navigate the role tree as well as using the INTERSET/MINUS operators to determine if one role includes all privileges of another role.
Jul
22
answered Is SERVICE_NAME forced to be unique per logical database within a network? Would it have sense the opposite?
Jul
17
comment Mounting a database from database files copied from a previous installation
You still have to OPEN the database.
Jun
25
answered Can I grant privileges to a role without specifying an object?
Jun
25
comment Can I grant privileges to a role without specifying an object?
CONNECT is a built-in role; you didn't grant privileges to student_access as much as you granted a role through which student_access inherits connect's privileges.
Jun
25
comment Where I can find the tnsnames.ora file for my Oracle Windows client?
That's the default location; however, if you set the TNS_ADMIN environment variable, that location will be used instead.
Jun
19
answered Can I update an Access table with an Oracle table?
May
23
revised what's the fastest method to export a table through sql query ? 11g - performance
deleted 105 characters in body
May
23
comment what's the fastest method to export a table through sql query ? 11g - performance
I had forgotten that expdp writes server side (as it can run parallel).