my question
Please be clear a.Give an example of what youR RESULT should look like and what is your input

View Answer   |  October 9, 2007  7:11 PM
Parsing, PL/SQL, SQL

SQL joins on encrypted data
If your encryption padds the encrypted value with filler data then yes, the join could fail as the values wouldn’t match. If you aren’t padding the encrypted value then your values should match and you should be able to do the join.

View Answer   |  October 5, 2007  8:26 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web site design & management

SQL 2000 to Yukon Migration
You would either need to setup a new server running SQL 2005, or install a SQL 2005 instance leaving the SQL 2000 instance. Then detach the databases from the SQL 2000 instance and attach them to the SQL 2005 instance. Be sure to do full testing to make sure that there won’t be any issues [...]

View Answer   |  October 5, 2007  8:18 PM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

Dell Laptop NIC not showing up
Gforsythe | Sep 30 2007 8:36PM GMT Whenever I have to reload a dell, I always have to go to Dell and download the driver package for that Dell device and install the NIC drivers. Since your wireless is working, if you have internet access over that connection, your golden!

View Answer   |  October 1, 2007  1:28 PM
D510, Dell, Latituded, NIC, Problems

what is normalization
Bacially it is when you create a database and organize it into tables to get consistent results. You can see the <a href=”http://searchsqlserver.techtarget.com/sDefinition/0,,sid87_gci212669,00.html”>Whatis.com definition here</a>

View Answer   |  September 19, 2007  4:23 PM
Normalization

Oracle Question
ChrisGee, You may want to consider using the Oracle Label Security and Virtual Private Database features with a single database for training. Here is a link to more info: http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96578/intro.htm#1008265 Hope this helps. Charles

View Answer   |  July 19, 2007  10:17 AM
Oracle

C#.Net
Hi Colleen. I’m President of GLUGnet.org, the Lansing MI area user group for .Net. We have over 350 developers on our email list that covers essentially the entire central Michigan area. Since the Michigan economy is struggling and jobs are tight, you should get a strong response to a posting at our job website, jobcoin.glugnet.org. [...]

View Answer   |  July 12, 2007  10:57 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools

odbc access error…….
The best way to fix this is to load this data into a database (access or other) that all your users can see. Because you can open file: You could dump the info into flat flies and then load these flat flies into the database that all users can access. Drew

View Answer   |  July 2, 2007  11:00 AM
Database, DB2, Oracle

Find student whose attendence is less than 75%
select a.studentno, (sum(decode(a.presence_k,’P',1,0))/count(a.presence_k))*100 as PercentAttd from attendence a where a.subject_k = ‘AC’ group by a.studentno having (sum(decode(a.presence_k,’P',1,0))/count(a.presence_k))*100 < 75

View Answer   |  June 23, 2007  7:40 AM
Oracle

Select last 3 transactions
are you looking for an SQL statement to embed in RPG? COBOL? JAVA? or for some other SQL based interface?

View Answer   |  May 22, 2007  8:28 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL

Email Validation Software
What exactly are you trying to validate? We do quite a bit of bulk email to student populations, and “a high percentage of blounced emails” is a relative term. It may very well be that your experience with this population is typical/expected.

View Answer   |  May 21, 2007  3:54 PM
AS/400, CRM, Database, DB2, E-business, Ecommerce applications, Email, Exchange, Oracle, Web services

SQL behaves differently in two identical Oracle 10g db’s
Yes, the size of certain files DOES drive the optimizer’s plan. You can weigh in on the plan as follows (code shown is fully optimized): SELECT /*+ INDEX(a) INDEX(b) INDEX(c) */ ______99, ______31, ______b.school_id, ______a.provider_id, ______a.student_id, ______’2007′, ______’01′, ______’0′ ___FROM studprovider a, ______student b, ______school c ___WHERE a.student_id=b.student_id AND ______b.school_id=c.school_id AND ______a.provider_id=527 AND ______b.t_districtid=31 AND [...]

View Answer   |  May 15, 2007  3:17 PM
Oracle, Oracle 10g, SQL

outer join issue
Old Oracle syntax: SELECT s.name, ______DECODE(lm.name, _____________NULL, ‘The first hop failed’, ___________________DECODE(L.name, __________________________NULL, ‘Second hop failed’, ________________________________’Success’)) status ___FROM Source s, ______LookupMap lm, ______Lookup L ___WHERE s.name=lm.name(+) AND ______lm.lookupName=L.lookupName(+); New Oracle ANSI syntax: SELECT s.name, ______CASE _________WHEN L.name IS NOT NULL THEN ‘Success’ _________WHEN lm.name IS NOT NULL THEN ‘Second hop failed’ _________ELSE ‘First hop [...]

View Answer   |  May 10, 2007  1:56 AM
Database, DB2, Oracle

Cannot get iSQLPlus to work
Are you specifying the correct port number for the http server? To find out the correct port or the exact url you are supposed to input, check in the setupinfo.txt file in the C:oracleora92ApacheApache directory.

View Answer   |  May 7, 2007  5:02 AM
Oracle

media recovery
best is to create a link betwwen c: and S: Is db in archivelogmode? Was db in restricted mode? Did you enter the recovery command ie “recover database;” to actually recover. Initsid.ora locations need changing. Hard to diagnose further. Keep me in the loop please.

View Answer   |  April 10, 2007  3:29 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML

Optimizing/Indexing to find last transaction
Most important, do you have an index on transaction that consists of item, version and lasttran? You need lasttran included to make the index work. I think that’s the problem. What may be beneficial is to create a work file containing the last transaction of each item in the warehouse. Then create an index on [...]

View Answer   |  April 3, 2007  12:56 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL

convert query results to excel format
There is a company called Linker IT Software that has a product call SQL*XL that links Excel to an Oracle database. It allows you to pull result sets from the database directly into Excel Here’s the link: http://www.oraxcel.com/projects/sqlxl/index.htm

View Answer   |  March 19, 2007  12:28 PM
Oracle, Oracle administration, Windows

Updating one record with a field of another record where two other fields match
In DB2 or Oracle, use: UPDATE xref a ___SET id1 = ( ______SELECT b.id2 ______FROM xref b ______WHERE b.projId=’AWPE’ AND _________a.id1=b.id1) ___WHERE projId=’MONDPL’; In MS SQL Server, add AS after xref. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linker.com) 800-315-1174 (+1-949-552-1904)

View Answer   |  March 1, 2007  4:52 PM
Data analysis, Database, DB2, Oracle, SQL

Lotus Domino Database Structure
Lotus Notes viewa are not same as table structures but you can make them similar to tables. Views are not RBBMS compliant. but these viewa can be exported to tables using odbc connection or Decs or LEI etc..

View Answer   |  February 23, 2007  12:12 AM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server

Special Characters getting Replaced
Without seeing your SQL code, my guess is that you’re storing 16-bit characters into an 8-bit field. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)

View Answer   |  February 13, 2007  2:52 AM
Oracle