1,488 Topics
 | |
| | can Any one Help me please!! How to make a Procedure can send email with attachment ? thx |
| | Hi, I need to Pass XML File as Parameter to SP and read it and store the tag value in variables. Any example for the same is preferred. Thanks |
| | Hi, How to check if BLOB field is NULL or Not in a Table though other data is available in a selected row ? I need to do this in a sql statement. Thanks Sandy |
| | What is the limit on how many records you can have in a table in Oracle? It must have a limit. Also, has anyone ever benchmarked Oracle on sorting records... say 1,000,000 records of a small record size, just 2 or 3 fields? :cheesy:  |
| | 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 … |
| | hello, Im using VB6 and connecting to an Oracle 9i db via ADO. My tables are stored in the SYS folder and am having a problem while accessing these from VB. While connecting to Oracle as username: sys, pswd: change_on_install, the following error message is seen: 'Test connection failed because … |
| | 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 … |
| | I hope you can help me with this because I am out of ideas... I am trying to pass a structure [I]into[/I] an Oracle procedure and have had no luck… does anyone know how to pass a complex data type into an Oracle database? My idea was to pass in … |
| | 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 … |
 | Hi everyone, I am still fairly new to SAS programming and I have somewhat of a problem. I am writing a program that will input a Microsoft Excel Spreadsheet and convert it to a SAS dataset. From there, I want to insert everything in that dataset into a table in … |
| | Hi, I want to learn [URL="http://www.linuxforums.org/forum/redhat-fedora-linux-help/88953-oracle-installation-fedora-core-5-32-bit.html#"]oracle[/URL] on Fedora core 5 32+ bit os that I am using at the moment, but can't not find any useful installation guides (Fedora specific) on the net. Can any one please help me out? Thanks. |
| | 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 all :) hehe sorry .. lol 1st of all iam new here :) ... and i really liked this site its very informative :) .. and iam sure i will enjoy being a member here.. before when we do a site we choose the database access but this time …  |
| | 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 … |
| | |
| | Im making a site to display reminders set by a client and retrieved from the db (Oracle) using JSP. How can I set the reminders extracted from the db into onto a date displayed in a table cell? Please advice. Thank you. |
| | 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 … |
| | A calendar can be created easily in VB..but can the details be stored in Oracle...will it be too complicated? I want to create calendars for different departments and store them in separate tables for a Patient Management system.. Please advice.. |
| | 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 … |
| | String serverName = ? String portNumber = ? String sid = ? Plz answer my above queries , while conecting with oracle 9i and Java.... its urgent !!! |
| | 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 im new to jsp i have to connect oracle database 8i with jsp page i want step by step tp connect into oracle database i already refered many threads in this blog as im new to jsp i cant get exact procedure can any 1 give me step by … |
| | i use ADO in VB6 to connect to my Oracle database i made a connection object 'con' and opened the database using it when i executed the statement con.Execute "insert into employee(no,join_date) values(424,'12-SEP-2004')" i found that he new record was inserted into the database(i checked it using sql*plus) . But … |
| | 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 |
| | Sir i am B.SC., graudate i have one doubt that is how connect oracle database and vb please clear this problem sir. |
| | I'm a novice at VB and wish to populate a datagrid by connecting to oracle table. I've an ADODC data control inwhich I've used Connection String and given the SQL query after selecting cmdText option. The test connection also succeds but only empty datagrid is displayed when I run the … |
| | Hi everyone, Just looking some advice and general tips, have a few questions about a final year project I am thinking of doing. Basically it is going to be a stock control system for a nightclub, particulary focussing on their celler. The system will allow the staff/management to review stock … |
| | i just passed all my oracle exams using certmagic.com guides . they were right on money and had questions which were very close to real exams . Highly recommended . now iam off to start working on cisco track |
| | i am learning on purhcasing hotcerts.com $85 package for my ocp exams . anyone knows how good are ocp exams of hotcerts ? . please do let me know. |
| | hi people, I am very much interested to Oracle. I decided to write one exam soon and I am refering guides from certmagic.com. It seems good. Any of you know any good books than this ?! |
The End.