Search results for query: *

colleague just helped ... dba_extents substitute table name for segment name seems to work ... regards, david - no such thing as problems - only solutions.

hi guys, brain dead here because i cannot find the oracle dictionary table/view that will give me the name of the tablespace used by each partition in a partitioned table ... help please ... regards, david - no such thing as problems - only solutions.

tried this on oracle reports forum a week ago but no response, so cross-posting to try again please ... Reports 10.1.2.0.2 on xp trying to format a new report with basic sql query as csv output but output file full of unrequired data ... eg first few lines of output file ... %-12345X@PJL...

Reports 10.1.2.0.2 on xp trying to format a new report with basic sql query as csv output but output file full of unrequired data ... eg first few lines of output file ... %-12345X@PJL JOB @PJL COMMENT MS PCLXL NT Driver @PJL SET STRINGCODESET=UTF8 @PJL JOB NAME="xxx03a" i have read the...

not at all david ... nice to get confirmation that i am not screwing it up ... ;-) funny how i have never come across this one before ... tanx for your input ... still owe you a few guinness ... regards, david - no such thing as problems - only solutions.

pseudo code extract ... to avoid you trawling through full code ... nap is one of several similar procedures in the pkg for export extracts, hence some initial global testing variables ... summary ... declared in pkg body in following order func csv_uuote proc nap proc main main declared...

i created the function in a package body and then tried calling the function from withing another procedure in the same package body ... also tried declaring function in pkg spec (although it was not required as public for this piece of work) and tried PRAGMA RESTRICT_REFERENCES (CSV_QUOTE...

david, as a follow up ... tried using the function in a package (incl pkg spec declaration & pragma etc) but got a new one for me ... PLS-00231 (oracle 10.2.0.3) SELECT --'S' occupancy, 1 || cDelimiter || CSV_QUOTE(e.SURNAME) || cDelimiter || e.FIRST_NAME || cDelimiter from ... nothing...

agreed ... good man david, again ! that will do the job nicely ... thats why i love tek-tips ... lifesaver when we are tired, cant think straight and miss the obvious ... got an outstanding query on the quest forum if you nave any ideas ... ;-) happy new year and hope that santa was kind to...

hi guys, exporting data into a csv file using 10GR2 utl_file need to check if data from several fields have comma(s) in them and, if so (iaw client's spec), wrap column data in double quotes (normal standard for csv files) eg ... qwerty = qwerty qwe,rty = "qwe,rty" qw,er,ty = "qw,er,ty"...

reverse-engineering 9i application for documentation ... am i missing something here as i cant find anything obvious in the dictionary, documentation, tek-tips, google etc ? i want to identify which package procs/funcs are declared in the package spec (public) or just in the pkg body (private)...

hi stduc, thanks for response ... you have the correct url and i should have checked it before posting ... already paid $$ so will wait for a while before trying something else unless necessary ... tried booting into safe mode and end up at the same light blue screen with xp logo and nothing...

i got fed up with reinstalling xp from disk and adding all sp and patches etc so, i copied boot dive (c) and restored to a bigger 300gb drive which has a 100 gb active partition for os and 200gb partition for data new drive seems to boot ok ... mother board splash screen win xp pro splash...

VSS 2005 standard view ? right hand panel = name, user, datetime, check out folder is there a way to add a column to dispaly the version number please ? VSS admin guy is scratching his head ... regards, david - no such thing as problems - only solutions.

http://www.rampant-books.com/book_2005_1_scheduling.htm regards, david - no such thing as problems - only solutions.

oracle job scheduling mainly covers dbms_scheduler excellent book very comprehensive informative well priced ($US 16.95) isbn = 0-9744486-6-4 rampant press = http://www.rampant-books.com/ bit of a hiccup with the initial shipping to oz but it eventually arrived considering the dearth of...

working in a 4-node rac environment ... currently converting all dbms_job jobs to dbms_scheduler jobs and investigating all options available ... could anyone throw any light on the following two columns please ? dba_scheduler_jobs.source and dba_scheduler_jobs.destination desc column...

oops ... regards, david - no such thing as problems - only solutions.

ok, its the season to be off-thread ... 'Nollaig Shona Duit' spot the similarity and language ... us celts stick together ... regards, david - no such thing as problems - only solutions.

one abbreviated version, me thinks ... dev dba may analyse requirements, develop solutions, review/advise/tune other developers' sql or pl/sql etc, and support prod dbas where required ... prod dbas continually monitor production environemt; check all batch jobs have run, system and users are...