. Hi, We are building an ASP.NET application with C#.net language and Oracle 9i database. Here we installed Oracle 9i client software on our PCs. We never worked on Oracle 9i database. It’s the first time. We are planning to build stored procedures in Oracle database and call them from our ASP.NET application. Does working with Ora...
How to display the details of employee whose name contains the same characters at the start and end position of their name? ...
Hi, I have an oracle 9i db installed on IBM AIX unix. This server is a remote server. I can connect it through Putty and SQL DEVELOPER. REQUIREMENT 1) Want to connect to it from my windows application using c#. 2) Cannot install anything on oracle unix. So, how can i connect using c#? Please suggest some solution. Thanks ...
I have an Oracle 9i DB installed at remote IBM AIX server. I want to connect to it using C# app (.Net) Presently, I am able to connect to it using SQL Developer and SQLPlus from my machine. But when I try to connect from Visual Studio App, using System.Data.OracleClient. private static string GetConnectionString() { ret...
Q.accrept any string having any no.of comma in the string and display all the words seperated by commas in seperate lines? example: delhi,mumbai,pune,puri i want output like this outpt: delhi mumbai pune puri ...
I am trying to understand what the +0 at the end of this Oracle 9i query means: SELECT /*+ INDEX (a CODE_ZIP_CODE_IX) */ a.city, a.state, LPAD(a.code,5,0) ZipCode, b.County_Name CoName, c.Description RegDesc, d.Description RegTypeDesc FROM TBL_CODE_ZIP a, TBL_CODE_COUN...
I am preparing stored procedure with oracle .I m using multiple inner joins with the same table where an input parameter value is checked within each inner join. I want to eliminate particular inner join if the input parameter is null ...
I have a table with 14 columns in Oracle. All the columns are of integer type. i need to check no two columns in one row have same integer value in them. How can i do this using SQL. Or is it only possible to do using PL/SQL? ...
I'm trying to fluently configure a SessionFactory to access an Oracle9i database, using ODP.Net, and I'm getting this MissingConstructorException. I've got the actual fluent mappings sorted out ok, but I'm not sure what else it is that I've done wrong. Here is the exception: BasicConnectionTests.AssertThatWeCanConnectToADatabase : F...
Without getting into a discussion about whether the business logic should be in the database or at the application layer, since it has been covered elsewhere. My team is translating 100K+ lines of PL/SQL code and moving the logic from the database into the application. We were using VB6 with straight calls to Oracle 9i Stored Procedure...
I have an issue with Linq to Nhibernate producing queries with outer joins. For example: return Session.Linq<ClientContact>().Where(c => c.Client.Id = 13).ToList(); Produces a query similar to: SELECT... FROM mw_crafru.clientcontact this_, mw_crafru.client client1_, mw_crafru.relationshiptype relationsh4_ WHERE t...
Please do add a comment if more information is needed to answer this question. We have a query that returns a cartesian product. Since there are a lot of results, there are potentially a ton of objects that get hydrated. We'd like to do simple paging on the database end so it's fast, and so it only pulls n results starting at row n*pa...
I need to write a query which takes rows and converts it into columns - here's my table: Count fname lname id ----------------------------- 1 abc def 20 2 pqr 20 3 abc xyz 20 4 xyz xyz 20 1 abc def 21 1 pqr xyz 22 2 abc abc...
I have two date strings, in the format MM/DD/YYYY and would like to query an Oracle database for any records between those two dates. How do I do this succinctly and simply? ...
While running database configuration assistant(oracle 9i) I get error oversubscribed literal/length tree.Please help me out. ...
How can I create a Sequence where my START WITH value comes from a query? I'm trying this way: CREATE SEQUENCE "Seq" INCREMENT BY 1 START WITH (SELECT MAX("ID") FROM "Table"); But, I get the ORA-01722 error ...
Hello! Is adding tablespaces to a database decrease the performance of an Oracle 9 database? We consider that the number of request remains constant. Thx, Eric ...
Hi, guys. Say I have the following table: ID | String ---+--------- 1 | <123><345> 2 | <1-2><45-67> 3 | <345-321><234> This is a legacy data format in my app which is currently impossible to avoid. What I need to acheive, is: ID | String ---+--------- 1 | <123> 1 | <345> 2 | <1-2> 2 | <45-67> 3 | <345-321> 3 ...
If i use Natural joins than what is the use of primary key and foreign key? ...
Is it possible to do SET OPERATIONS using more than one column in the SELECT clause? For example: SELECT NAME, AGE FROM tableA MINUS SELECT NAME, AGE from tableB ...