1,488 Topics
 | |
| | I am new at oracle and working on a small project. I am trying to find "[" in a field and produce from that point to the end of the field. My code is as follows: [code] declare startPos PLS_Integer; endPos PLS_Integer; begin set startPos := (Select top 1(instr(description, '[', …  |
| | Hello. I'm trying to connect with an Oracle database but i can't. This is the code that i have write: dbConexion : TADOConnection; dbCursor : TADODataSet; begin dbConexion := TADOConnection.Create(nil); dbConexion.ConnectionString := 'Provider={Microsoft ODBC for Oracle};Server=ss-server;Data Source=;User Id=id;Password=password;'; dbConexion.LoginPrompt := False; dbConexion.Open; I don't know whats wrong there. User id … |
| | Hi all, Is it possible to insert a SQL statement where I specify the time, and not the date. I do need the date, but I want it to be the current date when I run the insert statement. The time got to be fixed. For example, Insert into xxx …  |
| | hello , (begginer of SQL) i have to make one pro. in which i have to use trigger which will fire before inserting into table and convert the name into upper case but i don't what is the prob. with the code pls provide ur suggetion my table attributes are … |
| | 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 … |
| | |
| | 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 … |
| | 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 … |
| | 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 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 … |
 | 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 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!  |
| | 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 … |
| | 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 … |
| | 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, … |
| | 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 … |
The End.