Oracle Help
in [SQL]
|
Outer Join with an extra condition On Jun 7, 7:20 am, "dn.p...(a)gmail.com" <dn.p...(a)gmail.com> wrote: The trick is to get the 'placement' of that clause (and column_name is not null) correct, and simple as it seems to me now, I didn't get it right at once. There is also a nice blog entry about the various forms of OUTER JOIN: http://opti... 19 Jun 2008 01:14
Oracle spatial Hi! Does anyone have any experience with Oracle spatial? I'm trying to use a new function SDO_SAM.SIMPLIFY_GEOMETRY but with little success and would appriciate some help. SDO_UTIL.SIMPLIFY works more or less as expected, but I can't seem to be able to get this other function to work. Kind regards, Dalibor K... 19 Jun 2008 01:14
live online training Live Online training in Oracle Technology by experienced, certified professionals. Training Available -> Oracle Database Administration -> Oracle Application Express -> Linux for DBAs Our Instructors credentials -> Certified Project Management Professional (PMP) -> Oracle Certified Master (OCM) -> Orac... 19 Jun 2008 01:14
store Electroencephalography data moongeegee wrote: On Jun 9, 9:51 am, "fitzjarr...(a)cox.net" <orat...(a)msn.com> wrote: On Jun 9, 8:50 am, moongeegee <moongee...(a)gmail.com> wrote: On Jun 9, 9:44 am, "Ana C. Dent" <anaced...(a)hotmail.com> wrote: moongeegee <moongee...(a)gmail.com> wrote in news:56966bae-77ac-47ab-900b- 84938476f..... 19 Jun 2008 01:14
Stored Procedure: How to output entire buffer In comp.databases.oracle.misc Bill Wordsworth <bill.wordsworth(a)gmail.com> wrote: On Jun 9, 2:09?pm, Bill Wordsworth <bill.wordswo...(a)gmail.com> wrote: I wrote a Stored Procedure wherein I use a Cursor to extract multiple rows and columns. I then write them into the buffer (dbms_output.put_line). But w... 19 Jun 2008 01:14
How to Export Database into csv files What is the best way to export any of the following: 1. Whole Schema, or 2. All Tables with Row Header information, or 3 Individual tables with Header row information I opened up access and exported all of my tables into csv files, but it did not include the column name information. I am trying to export t... 2 Jul 2008 10:51
SQL REPLACE function Hi Guys, My database has records with foreign characters at the end of the string that need to be updated to a '-'. I have used the following script to identify these records is: select msib.segment1||'..' , msib.INVENTORY_ITEM_ID , organization_id ,ascii(substr(segment1,-1,1)) ascii from mtl_system_items... 7 May 2008 12:35
most idiomatic way to iterate over an associative array? This is what I'm doing now... is there a better way? It would be great if there were some construct such as 'for i in x begin ... end;' i := x.first; loop dbms_output.put_line(i); exit when i = x.last; i := x.next(i); end loop; Many TIA! Mark -- Mark Harrison Pi... 7 May 2008 12:35
utl_mail adds CRLF at beginning of varchar2 attachments On May 6, 3:14 pm, yf...(a)vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote: neil kodner (nkod...(a)gmail.com) wrote: : Using 10.2.0.3.0 on solaris, I'm trying to write some tests against : utl_mail.send_attach_varchar2. I receive the email and the : attachments, but the attachment always begins with a leadin... 6 May 2008 23:24
query This simple query is driving me nuts. I have a simple table: customer_id action_date action I want to get a distinct count of customer_id where the action = 'A' and the MAX action date is between 01/01/2005 and 03/01/2005. This seems simple, and here is my query: SELECT MAX(action_date) action_date,... 7 May 2008 14:14 |