-->To solve the issue of searching in nested tags using oracle text, use 'inpath' rather than 'within'. With 'inpath' exact path can be specified with various options to fine tune the query to yield precise search results.
Refer to oracle documentation (http://docs.oracle.com/cd/E11882_01/text.112/e24436/cqoper.htm#CCREF0300) for more information on inpath.
-->To search for word across multiple sections in oracle text index use 'accum' instead of boolean operators. Weighting can also be used with accum in scenarios where one section needs to be emphasized more than others. 'within' and 'inpath' can be combined with accum.
eg: contains(doc, '(abc within head)*3 accum(abc inpath /head/body/p[1])') > 0
In this example, head is a section in oracle text index, abc is the search term and 3 is the weight. This query will search for the word abc in head and also in 'p' tag. However, if abc occurs in title section it gets scored more than if it appeared in the 'p' tag.
Refer to oracle documentation (http://docs.oracle.com/cd/E11882_01/text.112/e24436/cqoper.htm#CCREF0300 ) for more information on the working of accum.
-->To escape special characters while doing a wildcard search into oracle text, use \ instead of {}.
eg: water\,% will work.
{water,} will not work.
-->A true wild card search is not possible in oracle text
i.e., contains(doc,'%') > 0 , '%' can be used when prefixed or suffixed with search term (can be a word or a single character).
Wednesday, October 1, 2014
Oracle Apex 4.2 tips
--> When passing an apex item between pages, whose value is a string with comma, escape between forward slashes. If not escaped the string will be truncated at comma.
eg: intsead of passing &PX_ABC. pass \&PX_ABC.\
This information is available in help text for the item but is easy to miss for beginners.
eg: intsead of passing &PX_ABC. pass \&PX_ABC.\
This information is available in help text for the item but is easy to miss for beginners.
Tuesday, March 2, 2010
Creating new ODBC connection on 64-bit Vista/ODBC driver for 64-bit Vista
If u are trying to make a odbc connection to say MS Access or Excel, so that it can be used by a programming language (like java), on a 64-bit OS. Then the things u need to do are:
1.)Go to Control Panel
2.)Go to Administrative Tools
3.)Right click on Data Sources and go to its properties
4.)In properties change the following and click 'OK'
Target field to:
%SystemRoot%\SysWOW64\odbcad32.exe
From:
%SystemRoot%\System32\odbcad32.exe
Start In to:
%SystemRoot%\SysWOW64
From:
%SystemRoot%\System32
5.)Having done the above go to Data Sources and in that go to System DSN.
6.)In System DSN click on Add and select the driver u want and click 'Finish'.
eg. Driver *.mdb(for Access 2003), *.accdb(for Access 2007), *.xls(for Excel) and so on.
1.)Go to Control Panel
2.)Go to Administrative Tools
3.)Right click on Data Sources and go to its properties
4.)In properties change the following and click 'OK'
Target field to:
%SystemRoot%\SysWOW64\odbcad32.exe
From:
%SystemRoot%\System32\odbcad32.exe
Start In to:
%SystemRoot%\SysWOW64
From:
%SystemRoot%\System32
5.)Having done the above go to Data Sources and in that go to System DSN.
6.)In System DSN click on Add and select the driver u want and click 'Finish'.
eg. Driver *.mdb(for Access 2003), *.accdb(for Access 2007), *.xls(for Excel) and so on.
7.)Having done this Select the file u want by going to 'Select' and choosing the file u want to use
in ur program and give the Data Source Name(DSN) the same as name the name of ur
file.This will do the job.
Note: The DSN need not be the same as the name of the file. But what ever u give the DSN ,makes ure u use that in ur program to get Connection.
How to change the port number of wamp(apache) server on windows machine
To change the port number of apache server , go tto the httpd.conf file and change the port number to the available port number(8080 or 8081).
If it is a wamp server u will find the httpd.conf file at this path
C:\wamp\bin\apache\Apache2.2.11\conf\httpd.conf
Open this file with note pad and change the port numbers.
or start the wamp server and u will find the apache icon in the tray(right hand bottom corner). Click on the icon and go to apache and and there u the httpd.conf file. Open this file and change the port number.
If it is a wamp server u will find the httpd.conf file at this path
C:\wamp\bin\apache\Apache2.2.11\conf\httpd.conf
Open this file with note pad and change the port numbers.
or start the wamp server and u will find the apache icon in the tray(right hand bottom corner). Click on the icon and go to apache and and there u the httpd.conf file. Open this file and change the port number.
How to make jQuery work in blogger/blogspot
Go to Layout of ur blogspot and click on edit html.Add to the head section the following snippet:
To add jQuery to the blogger post, make sure the whole jQuery snippet comes on a single line when u paste it on notepad or wordpad.If there are line breaks(carriage return or returns) in the note pad,then the jQuery snippet does not work.
To add jQuery to the blogger post, make sure the whole jQuery snippet comes on a single line when u paste it on notepad or wordpad.If there are line breaks(carriage return or returns) in the note pad,then the jQuery snippet does not work.
Where to find host string and port name in oracle
The tnsnames.ora file has the host string and port number details needed to connect to the oracle server.So open the tnsnames.ora file with notepad or wordpad to get the details about the hostname, port number and SID.
Subscribe to:
Posts (Atom)
