Search results for query: *

any reason you are sticking to dedicated connection mode? Why not have connection pools? Regards, S. Jayaram Uparna . :-)

Hi , I have new requirements with me here which shows around 300 tables in a 10G database that have to go into a warehouse (another 10G DB to be designed). All ETL will be done by informatica since the databases are geographically separated and each one cannot access the other. Now i want to...

had put it there before this thread itself - no responses yet -- and the clock is ticking.... sigh :-( thanks anyway ! Regards, S. Jayaram Uparna . :-)

Use the RANK or the Row_Number function for this - looks like you dont want count , but want the rank of appearance. Regards, S. Jayaram Uparna . :-)

Bump [morning] [sadeyes][nosmiley] [sadeyes] Regards, S. Jayaram Uparna . :-)

[sadeyes][morning][nosmiley] Regards, S. Jayaram Uparna . :-)

bump :-) Regards, S. Jayaram Uparna . :-)

Folks, i am back with a problem. :) We have an OWB mapping that is configured to do ETL operations on a large amount of data. When we tested this in our development environment ( which had around 50000 rows), it ran just fine - in production though, since we have around 500000-600000 rows(10...

Folks, i am back with a problem. :) We have an OWB mapping that is configured to do ETL operations on a large amount of data. When we tested this in our development environment ( which had around 50000 rows), it ran just fine - in production though, since we have around 500000-600000 rows(10...

Dave , Yes , i understand that -- and i am concentrating on the last_ddl_time only -- not the created time. Strangely, the prod db was analyzed over the weekend , and i now see the proper compile times there....so the analyze seems to have woken up the all_objects view from its slumber. I cant...

Dave , yes, this is what i suspected----and you have answered my Q1. i am very interested in the answer to question 2 -- why did the sp compile time not change in the all_objects view , though i knew explicitly that it had changed? Your test above seems to prove that "analyze" is not the...

Hi, Which sys table/view contains the information on when an SP was compiled? (Question-1) Last_DDL_Time in All_Objects seems to be the answer, but even on compiling my SP , the time didnt appear to change in this table -- Is this table updated only on every analyze, right? (Question 2) If...

Here is the situation i am in:- I have to generate a random 6 digit number. Sounds simple. SELECT ROUND(DBMS_RANDOM.VALUE(100000,999999)) NUM FROM DUAL; Ah! here are the couple of catches:- 1) This number should not be a previously generated number ( stored in a difft table, called table X)...

oops -- my bad -- i am revisiting the many-rows-to-a-single column approach -- ie reasons 1 2 3 should come as reasons 1,2,3 sorry for not clarifying -- my bad. Regards, S. Jayaram Uparna . :-)

hi , i am kind of revisiting this and am trying if its possible using ONLY sql (without a func etc) in 9i --- does anyone have any idea? Regards, S. Jayaram Uparna . :-)

Ok , here is the situation:- I have a set of records in a table , say table OLD_DELIVERIES (this contains all the houses to which we have delivered flowers in the past) House# Lat Long H1 17.15000000 -61.81666667 Row_1 H2 37.85000000 144.75000000...

thanks sem! i did that yesterday for this and .... "saved a bunch of seconds on my work management by switching to sem's method!" :-) (those in the US can relate this to the ad on tv), Thanks again! Regards, S. Jayaram Uparna . :-)

bravo! bravo! its slightly cumbersome , because the extract pulls out 121 cols (dont ask me who designed the table , i think Adam did). But the joy of eliminating the damn spaces is worth it all. Yes , Santa , it did give me joy. You really are "Santa" for me , many times over :-) ..... your...

I have a small batch file that runs a query when the user invokes it. This batch file contains sqlplus commands and spools the results of the query into a file called "data.csv". The colsep is set to ',' and so i have a neat little excel-like report for this special user. Now the problem is...

<speachless> Regards, S. Jayaram Uparna . :-)