First you need oracle full text search to be installed.
Then you have to create index on some field in table, this field can be any type: text, number or even file. Oracle text search supports pdf, doc,… and some other file types.
for example we have a table MyTable with following structure
Id number [...]
Often you have to create a simple pages for your website, for example admin pages which allow you edit tables through web. When working with Ms Sql server it’s a very easy task which you can solve with SqlDataSource and DataGrid. But using Oracle it’s difficult to make your page work without exceptions and you [...]
For some simple pages in my application I prefer to use declarative manner of programming. To display some data on the page you can use this lines of code.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ProviderName="System.Data.OracleClient"
SelectCommand="pac_dwh.Revew_item_info.GetAppPermissionInfoExt"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter Name="p_line_id"
[...]