Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Problem with change heading in a self-join table
- Hi all and thanks in advance, i've got the following table but I need change some of its heading. Could you help me with that please. Here is the table TTITLE 'PHYSICAN SALARY'SELECT a.phys_name, a.phys_salary, b.phys_name, b.phys_salaryFROM physician a, physician bWHERE a.phys_supvisor_no = b.phys_ref_noAND a.phys_salary < b.phys_salaryORDER BY a.phys_name;
- Tags: alan.sarchnar@...
- Discussion threads 2007-04-27
- Oracle join table and calculation problem
- Hi all and thanks in advance,I need to output the patient's name, patient's address, item_code, description, and total cost for a particular month in the folloing tables.Here are the tables CREATE TABLE patient( pati_Ref_no ...
- Tags: Oracle Corp., alan.sarchnar@..., pati_Ref_no, Varchar2, Primary Key, patient
- Discussion threads 2007-04-23
- Oracle join table and calculation problem
- Hi all and thanks in advance,I need to output the patient's name, patient's address, item_code, description, and total cost for a particular month in the folloing tables.Here are the tables CREATE TABLE patient( pati_Ref_no ...
- Tags: alan.sarchnar@..., Oracle Corp., pati_Ref_no NUMBER, Varchar2, Primary Key, patient
- Discussion threads 2007-04-23
- Oracle join table and calculation problem
- Hi all and thanks in advance,I need to output the patient's name, patient's address, item_code, description, and total cost for a particular month in the folloing tables.Here are the tables CREATE TABLE patient( pati_Ref_no NUMBER(6) NOT NULL, ...
- Tags: alan.sarchnar@..., Oracle Corp., pati_Ref_no NUMBER, Varchar2, Primary Key, patient
- Discussion threads 2007-04-23
- I need help with oracle please
- Hello all,I want to output the physican's name and the physician's salary for the following table. however I need output this information where physician's salary is less than his/her supervisor's salary/* Physician Table */CREATE TABLE physician( phys_Ref_no NUMBER(3)...
- Tags: alan.sarchnar@..., physician
- Discussion threads 2007-04-23
- I need help with decimal places please.
- Hi all and thanks in advance,I have the following table but when I insert some values, the program displays an error message it says "(101,'Smith',30000)ERROR at line 2: ORA-01438: value larger than specified precision allows for this column" Here are the table and insert value:CREATE TABLE physican( ...
- Tags: alan.sarchnar@..., cell
- Discussion threads 2007-04-22
- Hi all and thanks in advance,
- I have the following table but when I insert some values, the program displays an error message it says "(101,'Smith',30000)ERROR at line 2: ORA-01438: value larger than specified precision allows for this column" Here are the table and insert value:CREATE TABLE physican( phys_Ref_no NUMBER(3) NOT...
- Tags: alan.sarchnar@...
- Discussion threads 2007-04-22
- I need a help with sql nested sub query please.
- Hi,I can create this view;CREATE VIEW view1 ASSELECT p.bedno, p.refno, p.surenameFROM patient pWHERE p.bedno = (SELECT bednoFROM bed WHERE bedstatus = 'USED');But when I "SELECT * FROM view1", I get this error message it says " ERROR at line 2: ORA-01427: single-row subquery returns more than one row".I need count...
- Tags: alan.sarchnar@..., SQL
- Discussion threads 2007-03-21
Additional Resources
- Do Webmasters need to add lawyer and legal counsel to their job description?
- Alan Norton presents the New York online sales tax law as an example of why it's becoming increasingly important for Webmasters to have more than just a cursory understanding of legal issues. by Alan Norton
- Tags: Job, Webmaster, Affiliate, Nexus, Vendor, Newegg.com, New York, Tax Law, Taxes, Free Trade, Financial Planning, Finance, Alan Norton
- Blog posts 2008-09-08
- MY GOD! What is it about Nancy Pelosi and her. . . . .
- .....power-monger attitude? I don't need to provide links; just read the news!I know.I've seen a few video clips of her in the last few days. There is something about her demeanor, gestures, choice of words, and other stuff that irritates me. If I had to spend any time with her...
- Tags: maxwell edison, Alan Alda, Nancy Pelosi
- Discussion threads 2007-01-04
- Will desktop video conferencing improve collaboration and enhance your company's bottom line?
- It sounds like a good idea: connect remote employees with desktop Webcams and instant messaging applications. The reality -- getting it all to work correctly -- is a bit more complicated. Explore the real-world challenges of desktop video conferencing in Desktop Video Conferencing: A Work in Progress, an...
- Tags: Collaboration, informIT, Desktop Videoconferencing, Desktops, Hardware
- Download resources 2007-10-24
- System Sounds not playing
- Hi All,I could be being a bit thick here, but we have a machine, running XP SP2, where in the last couple of weeks, the system sounds (startup, shut down, new mail, all those things) have stopped working. The machine still plays CDs and things, so the sound chip...
- Tags: SOUNDS, codec
- Q&A 2005-03-31
- Moving XP to Boot Drive
- My System was a Dual Boot Win XP or Win 98SE. I got that part removed. WIn 98SE is on the Boot Drive C while Win XP is on the D Drive (A different physical HD - Slave)I want to put Win XP on the Boot Drive and have...
- Tags: Win, Boot Drive, Microsoft Windows XP, MRA2, abramowitza@..., windows
- Q&A 2006-04-12
- How does a new programmer start?
- Hi all, I'm new to this programming stuff and i will some help on how to really start and get a hand on what it entails. What kind of tutorials do I need to read up on? Which programming language is the most versatile, and what makes the dufference between...
- Tags: Development tools, ezeuba1@...
- Q&A 2006-09-01
- But Where is My Amstrad 1510 PC
- Where is MY Amstrad 1510 PC , it had GEM windows graphical OS the little turtle thing with the Paint program and every thing... I even coloured the bloody 6 inch floppy disks so it was easy, worked straight out of the box it did..... YOUR FIRED !!signed Sir Alan
- Tags: Desktops, jeremy_figg@..., Amstrad, PC
- Discussion threads 2007-05-31
- Improving Vulnerability Management with Penetration Testing
- Vulnerability management consists of a combination of technologies and processes that can be used to improve an organization's security posture and to support regulatory compliance initiatives. Security managers commonly use vulnerability assessments to determine the security state of their IT systems. However, changing processes and technologies present a challenge to...
- Tags: Vulnerability Assessment, Vulnerability Management, Security
- Webcasts 2006-09-20
- Problem with Access Database Documenter
- Hi All,I hope you can assist. We have a computer (AMD Sempron 2200 with 80GB HDD and 512MB RAM) running Windows XP Pro and Office 2003. It is connected to a Windows Small Business Server 2003 domain.Everything appears to work fine except for the Database Documenter in MS...
- Tags: Cheers Alan, database, HereInOz, Microsoft Access, windows
- Q&A 2005-03-15
- Windows 2003 Server DNS problem
- Hi All,We have a Windows 2003 SBS server installed which up until last night was running fine. It now appears that this machine is no longer acting as the DNS server for the network, even though the event logs are showing that the DNS server has started and all...
- Tags: DNS, DNS server, HereInOz, it management, Microsoft Windows, Microsoft Windows 2003, Microsoft Windows Server 2003, server, workstation
- Q&A 2005-05-25
- Cannot remove connections form workgroup
- I am trying to revive a network for a new client in preparation to do a total reconfiguration. The network is a simple file and print sharing connection thru 8-port switch with ICS set up on a host machine running out to a satellite modem. Today I changed the names...
- Tags: Debbie, network, squirrelgirl, Web browser, windows, workgroup
- Q&A 2005-01-29
- Open office accessing a Windows share
- Hi all,I must confess that I am at the bottom end of a very steep learning curve here, having installed Fedora 3 Linux and now sorting out how to use it.I have connected the Linux machine to a shared folder on a Windows XP machine, I can see the files,...
- Tags: HereInOz, Linux, Microsoft Windows, Open, OpenOffice
- Q&A 2005-02-14
- << Previous
- page 1 of 1
- Next >>
