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.. |
The End.