Summary: hi all, have a sql question. i have a table which has a column varchar2(10) which holds employee numbers e.g 'X1234'. I need to update these and...
Summary: Hello, i am interested in learning Microsoft SQL, and possible take a low level cert. I would like to start off as inexpensive as possible, so this we...
Summary: I'm rusty with my SQL, but couldn't you do this?INSERT INTO A(primary_key, Name) SELECT sequence.NEXTVAL, name FROM SELECT DISTINCT name FROM B; ...
Summary: Hi, I want to call java class from oracle PL/SQL. I know for this I need to use loadjava command. but for this what kind of settings I need to do at d...
Summary: hi all, when an INTEGER is an alias for NUMBER(38) does that mean i can insert "12345678901234567890123456789012345678" into a column which is de...
Summary: Hi, I have a quick question regarding unions in SQL 2005 (using express edition for development at the moment). I am setting up somewhat of a stock ma...
Summary: i have installed oracle sql 9i on my laptop .But when i try to open it and enter scott tiger in it shows some error tns protocol error. saurabhthelo...
Summary: I find myself very confused regarding database tools and a matter of what does what and what is capable of what. For a personal endeavor of mine, i wi...
Summary: I have developed a few reports on SQL Server 2008+VS 2008 and deployed them to the SSRS built in reporting URL (http://servername/reports) During the ...
Summary: Hi, I am currently working in mainframe.I like to learn SQL.can anyone suggest the best way to get excel in SQL and ORACLE. how the SQL differ from O...
Summary: Quick general question... We have the trial version of SQL 2005 installed and now have the full version ready to be installed. I have read that i just...
Summary: Hi people, I have a question about SQL 2005 stored procedures. I have a stored procedure that determins the current price of a stock item and I want t...
Summary: OK i first want to apoligze for posting a message a couple of months ago about the same issue. It's just that i have no idea what i am doing but i wan...
Summary: Dear Friends, I am learning PL SQL for the first time. In one program I have given the dbms_output.put_line statement. While executing the program i...
Summary: Could anyone tell me what this query would be like converted to Oracle? Thanks in advance. SELECT tblBlock.* FROM tblBlock INNER JOIN tlkpLocation ON ...
Summary: Hey all. I have a quick question on my sql, im a bit new to the the commands ect and havin a bit of bother tryin to figure out how to do the following...
Summary: Hey everyone, im taking an SQL class and im working on my first assignment. It seems simple but i keep getting an Error 1062, duplicate entry '1' for ...
Summary: Hi, I have an issue i need to display a date say (14-sep-2005 11:20:00) as 14-sep-2005 12:20:00) and (22-dec-2005 11:20:00) as (22-dec-2005 11:20...
Summary: To do this with SQL would likely require that the flavor of SQL you are using (MySql, Oracle, Informix, DB2, etc) contain a function that will convert...
Summary: Dear all, i have installed ORACLE 9.2.0.1 and i created db satcom, when i'm trying to connect to the database using sql plus,following errors are impo...
Summary: SQL is, what I think, called a 4th generation language and is supported by pretty much all databases, I'm guessing cost may be an issue so take a look...
Summary: Hi, I'm trying to spool the output of my query in SQL Plus in Oracle to an output file. But, it includes column names before each row. Is there a way ...
Summary: Hi! i would like some help to figure this out: How can i select a datetime field in sql server in an specific format? ie: when i execute: select (date...
Summary: Hi, I am loading a file into multiple tables using SQL Loader: (a) Format of the File is as follows: H|820020080422|03/27/2008|90.00|90.00 D|99.609|AD...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
