[oracle] Forum Topics

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.

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 …

-------------------------------------------------------------------------------- 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 …

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 …

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?

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 …

Hello all, I am a prefinal yr student of IT. In our next semester we have sql. I also want to learn oracle as it is in a great demand. But what is the difference between them. You can also suggest me on how to start with oracle (some books …

Hi; I'm not sure that this question can be asked here, but I appreciate any one that can help me. I'm programming with Borland C++ Builder & InterBase (SQL complient). Q1: What's your opinion about Interbase database. Is it a good database? Q2: I have a database in InterBase; I …

does anyone know if you can use :bind variables through odbc and vc++ for oracle, so my sql stays in the sga.? if you do, I will send you an invisible prize... ;)

I have 2 databases running concurrently. However the second database prompt me error during database startup. ORA-00205:error in identifying controlfile Can anyone tell me how to recreate control files in Oracle? I failed to login to SQLPLUS. Thank you and hoping for your reply

Hi, I am taking an Oracle 9i class and wanted to know if there is an oracle download that I can use to check and run my code at home so I don't have to spend every night at school for access

Hi, I'm new to this forum. I am a consultant looking to extend an application's platform dependance. To this I need make specific DB design changes for my normalised database (ie. PK-fields that were autonumber/identity are being changed to integer). Does anyone know if MySQL, Oracle and SQL Server support …

Hello I am making a shopping cart where database I like to use is oracle but there are other projects which are already made with sqlserver2000 database & maybe I have to link from shopping cart to sqlserver2000 database where lots of contents are stored so what happens if I …

I just read about this. New free enterprise db server that has many features that other free dbs don't offer. It's compatible with a lot of OS's. Definitely something to try out. [url]http://www.sapdb.org/[/url]