Alex Poole

United Kingdom

stackexchange.com/users/98359

Age: 43

I've been picking up hints, tips and information from a variety of sources over the years, but somehow have always been a taker and not a giver. I'm finally getting involved and trying to give something back to the community. Still learning far more than contributing though.

I'm a bit of a jack-of-all-trades in a small UK-based team within a US subsidiary of a Japanese company, doing work for a large UK telecoms provider. Production support, developer, part-time (a.k.a accidental) DBA in dev/test, analyst, consultant... whatever needs doing right now, generally. Mostly Oracle (since about 1995, versions 6 to 11g), Java, WebLogic, shell scripting, HTML, CSS, a bit of C when pushed, but whatever's needed today. Work is mostly on Oracle Linux, but dragged into Windows and networking issues fairly often, and a Mac user at home.

1d
comment How to determine value changes according to another columns in Oracle
Please add your expected results to the question as text, not an image; and show how it relates to your sample data - you may need to expand the sample too. It is still very unclear what you mean. Do you want to only see the rows where value_1 changed for each id_1, perhaps?
1d
comment How can I export oracle schema from my local machine to Remote using expdp and impdp command
@Mogsdad - maybe they should be synonyms of datapump anyway, if they're needed at all? Though that tag wiki could do with some work too... *8-)
1d
revised Storing an entire column in a variable inside a stored procedure
deleted 58 characters in body; edited tags; edited title
1d
comment lsnrctl - nothing happens Oracle 11gr2 + Ubuntu 14
Do you have an alias set for lsnrctl? What does which lsnrctl or whence -v lsnrctl show?
1d
comment This block works fine in oracle but the same block gives error in datastage ORA1861
What is the full exception stack, and what is the procedure code? I'd guess the procedure is doing some date manipulation internally, including an implicit conversion you might not realise is there, and you have different NLS settings between the two sessions.
1d
comment How can I export oracle schema from my local machine to Remote using expdp and impdp command
If that completes and you don't get an exception then the file has transferred successfully? I'm not sure what you're asking - you think it might fail silently?
1d
comment How can I export oracle schema from my local machine to Remote using expdp and impdp command
Other than the dbms_file_transfer package the Amazon docs say to use? Have you tried to follow their instructions?
1d
comment How can I export oracle schema from my local machine to Remote using expdp and impdp command
Amazon has documentation on how to do this.
1d
comment How can I export oracle schema from my local machine to Remote using expdp and impdp command
Have you copied the locally created dump file to the remote server's DATA_PUMP_DIR directory?
1d
comment Creating a function that returns the day of the week for a specified date
possible duplicate of How to get the week day name from a date?
2d
revised What is causing error in my code
edited tags
2d
answered What is causing error in my code
2d
comment What is causing error in my code
It always helps to say what error you are getting.
2d
comment Converting NUMBER to DATE
@angus - it's a built-in function; not sure when it was introduced but at least 10g. What Oracle version are you using?
2d
comment select subselect parse results oracle
The row in ach_addenda is related only to transaction 1, but how is that known - what is the join condition? If you look at the row how do you know which transaction it belongs to? You also talk about type 1 and 2 which is confusing. Only type 1 transactions have ach_addenda records, but you still need to know how to link each type 1 transaction to its specific addenda(s).
2d
comment select subselect parse results oracle
Which column(s) in ach_addenda link to a specific transaction in temp_extract? It is kind of hard to follow what's going on with partial code and no raw data. Can you create a simplified but complete version that demonstrates the issue you're having? (Perhaps as an SQL Fiddle)
2d
comment Why are all packages showing up as `create or replace` only? Do I need select granted for `all_source`?
Are you looking at packages in your own schema? Which version of SQL Developer are you using?
2d
revised SQL*Loader loading empty records
Formatting
2d
comment SQL*Loader loading empty records
Can you add your data file and table definition? Why char(100000)?
2d
answered Converting NUMBER to DATE
1 2 3 4 5