2,627 Topics
 | |
| | Does any of you know what DBMS products are suitable for internet database system other than Oracle 8[I]i[/I] ? Thank you? |
| | Hi! I am running an ASP.NET Website on a Windows 2000 Server machine. Sometimes, the Website is not available, an error message saying "No servers are available" comes back on a white screen. Basically, there are two things you can do on the website that result in this error: - … |
| | I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many users login … |
| | Hi, can anyone suggest any clue on this. I am trying to display info on a JSP page. The problem is if the DB date is null then I get the error message below. java.util.Date loginTime=new java.util.Date(login_time); the login_time is a Oracle DB date. Now I want to somehow skip … |
| | I am taking a complex exam for school and I have different programming questions I need help with. Any help will be appreciated. Thanks! Here they are: 1) A company with limited cash needs to bring up a Web server. Which OS/Web server combination has the lowest initial cost? A. … |
| | Hi everyone I am really having trouble right now with oracle for linux. Please tell me how to connect oracle using c/c++ in linux. If anyone knows about any tutorial or have code, please plzzz post me that as well. |
| | hi friends, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many … |
| | Hi friends Can someone help me in this pls.I have 2 tables in my DW One is a table which have all data regarding Income and Expenditure details. The structure (columns) of the table is ctgry_id,ctgry_nm,sbctgry1_nm,sbctgry2_nm,amount.,cmpny_id and tm_id So the records in this table would look like 10001 Wages and … |
 | I'm trying to populate a table from a sub-query. [CODE] CREATE TABLE test ( ID int ) INSERT INTO test VALUES (SELECT [Customer Id] FROM [Customers]) [/CODE] QUESTION: I know you can do this in ORACLE but Is something like this possible in T-SQL. I can also write something like … |
| | [indent][color=darkgreen]:?: [QUOTE] [color=darkgreen]After seeing the news this morning about how the CEO of Scientigo has plans to extract royalties from those who have implemented the XML specification including Microsoft, Oracle, and Amazon (actually, he could probably sue everybody), I asked the man credited with co-inventing XML — Sun's Tim Bray … |
| | I downloaded eAcceleration once to scan my computer, then later I found out it came with spyware, then I unintalled it. Later on, I spot there's still a folder "Acceleration Software" under Program files with some files in it. I deleted the Acceleration software afterward. That's where the problem begins. …  |
| | Hi Folks! Wonder if you can help?? I need to know a way of updating a column in Oracle (datatype: long) but keep the existing data so like an append. Am using Coldfusion to write to Oracle and I know that you can only write 4000 chars at a time, … |
| | hi friends, i/m not that experienced in ORACLE. ..and i am not in to that domain. but a neede arise. i want to read bulk data (we cant predict the format of data) coming from a network connection into ORACLE-8i server. how i code this requirment? please help me giving … |
 | Hi :o , I would like to know if it is possible to write a console program in [B]MS Visual C++ 6.0 [/B](ATM transaction program), that stores data to a database such as [B]MS Access 2002[/B] or [B]Oracle 9i[/B], through [B]ODBC[/B] :?: I've searched all over the net and I …  |
| | I have linked via odbc from within MS Access 2003 to a table in an oracle database. In oracle the field would display a whole number such as 410000000000020000000. In oracle it's defined as number and size of 21. When I view the table in access the numbers appear like … |
| | Team of Web developers is looking for customers/partners for development of Web programs, regardless of task complexity. A wide experience in development enables us to develop different projects: we can fulfill simple tasks such as Web site development and up to the difficult one such as the development of complex … |
| | Dear Python Gurus: I am a very new Python user, would really appreciate your help. I used Python to write a web form for users to enter. The underlined database is Oracle. One validation needs to enforce to eliminate duplicates entries. For example: one customer ID can only be entered … |
| | WIN $ 50 - CHALLENGE TO TECHIES Respected computer techies and dear friends, I am confronted with a baffling problem and it appears that only a computer guru can solve it with his knowledge, expereience and skills. Here goes the problem: I have one SATA seagate HDD 160 GB having … |
| | friends can u guide me how to get started using oracle .never used oracle before .is there any useful weblink. |
| | Hi folks, This is an odd question, but how would you get into the field of database administration? It seems like all jobs in this field require at least a couple of years experience... the old 'chicken and the egg' scenario. Are the Oracle exams worth doing? Well, an info … |
| | 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 … |
| | [url="http://www.petefreitag.com/item/455.cfm"][font=Century Gothic][color=darkslateblue]http://www.petefreitag.com/item/455.cfm[/color][/font][/url] [b][font=Century Gothic][color=darkslateblue]Web Development Cheat Sheets[/color][/font][/b] [list] [*][url="http://www.ilovejackdaniels.com/javascript/javascript-cheat-sheet/"][font=Century Gothic][color=darkslateblue]JavaScript[/color][/font][/url] [*][url="http://www.ilovejackdaniels.com/css/css-cheat-sheet/"][font=Century Gothic][color=darkslateblue]CSS[/color][/font][/url] [*][url="http://home.tampabay.rr.com/bmerkey/cheatsheet.htm"][font=Century Gothic][color=darkslateblue]CSS[/color][/font][/url] [*][url="http://www.ilovejackdaniels.com/resources/colour-chart/"][font=Century Gothic][color=darkslateblue]Hex Codes[/color][/font][/url] [*][url="http://www.psacake.com/web/dy.asp"][font=Century Gothic][color=darkslateblue]HTML[/color][/font][/url] [*][url="http://cdburnerxp.se/htmlcheatsheet.pdf"][font=Century Gothic][color=darkslateblue]XHTML[/color][/font][/url] [*][url="http://www.cookwood.com/html/extras/entities.html"][font=Century Gothic][color=darkslateblue]HTML Entities[/color][/font][/url] [/list] [b][font=Century Gothic][color=darkslateblue]Databases / SQL Cheat Sheets[/color][/font][/b] [list] [*][url="http://www.ilovejackdaniels.com/php/mysql-cheat-sheet/"][font=Century Gothic][color=darkslateblue]MySQL[/color][/font][/url] [*][url="http://nparikh.freeshell.org/unix/mysql.php"][font=Century Gothic][color=darkslateblue]MySQL[/color][/font][/url] [*][url="http://www.technochallenged.com/oracle-8-cheat-sheet.html"][font=Century Gothic][color=darkslateblue]Oracle[/color][/font][/url] [*][url="http://www.3gwt.net/demo/SQL_redux.html"][font=Century Gothic][color=darkslateblue]SQL[/color][/font][/url] [*][url="http://www.selectorweb.com/sql_sybase.html"][font=Century Gothic][color=darkslateblue]Sybase[/color][/font][/url] [/list] [b][font=Century Gothic][color=darkslateblue]Language Cheat Sheets[/color][/font][/b] [list] [*][url="http://www.petefreitag.com/cheatsheets/coldfusion/"][font=Century Gothic][color=darkslateblue]ColdFusion[/color][/font][/url][font=Century … |
 | i'm not sure how to go about doing this but basically there is 4 sheets spread out with different values in an attempt to make this process entirely automatic the numbers are pulled from oracle and other sources into excel through various scripts. there is a name range in every … |
