1,488 Topics
 | |
| | Hi everyone I am really having trouble right now with oracle for linux. Please tell me how to connect oracle using c/c++ in linux. If anyone knows about any tutorial or have code, please plzzz post me that as well. |
| | hi friends, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many … |
| | Hi friends Can someone help me in this pls.I have 2 tables in my DW One is a table which have all data regarding Income and Expenditure details. The structure (columns) of the table is ctgry_id,ctgry_nm,sbctgry1_nm,sbctgry2_nm,amount.,cmpny_id and tm_id So the records in this table would look like 10001 Wages and … |
| | Hi Folks! Wonder if you can help?? I need to know a way of updating a column in Oracle (datatype: long) but keep the existing data so like an append. Am using Coldfusion to write to Oracle and I know that you can only write 4000 chars at a time, … |
| | hi friends, i/m not that experienced in ORACLE. ..and i am not in to that domain. but a neede arise. i want to read bulk data (we cant predict the format of data) coming from a network connection into ORACLE-8i server. how i code this requirment? please help me giving … |
| | I have linked via odbc from within MS Access 2003 to a table in an oracle database. In oracle the field would display a whole number such as 410000000000020000000. In oracle it's defined as number and size of 21. When I view the table in access the numbers appear like … |
| | Dear Python Gurus: I am a very new Python user, would really appreciate your help. I used Python to write a web form for users to enter. The underlined database is Oracle. One validation needs to enforce to eliminate duplicates entries. For example: one customer ID can only be entered … |
| | friends can u guide me how to get started using oracle .never used oracle before .is there any useful weblink. |
| | Hello friends I have created 2 reportsin Oracle 10g Discoverer . One of which looks like below [B]Asset item Opening Balance Additions Decuctions Closing Balance[/B] Item 1 3 0 2 1 Item 2 4 0 3 1 Item 3 5 0 4 1 Total (Item 4) 12 0 9 3 … |
| | Hy, is there in module for Apache2 that I can use to view my web site wroten in PL/SQL. By default It can be found with OAS but it comes with Apache1 version. I have already Apache2 that I use to serve PHP sites, but I would try it with … |
| | hi, How do I get cell value of each column field in the matrix report. I have simple matrix report which has column field as DivisionNo,Row field as AccountNo and cell field as Credit_Amount whose source is DATABASE column. And I have Summary column for account wise ie rowwise summary. … |
| | Help! I am trying to write some PL/SQL code to display a menu and get prompted for me to enter a selection. I've created 2 procedures and am trying to call those 2 procedure from a PL/SQL block. When I create the selection procedure using variable substitution, I get prompted … |
| | Oracle’s 9i OCP (Oracle Certified Professional) DBA (Database Administrator) certification is a mid-level certification for IT professionals who manage large-scale databases or develop applications that are used enterprise-wide. The Oracle 9i OCP was introduced in late 2001 and will likely stay very popular until the arrival of the Oracle 10G … |
| | i have created table named emp contains following fields :name,empno,dob(date of birth),doj(date of join) i wish to select the record like select the employee details those who are joined same date. please replyto me |
| | We were successful on linking the table from MS access to Oracle 10g, but we dont see any data in the MS access linked table. It shows as data #deleted. Can you please describe how we can see those datas. |
| | I have a VB6 application that works with Oracle database. When I execute this application on Windows XP SP2 machine, the moment the application tries to establish connection with Oracle, the CPU usage goes to 100% and the application comes back in close to 3-4 hrs. The application finally launches …  |
| | Hi there, I'm using asp.net (c#) framework version 1.1 and trying to connect to my Oracle database 10G (10.1.0.2.0) which installed on the same server as the IIS and I'm getting the following error: OleDbException (0x80004005): error while trying to retrieve text for error ora 01019 I can connect through … |
 | hi all, I am trying to connect to Oracle database from a black berry device. I am not sure how to go about starting this assignment. I am open to suggessions. Thanks Srinivas |
| | I wrote a JSP page that connects to a Oracle database. I did a SELECT statement to find out procedures and I printed the procedure into a form. In this form I can modify the procedure and save it. Then I created a sql statement to modify the procedure and … |
| | -------------------------------------------------------------------------------- This is my table structrue Tbl1 -----Record1-----Record2----- Record3 Tbl1_id --------1------------2-------------3 Tbl2 -----Record1-----Record2----- Record3 Tbl2_id --------1------------2-------------3 Tbl1_id --------1------------1-------------1 Tbl3 -----Record1-----Record2----- Record3 Tbl3_id -------1-------------2-------------3 Tbl2_id -------1-------------2-------------3 Tbl3_Name ---Test1---------Test2--------Test3 Tbl3_Flag ----N-------------Y-------------Y Tbl4 -----Record1-----Record2----- Record3 Tbl4_id -------1-------------2-------------3 Tbl2_id -------1-------------2-------------3 Tbl4_Name ---Temp1--------Temp2--------Temp3 Tbl4_Flag ----N-------------Y-------------Y I wanted the result as Tbl3_Name--Tbl4_Name--Tbl3_Flag--Tbl4_Flag Test1 -----------Temp2--------Y-----------Y The rule … |
| | Is there a way to drop a PK from a table by selecting the name into a variable from all_constraints, I need to run this script on multi databases that the actual name of the PK could possibly be different. I can get the name in a variable but don't … |
| | Dim OraStr As String = "Data Source=Oracle8i;Integrated Security=yes" OR dim OraStr As String = "Provider=""MSDAORA.1"";User ID=dev;Data Source=testdb;Password=dev" I am using oracle8i but that should be provider shouldn't it? the MSDAORA.1 is for the OLEDB so I assume it is wrong also. Any Ideas?  |
| | Well, Buying a collection is always useful and result is fruitful. I have made 3 test collections for oracle and got total of 20% discounts at all. I know the real exam is so much difficult. you should have the knowledge about whole exam topics. Although ucertify simulation test give … |
 | I just read an interesting oracle article comparing PHP4, PHP5, and ASP. I would suggest anyone questioning the PHP/ASP debate to read the article: [url="http://www.oracle.com/technology/pub/articles/hull_asp.html"]http://www.oracle.com/technology/pub/articles/hull_asp.html[/url] |
| | Hi guys, can anybody help, plase. Is there an instrument to convert .edb file (as far as i know Oracle's Enterprise DB but under free licence) to MySQL? |
| | In my Project we are building Query with different parameters. Passing this parameter to Backend (Oracle is Backend database we are using) and it returned the recordset and using. Is it possible to use Stored Procedure and get recordset?. Where SQL Server returns as recordset object passing Query. Is any … |
| | PROBLEM: ____________________________________________________________ Im trying to create an update on an oracle database and Im having some real trouble with it. If anyone has experience creating transactions and stored procedures from .net or asp and can help out I can use the assistance. My code is returning the following error and … |
| | Apologies if this is a simple query, I only get to use Oracle on the odd occasion so I tend to get a bit rusty. At present I am attempting to create a view that gathers data from 4 tables, this information will then be queried by an external application. … |
| | I don't have too much experience with Oracle Reports, but, as it goes, have to build a report that is giving me headaches My main problem is: How can I place a field in a report that is repeating horizontically? Like a name list, where each name of course is … |
| | Can anyone help me by advising me on how it would be possible to capture a still image (from a web cam) directly into an HTML screen (running via IE 5.5) and the image being stored (along with other manually supplied text) back into the Oracle 9i database??? I would … |
The End.