[SQL] Problem with temporary table -- Urgent

Hi, We are using postgresql 7.3.3, we are encountering the following problems when we used temporary tables.   Here with i'm sending my Sample function.   create or replace function TestTemp_refcur(refcursor) returns refcursor As 'declare refc alias for $1;    lString Varchar(4000);be

Re: [SQL] substr_count

On Thursday 10 Jul 2003 10:08 am, Tom Rochester wrote: > Hey all, > > I would like to achive something along the lines of: > > SELECT field FROM table WHERE field ILIKE '$searchterm' ORDER BY > substr_count(field, '$searchterm'); > Hi In case you are attempting to search text in a feild and sor

[SQL] Blobs

hi   we have to download url files in to oracle using BLOBs how to create oracle table stucture how to write the query,we are using oracle9i,and javaswings,reply me to this id. [EMAIL PROTECTED]     thanking you sridevi SMS using the Yahoo! Mess