2,627 Topics
 | |
| | We're using a lot of typed datasets in ASP.NET application, most of them have many tables+adapters and each table has some functions that call Oracle Stored Procedures. It works using System.Data.OracleClient. Our purpose is to make a migration to ODP.NET ( Oracle.DataAccess ). If i build a new typed dataset, … |
| | hi I have got a table for "internet access" with user ID, it has 3 columns user ID, starttime and endtime, i want to make another column which will show how many mins or hours that user was logged in to the internet and also add the total time if … |
| | I am working on an Oracle homework assignment, working in shell, trying to query a tricky display question my professor has asked for. I will show both tables, and what I have to execute. [code] SQL> describe orderline Name Null? Type ----------------------------------------- -------- ---------------------------- LINENUM NOT NULL NUMBER(3) ORDERNUM NOT … |
| | |
 | The Department of Justice (DOJ) is investigating [URL="http://www.ibm.com"]IBM[/URL]'s computer market conduct and, depending on the outcome, it might just affect your beloved [URL="http://www.apple.com"]Apple[/URL] computers. As everyone knows, IBM is the major player in the mainframe computer market but now their business practice of not licensing other hardware makers to run … |
| | Hi! I need a great favor... if someone could help i really appreciate... heres the deal: i made one year ago a webpage with a database on isQL*plus ([B]pl/sql[/B]) language.. on my webpage i have this (i will show images to you understand better what i mean): [URL="http://img36.imageshack.us/img36/5783/gerirjogadores.jpg"]http://img36.imageshack.us/img36/5783/gerirjogadores.jpg[/URL] code: [CODE]procedure … |
| | Name: Darlene Height: 5'8'' Weight: 175 Hair: Brown, but sometimes highlighted with blonde. Eyes: Brown Location: MI Age: almost 40 Hobbies: Playing the piano, oboe and flute, reading and doing puzzles. Relationship Status: Married Children: 4 kids - 12, 17, 18,19. The older two have moved out of the house. … |
| | [COLOR=DarkRed][SIZE=3]Dear All i am not a computer professioanal but i know how to write the programmes in oracle, VB and webpage development..... I am working in a organization. now this organization wants to install networking..... this responsibility has been kept on my shoulders..... honestly speaking i dont know much about … |
| | Hi Friends, I am having problem with the above code snippet. Initially it woked fine. But now it is giving an error of java.sql.SQLException: ORA-01722: invalid number. How can I resolve the exception? Thanks. [code=JSP] try { String ein=(String)session.getAttribute("EIN"); System.out.println("inside try block"); Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@10.9.16.2:1521:TESTDB","HE","HE123"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select distinct REV_OWNER … |
| | With the release of [url=http://esd.ingres.com/] Ingres Database 9.3[/url] today, the company says it's now easier for developers to migrate their application to the open source system from MySQL, Oracle,SQL Server and Sybase. It does so, the company said, through "improved accessibility of table procedures from within the query" and support … |
| | heyy can ny 1 help me.....m wrking on jsp using ajax......i built a small application...as m new to ajax.....i built 2 field....FNAME & Lname and when my application used to do is..when you enter ur first name.....n press the tab button...the last name shld come from data base......but its nt …  |
| | This is a problem that is killing me. It is a school assignment and I can't figure it out so any help will be great. I have eleven questions, and I have five of them answered. I have these tables with these fields: Table:sales_rep Columns:Last|First|Street|City|St|Zip_Code|Total_Commision|Commision_Rate Table:customer Columns:Last|First|Street|City|St|Zip_Code|Balance|Credit_Limit|slsrep_number Table:part Columns: Part_number|part_description|Units_on_hand|it|warehouse_number|unit_price …  |
| | Hi, I just started learning how to use oracle I am suppose to create a table for a school that includes class, instructor, enrolls and teaches. I've basically understand everything, but my only problem is I keep getting a with my schedule_num in my class table. It is suppose to … |
| | Hi, I wanted to find out, which are the best-selling and most useful books on Oracle DBA, Development and applications. I request Daniweb members and other experts to pitch in their opinions with 1> Best Book for the Oracle DBA, 2> Best Book for Oracle developers, 3> Best Book for … |
| | Hi , Can we have an sql query to get the max 5 values from a column? Please paste a sample code if its possible. Thanks in advance. |
| | Hi, I have a FTP shell script which is used to move the file from linux server to Windows FTP machine.Here my problem is some times because of network problem the files are not moving to FTP .Here i want to get the mail weather the files are moved to … |
| | Hi all I have a datagrid filled with data from Oracle database, I have a textbox and a button search and on the textbox a person/user can enter the Title of the book he/she wana search the the results should be displayed in the datagrid here is the code on …  |
| | Hi, I have written a sql script which takes the rows from a table and writes it to a .csv file. The script is as follows:- [CODE] set feedback off; spool output.csv; set heading off; SELECT username||','||profession from users; spool off; [/CODE] This works fine but output.csv contains a blank … |
| | Ya ii agree that iam Btech in CSE, but not at all a Professional....Now doing Oracle 9i dba....Searching for a job too....Note that im a fresher... |
 | A reply on so many data and SQL questions, this attachment has 20 forms with all different connection samples and data related queries. This will put any beginner on the right track to successful coding in vb6. I have put together this sample from numerous others over the past few … |
 | hello! As i am trying to insert multiple rows using following command [ICODE] insert into customer(c_id,c_name,c_city,c-street) values('C101','Hayes','Downtown','Main'), ('C102','Willum','Perryridge','North'), ('c103','Smit','Brooklyn','Park'); [/ICODE] It always gives me an error that [TEX] ERROR at line 2: command not properly ended [/TEX] Please tell me why this error is occuring & what's solution to it? … |
| | Hi everyone, am Elly from Kenya and a Student taking Mathematics and Computer Science.Am into Java Programming and Database Systems-Oracle, and also wed programming. Hope my stay here will be an educative one.Ciao! |
| | |
| | Hi there, I'm trying to write a SQL query based on the following tables. [code=sql]create table purch ( integer user_id, * integer product_id, * integer item_count, date purch_date * ); create table product_categ ( integer product_id, * integer category_id )[/code] Could someone tell me how to find the lag between … |
| | Hi I use the following code to connect to an orace database in Visual Studio 2008 and it is falling over with the exception of ServerVersion threw an invalid operation exception at line 3: [CODE=C#]m_strConnectionString = Settings.GetMandatoryConfig("databases", "SourceDB"); m_strQueryTerminator = Settings.GetConfig("databases", "QueryTerminator"); m_odbConn = new OleDbConnection(m_strConnectionString); m_sql = new SQL(DatabaseType.AnsiSQL, …  |
| | [B]I am developing a database programme on VB 5, but i do not want to use MS Access as the database. Is there any help available for Oracle or SQL Server databases? Thanks[/B]  |
| | ANyone of you would please refer me preparation material for 1Z0-007 Introduction to Oracle9i: SQL exam?This is first step to be OCA certified. What I've found as of now is: [url]http://www.amazon.com/OCA-OCP-Introduction-Oracle9i-Study/dp/0782140629[/url] [url]http://www.amazon.com/Oracle-9i-Exam-Cram-1Z0-007/dp/0789732483[/url] Thank you in advance!  |
| | hello, i have visual studio 2005 installed in my computer and i am using oracle as server. i am not able to write the connection string in the web.config. from control panel-> add administrative tool->data odbc->system dsn i have added a dsn 'data'. database name is employee please help me. … |
| | I am trying to accomplish a Master Detail Display here. The master item is ProductName and Child items are the details of the Product. Example: Dell Desktop V305 - Model: Black - 23877487y24y - Mother Board - Intel .... - RAM - 3 GB DDR HP Printer - Ink Jet … |
| | [B]For Sale By Owner:[/B] One Commercial Linux Company with excellent history and reputation in the enterprise Linux arena. Profitable concern specializing in open source and Linux-based solutions. Offers top-notch distribution with broad hardware support, superb technical solutions, built-in virtualization, education and certification programs. Known to the technical world as [URL="http://www.redhat.com"]Red … |
| | Just like the international gang summits in Los Angeles, Linux needs a collective, "sit-down" to discuss the future of this now formidable operating system. I'm not talking about a nice little get together with keynote speakers with high-powered, 10,000 foot views of where Linux is and where it's going. And … |
| | This post has nothing to do with Michael Jackson, his death, his kids, his Neverland Ranch or anything related to him. It has everything to do with my need for a virtual laboratory where I can test virtual machines, write about them or produce other documentation about them without a … |
| | [URL="http://blogs.zdnet.com/perlow"]Jason Perlow[/URL] and I had the pleasure of interviewing [URL="http://www.kickfire.com"]Kickfire[/URL] CEO Bruce Armstrong for the May 22nd episode of [URL="http://www.blogtalkradio.com/frugalfriday"]Frugal Friday[/URL] to discuss the Kickfire appliance. The Kickfire appliance is a Linux-based, rack-mountable, database appliance tuned for Data Warehousing. Here's the real scoop: Starting at a mere $32,000 US, you … |
| | InterOp 2009 is a success by anyone's measure but it's been a mixed bag for me so far. Internet access on the show floor is almost non-existent. For a major tech show like this, it's absolutely ridiculous. You'd think that Internet access would be a standard feature of any technical … |
| | Well, well, well...Larry Ellison, [URL="http://www.oracle.com"]Oracle[/URL] CEO [URL="http://www.oracle.com/us/corporate/press/018535"]added[/URL] [URL="http://www.virtualiron.com"]Virtual Iron[/URL] to his collection today. Congratulations, Larry. When is Oracle going bankrupt? Every time that I've seen a company acquire too many other companies in a short time period, they always end up in the dustbin. Oracle just acquired [URL="http://www.sun.com"]Sun[/URL] just one … |
| | Will the tech sector lead an economic turnaround? Forbes.com thinks so. This week, Peter C. Beller writes that Monday’s IBM revenues numbers and the fallout from the proposed Oracle and Sun Microsystems could lay the groundwork for an economic rebound. I’ll get to the IBM numbers in a moment, but … |
| | As you probably have heard, Oracle bought Sun for $7.4 billion today. I'm no Larry Ellison fan, because frankly, I think he's a few cards short of a full deck but I think in the long run, this is good for Sun. Not all of Sun but a lot of … |
 | It's probably a little early to be looking for implications of Oracle buying Sun (no, it's official, here's the [URL="http://www.oracle.com/us/corporate/press/018363"]press release[/URL]). They've only just confirmed it's happening, and as one of the journalists who covered Novell buying Lotus many years ago I can confirm things aren't done until they're done, … |
| | Just one follow-up note (as promised) on the Sirius XM situation. Just days before Sirius XM purportedly was going to default on its next loan payment, Direct TV came through with a $534 bridge loan to keep Sirius afloat so it can continue to reorganize – possibly as a takeover … |
| | It’s another tough morning for tech stocks, with Apple, HP, Oracle, Motorola, Google, and Dell all seeing their stocks fall 2% or more. The falloff is primarily from the news that consumer/retail spending fell 2.7% in December – twice the amount that economists had expected. At least the companies I … |
| | Oracle, Research and Motion and Palm are all releasing earnings statements today, and that should pick up momentum in what has been a fairly dormant technology trading week. The web site Tradingmarkts.com thinks the earnings news means opportunity in two technology-heavy exchange-traded funds (ETFs); Technology Select Sector (SPDR ETF XLK); … |
| | Both the Dow and the Nasdaq are flirting with positive territory today, thanks in part to one biotechnology stalwart, Amgen, which is up three points in trading. Why? Well, the Street is getting excited about life sciences stocks again, as several research reports hit the street suggesting that the biopharm … |
| | Here we go again. I can't remember how many years ago it was that I gave a talk to a major Enterprise software supplier's customers (and a couple of its executives - two of them, that becomes important a little later) on the nature of the small to medium enterprise … |
| | Trying, ever so hard, to find some good news amidst the doom and gloom on Wall Street. At least the market went up for a second straight session, with the DJIA up 400 points on Monday trading; that after rising 500 points last Friday. Investors seemed cautiously optimistic about the … |
| | Is it 2010 yet? Few people want to wish their lives away, but Wall Street might gladly trade a year of its life for a time machine that would take the market straight to 2010, when hopefully this mess will be behind us. Today's Barron's lays out the numbers and … |
| | Google's stock is up 10% today, and the stock market is up over 250 points (at 2 PM EST), and I don't think the twin spike is merely a coincidence. Why? As I wrote yesterday, the market looks to major tech players like Google, Apple and IBM, just to name … |
| | The other day, I saw an article on Forbes.com named [I][URL="http://www.forbes.com/2008/10/10/ellison-cloud-computing-tech-enter-cx_wt_1010oracle.html"]Ellison Shoots Hole in Cloud[/URL][/I] and just had to read further. I did read it. The whole thing. I was puzzled, then I laughed, and finally I was mystified by his comments. The article made me wonder just what the … |
| | I've been writing for a year now on how the information technology sector would be impacted by an economic downturn. Well, it looks like we're going to really find out. As I've written, when credit dries up and loans and capital are hard to get, tech companies hunker down and … |
| | One of the year’s biggest disappointments has to be Seagate Teachnology. The high-tech heavyweight is taking on so much water that barnacles are starting to grow on its bottom line. Hey . . . at least something is growing on Seagate’s bottom line. Before I get into Seagate’s woes, I … |
 | There's an old and tired theory that open source solutions in enterprise are risky because there's no "single throat to choke" if things go wrong. It's time to retire that worn out idea. The process goes something like this: The IT department gets into a discussion with the big bosses … |
The End.