[SQL] Blobs

2003-07-11 Thread sri devi 
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! 
Messenger;

Download latest version.

Re: [SQL] substr_count

2003-07-11 Thread Rajesh Kumar Mallah 
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 sort it by relevence then contrib/tsearch V2 is
for you.

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/


regds
mallah.



> Of course the substr_count function does not exist. Is there anyway to
> do this?
>
> I had a thought char_count(replace(field, !$searchterm, '')) might do
> the job but replace doesn't allow for 'replace everything NOT string';
>
> Any Ideas?
>
> Thanks in advance,

-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] Problem with temporary table -- Urgent

2003-07-11 Thread Vijay Kumar 



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);begin    lString := 
'' CREATE OR REPLACE FUNCTION TESTTEMP() RETURNS varchar as 
 
    BEGIN 
'';    lString  := lString 
||  '' create temporary table temp_Table( Name Numeric);'';
 
    lString := lString || '' 
insert into temp_Table values (1); '';
 
    lString := lString || '' 
insert into temp_Table values (2);'';
 
    lString := lString || '' 
return null; end; language plpgsql;'';
 
    raise notice '' Notice is % 
'', lString;    execute 
lString; open refc for select * from temp_Table; return 
refc;end;' language 'plpgsql';
 
begin;select 
TestTemp_refcur('funcursor');fetch all in funcursor;commit;
 
psql:test18.sql:25: 
WARNING:  Error occurred while executing PL/pgSQL function 
testtemp_refcurpsql:test18.sql:25: WARNING:  line 20 at 
openpsql:test18.sql:25: ERROR:  Relation "temp_table" does not 
existpsql:test18.sql:26: ERROR:  current transaction is aborted, 
queries ignored until end of transaction block
Kindly guide as to solve this 
problem
 
Any help will be highly 
appreciated
 
Thanks & Regards
Vijay