1,488 Topics
 | |
| | 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 … |
| | 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 … |
| | I am trying to call a stored function (which makes basically a select query)from a VC++ program using OCI. The description of the stored function is: [code] FUNCTION patrick.P_DICTIONARY_FOR_RISK_GROUP RETURNS REF CURSOR Argument Name Type In/Out Default? ---------------- ------------- --------------- V_RISKGROUP VARCHAR2 IN V_DICTIONARY VARCHAR2 IN V_MARKETDATA VARCHAR2 IN V_MODE … |
| | Hi, Does anyone know which grammar class SQL falls under (e.g. LL(1), LR(1), etc.)? Specifically the grammars for Oracle 10g and PostgreSQL 7.4? I need to build a parser for each language and want to select the most suitable class of parser generator for the task. Once which produces Java … |
| | when data is displayed in table format on browser it displays junk characters or incomplete data, but if it is displayed in multilne textbox control it is displayed correctly. I am using oracle 8i 1.5 and visual studio 2002 while computer on which IIS server is installed has .net framework … |
| | 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 … |
| | I want to create a form, and then insert that data into an Oracle database. I am new to JavaScript. I can create a form, but I have no idea how to connect to my Oracle database and pass the form contents to an INSERT statement. Does anyone have a … |
| | hey buddies, plz help me in getting a new project idea for my college project...i wanna do sumthg with oracle at the backend of the dbase and asp.net in the front end...any senoirs or peers or even juniors have any good idea??? plz lemme know !!! |
| | can any1 tellme how to access the sql file using c++. what i've to do is to take a sample file from oracle and one from access(a table having employee's personal info with different attribs,obviously) then i've to print them in c using standard format which i'l define in c++ … |
| | 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... ;) |
| | Hello, Please send me the equivalent code for the following i.e the Database connecting code is written for MS Acess I want to know for Oracle. Class.forName("jdbc:odbc:dsnName"); Connection con=DriverManager.getConnection("jdbc.odbc.JdbcOdbcDriver","",""); can we use the same code(The above given) to connect to SQL Server. With warm regards, Azmat |
| | 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 all, I want to know how java connected to a Oracle database. Please reply. regards Rishi.  |
| | 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 … |
| | Calling Oracle Stored Procedures with ASP the stored procedure is returning an array as out parameter. Any one can help me in this. Vikrant |
| | I am building a JSP app running on Tomcat. The app uses an Oracle backend for data management and things like passwords and so on. There are several objects created by the app called cards. Each card will make use of different but similar groups of data, attributes of tables. … |
 | 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] |
The End.