SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

IdongesitDaniel5 pointsBadges:

Oracle 9i installation

Hello guys I have recently started learning SQL and I am trying to install 9i (database or software where I can practice SQL quires). Long time ago I started learning SQL on that time it was personal Oracle 7 I installed and used to do my practice but now I have heard that you can install 9i on...

11g5 pointsBadges:

Would like to learn SQL. Which vendor should I go for and what certification should I get?

Hi All, I would like to learn SQL but was wondering shich SQL package should I go for? I am looking for employment in the finance industry as an analyst and thus looking for the right SQL package to learn and get the right certification. Could someone please advise me accordingly. Cheers! Jeevan

Jeevan231015 pointsBadges:

SQL Writer error

SQL error in the start; either mesup or tempered. What should I do?

Chuanilee5 pointsBadges:

SQLCODE and SQLSTAT error messages?

Does anyone know where I can find SQL CODE and SQL STAT error numbers and messages?

Vince0125 pointsBadges:

SQL in an SQLRPGLE program

I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 C/END-EXEC * I entered...

Alpfalpf25 pointsBadges:

How do I retrieve data from Visual Basic 6.0 with SQL?

How can I retrieve data in VB 6.0 from SQL?

Escabarte5 pointsBadges:

SQL code -727

Does anyone know what -727 SQL return code is?

Bebiii15 pointsBadges:

Using SQL code to read a filename

Can you write a SQL query that will read PDF filename from a dir and then match the filename to a data element in a table having the same name? For instance, the filename is 12345.pdf where 12345 is actually an invoice number. Can the query read the filename and then locate the same invoice number...

Teedee5 pointsBadges:

What is the difference between DBMS, RDBMS and SQL?

What is the difference between DBMS, RDBMS and SQL?

kapilsharma5 pointsBadges:

SQL Report Help

Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

Blowinup5 pointsBadges:

When do I use a collection instead of a table in Oracle

I am an old MS SQL server guy and I am doing some work in oracle 10G. Most of what I am doing is all set manipulation(insection between two dataset) My first instinct would be to use temporary tables and use a not exists. I was wondering if that is the most efficient way in Oracle. I read about...

Kmaccrimmon5 pointsBadges:

Adding files to TempDB

Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

SQL Server Ask the Experts2,585 pointsBadges:

DB2 to SQL conversion

How to I convert DB2 to SQL?

cgardel015 pointsBadges:

Upgrading Forms30 on Oracle 7.0

I am upgrading Forms30 on Oracle 7.0 to Oracle 10g First, I am upgrading to Oracle forms 6i using Forms compiler and facing these problems: Converting language on display item. (it doesn't show the right language on display item and headers) Key mapping function. I need script so I can convert all...

Oikhleif30 pointsBadges:

SQL statement using RRN(file) on join pulling only Max(date) records from second file in iSeries

I am using WebSmart with the I-series data base files. I am joining two data base files receiving the RRN so that I can use the fetch rrn and the fextnext to display one screen at a time in my WebSmart program. I have used this method many times except this time I have a one to many relationship...

Isjld35 pointsBadges:

New to SAS need date equivelant for script in proc SQL

I need what the SAS equivalent for this is: to_char (COLLECTION_ENTRY_DATE,'month/yy')as Entry_Month_Y,to_char(COLLECTION_ENTRY_DATE,'DD')asDAY_entry. I have tried putting COLLECTION_ENTRY_DATE,monyy5.) and different variations but without success can you advice? Full script is: proc sql; create...

cyrus20075 pointsBadges:

Using SQL to insert records into a table

I have a table with a period in the table name, i.e. AB.CDE that I need to insert some records into. When I query the table (Select * from "AB.CDE") it works fine. When I try to insert records (insert into "AB.CDE"), however, I get a file not found message. Does anybody know why this is happening?

GaryF60 pointsBadges:

Delete all data in the database

Good day! Currently I am using MS SQL Server 2000. I wish to delete all data in the database table except data in login table and security table. Furthermore, TRUNCATE is done on stand-alone and child tables, else DELETE if table has any foreign key references (normally refer to parent tables): Is...

Hunkgym5 pointsBadges:

Need to create SQL DTS Package

We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also, I want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script?

JimmyIT1,725 pointsBadges: