1,135 Topics
|
|
|
|
How can Stored procedures be used in oracle reports for creating reports instead of SQL queries? Thank you. |
|
|
right now i am studying my final year UG degree. i have developed my project in VB and ORACLE 8i...now i want to execute my project in my college.... now whats the problem is i have to create tables every time in another system.... so i want to bind the …
|
|
|
|
|
|
Hi, I have few reports which have been created using the Microsoft Sql Server Reporting Services.Now i want to create similar reports using Oracle Reports 10g. Will i need to start from scratch the creation or is there migration tool that would reduce the efforts for the same. Thanks in … |
|
|
Hi, Im installing Oracle 10g on Fedora 5, I did it once, but when I tried to set it up again I got this error on the last part of the install... ORA-12157: TNS: internal network communication error Anybody know what might cause this? I think I have installed all … |
|
|
[B][COLOR=Blue]I've used php mambo and oracle 9 to develop a web-based application..I also used separate server for database and the system..but sometime an error occur to the database connection, its display "Could not connect to database" after submit the data..Anyone can help me out to solve this problem? [/COLOR][/B]
|
|
hello, ive been busy trying over and over and over again to write a block of SQL that will perform this task for me but have failed ever time. hopefully someone can point me in the right direction or at least gime a hand cheers. task : to work out …
|
|
|
I m using oracle pro compiler to connect to the database and execute dml statement in a C++ program using visual studio 2005. when this procompiler connects to database, it creates a communication area known as sqlca. I have connected a file named test2.cpp, to databse using this compiler. Till … |
|
|
hai, i m new to this site and my 1st post is this. I have a table which consist of some tuples. i didnt set any primary key. by mistakely i entered the same values for two tuples. i want to delete a single tuple without copying the table to …
|
|
PopUp Windows I just started with Oracle 10 XE (Express Edition) and found a kool How To on creating PopUp Windows in Application Express [URL]http://www.oracle.com/technology/products/database/application_express/howtos/how_to_create_custom_popups.html[/URL][URL="http://www.oracle.com/technology/products/database/application_express/howtos/how_to_create_custom_popups.html"] [/URL]
|
|
|
can any body tell how to delete all the tables in a user ata a time
|
|
|
Hi, I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL Plus command line to make SQL statements I can not get the previously typed command back at the prompt when I use the up and down arrow … |
|
|
Is there a way to store multiple enteries in a same field (Like adding delim's..etc , which would be considered while we are firing queries at them) Ex: i have a field named subjects.. is is supposed to have multiple entries in the same field (English , maths ,etc) Is …
|
|
|
I am using ORACLE 10G . In EnterpriseManager status of the database is " DOWN" , it shows "DOWN" status last two Days. HOW can I rectify This problem. How to startup my database. 
|
|
|
Hi, I am trying to install oracle 10g ODBC driver in my comp. When I downloaded the oracle10.2.0 version into my comp n unzipped tht exe file.According to readme.txt file in that i should run "product.jar" file in the filelocation .but i could not get that.it consists of only products.xml …
|
|
|
|
|
Hi everyone, I am still fairly new to Oracle and SQL. I have two tables with the same information in them. Table1 has the same columns as table2. The differnce between them is the date column. Table1 has 2005 records while table2 has 2006 orders. I am trying to write …
|
|
|
Hello everyone, I am fairly new to oracle and SQL and I am having a little trouble figuring out how to accomplish a task. I have three columns from a table, we will call them 'a', 'b', and 'id'. I first want to order by 'id' and then query the …
|
|
|
hi Excuse me for sounding amateurish, but I need help..Im doing a three tiered architecture proj, is it feasible to use JSP codes to store details about calendars and set reminders with Oracle? Im willing to take up challenges, but Im a novice.. Please advice..
|
|
|
Hi I am working on Oracle database 10g. I am trying to implement advanced replication on my database. Till now I have replicated tables and those are working fine. Now I want to replicate procedure, in this case on running all the procedures(adding packages and generating replication support) I am … |
|
|
Hi everyone I have one master table with the following structure incm_id Category SubCategory 1001 Expenses A 1002 Expenses B 1003 Income C 1004 Income D I have a child table where i am capturing amount value for the above table and structure is something like id fk_incm_id Amount 10001 …
|
|
|
I was wondering if maybe someone could shed a light on something for me. I am performing the same SELECT Statement from Oracle on two servers via a simple export script. [B]Server one:[/B] My Localhost Apache/2.2.0 (Win32) PHP/5.1.2 from a RAW field and it is returning the ascii characters, which … |
|
|
hi, i am looking for a free download by oracle meant specifically for linux. i am using fedora core 5 32 bit version of linux. thanks.
|
|
|
hey all pls suggest me how to start creating database and tables in oracle.
|
|
|
Hi I have a test vserver and a production server both running linux. Currently a database has been created on the test server and is used for testing applications. Now the databse is ready to be transferred to the production database. And it should function in the exact same way. …
|
|
|
i have tried to answer this question like this (show your attempt) and i did it like this because (show your reasons why you think it is the correct approach) and the results that it gave are like this (show the results that your query produces) and i cannot understand …
|
|
|
[COLOR=#000000]I am already in job and have very little time for myself. I can spare two hours daily for [/COLOR][COLOR=#000000]preparation. For which certification should I go now? My current work is database management so i'm thinking of oracle certification, guide me in this way. Please suggest some resource too. [/COLOR]
|
|
|
Hi everyone, I have a little work experience with Oracle. But am a little apprehensive about giving the OCA exams.:confused: Could anyone who has already cleared these exams guide me regarding - 1. which books to refer for both these exams ? 2. how exactly to prepare for these exams … |
|
|
USING:ORACLE 9i For each of the following tasks, determine (a) the SQL statement needed to perform the stated task using the traditional approach and (b) the SQL statement needed to perform the stated task the JOIN keyword. A list that displays the title of each book & the name and … |
|
|
Hi, i have an application that will save the xml to a large object cloumn in DB. It works fine if my xml are in ANSI but if UTF-8, it throws error. Any idea what is going on? Thankx |
The End.