| | Hi All, I am new to java/jsp. I have made a jsp page. And i have included the java code in jsp itself using <%,%> tags. Now i want to move the code to java files keeping this as plain jsp. I think i need to use java beans.Can anyone …  |
| | [B]Hello, I have over 7+ years of experience in software development. I am software developer looking for freelance or Full Time work, do you have any work that need to done.. buzz me at sumeet.leo @ gmail.com my skill sets: .NET(ASP.NET / C# / VB.NET) VB, ASP (VBScript & Javascript), … |
| | |
| | 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. … |
| | Hello, Since sometimes, I have been thinking for any certification which can enhance my reputation and skills. How would be OCP. Tell me. Presently I’m working on DBMS project, so that may be helpful. I looked few sites, on ucertify, they are offering 70% discount and online books are very … |
| | 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 … |
| | SWITCHING between TWO separate physical HDD drives… Well… Situation: TWO separate HDD in one CPU: (Say): a. One HDD of 80 GB used for general work and internet etc…(having its own windows xp prof OS) b. Second HDD of 160 GB containing utmost critical and sensitive applications and data…(having its …  |
| | Hi, I have connected to a MS Access database but when I try to insert data through the java interface, it gives an error which is [MICROSOFT][ODBC MICROSOFT ACCESS DRIVER] TOO FEW PARAMETERS.EXPECTED 2. I dont know y its giving me this error. All the parameters r correct. Can any … |
| | 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 …  |
| | URGENT HELP NEEDED - critically important...!!! Respected geeks, Coming straight, here goes the problem: Background: Hardware: HDD SATA SEAGATE 160 GB RAM: DDR RAM 1.5 GB Dual Processor P4 3.2 Ghz Operating System: Windows Advanced server 2000 Application: SAP (an ERP PACKAGE) Database: Oracle 9i Note: Same single desktop computer … |
| | APC UPS Model Number undecided - Final decision awaited...!!! Thanks everyone for putting forward their opinion about UPS to my previous post. I have read all the posts over and over again and finally have decided that I will purchase a UPS from APC. Now again...few more questions though...???? A … |
| | This is a long one so plz bear with me: I am 27 years old. I hold Bsc in biomedical engineering.I worked in the field of laboratory equipments for a while then I decided to learn something more creative rather than procedural and work with visuals rather than control boards/circuits … |
| | Hi, I am running a system which consists of eight concurrent Java processes. All these processes run on the same box and are backend daemon processes which means they are designed to be started and then run continuously, as they are backend processes they have no user interface. Thus the … |
| | 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 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? |
| | I have been browsing the internet trouble-free for the past several days, but yesterday after I restarted, I could no longer access web pages through Internet Explorer. Mozilla Firefox is still working fine, but every page I attempt to visit with IE returns the standard "The page cannot be displayed" … |
| | Hi Everybody, I am primarily a Java/Oracle/UNIX developer working for a telecoms company, but I get my fingers in almost all the pies :) I have been developing in Java and Oracle for a few years now, though I have worked with *NIX environments for much longer than that. I … |
| | 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 have some html ability and am able to code a web site to do a lot of things. I also have 300+ hours of Oracle Database administration, so I understand how a rational database works. I just do not have the ability to get the front end and the … |
The End.