Reputation
13,340
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 23 37
Newest
 Enlightened
Impact
~686k people reached

Oct
20
answered Is there anyway to search PL/SQL reserved words with contains function?
Oct
17
comment grant permissions in oracle from one database to another
@KyleM - It would be whatever the TNS alias on the EmployeeDB database for the ContractorDB database is. That's generally going to be the same as the name of the database but that's just a naming convention-- your TNS alias might be different.
Oct
17
answered grant permissions in oracle from one database to another
Oct
17
awarded  Enlightened
Oct
17
awarded  Nice Answer
Oct
14
comment What do these pstart and pstop values mean?
@jubil - Short of tracing the session, I don't know of a way to do that.
Oct
13
answered What do these pstart and pstop values mean?
Oct
13
comment work with json in oracle
What version of Oracle? 12c introduces native JSON types.
Oct
12
answered How to design tables such that a person can work for many companies?
Oct
9
comment Is it impossible to iterate table rows in Oracle PL/SQL without using a cursor?
Why do you ask? What problem are you trying to solve? "without using a cursor" is also rather problematic since each and every SELECT statement opens a cursor. Both your examples use exactly the same number of cursors (or would if they worked). A SELECT ... INTO that returns anything other than 1 row will throw an exception no_data_found or too_many_rows so it would never make sense to check the rowcount (which I assume you meant rather than rownum) after doing a SELECT INTO.
Sep
30
awarded  Explainer
Sep
26
comment Oracle Support Identifiers?
Your tags indicate that you're using Oracle XE, the unsupported, free version of Oracle. You can't buy support for Oracle XE. You can upgrade to the standard edition (Oracle SE or Oracle SE 1 depending on the server) in which case you'd purchase your first year of support when you purchase your license.
Sep
19
awarded  Enlightened
Aug
27
comment PL/SQL operating system call
@Ekevoo - Any number of queuing mechanisms can be implemented without polling (though one process polling even every few seconds for a very small number of requests shouldn't come close to putting a dent in a tiny server). Oracle AQ can be configured so that the message automatically kicks off the process (once the triggering transaction completes of course). For sufficiently small volumes of requests, your APEX process could also submit a dbms_job job that runs (more or less) immediately after the triggering transaction commits and calls a Java stored proc to shell out.
Aug
27
answered PL/SQL operating system call
Aug
26
comment In PL/SQL what is the usage of row level and column level attributes?
What do you mean by "row level and column level attributes"? Do you have an example of what you're talking about? Or a link to a document with some context?
Aug
21
comment Escape characters in Oracle dump
What does "take a dump" mean in this context? A "dump file" is a common term for the output of the Oracle export utility, either the regular version or the DataPump version. If you are using the Oracle export utility, however, the question doesn't make sense. That leads me to believe that you are using some other tool to generate some other sort of file.
Aug
13
comment Exporting scheduled jobs in Oracle
@ik_zelf - D'oh, you're right. Updated my answer to use the old PROCOBJ trick. I thought that was no longer necessary but apparently I was mistaken.
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.
Aug
12
answered Exporting scheduled jobs in Oracle