Re: Display first value only for repeated values in a column
First:
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Break your lines to max 80-100 characters when you format.
Please always post your Oracle version (4 decimals).
Then, is this not just:
SQL> select form_number, elabel_number, system_id, userid_type_format, 2 resource_type, resource_entitlement 3 from elabel 4 order by form_number, elabel_number, system_id, userid_type_format, 5 resource_type_number 6 / FORM_NUMBER ELABEL_NUMBER SYSTEM_ID USERID_TYPE_FORMAT RESOURCE_TYPE RESOURCE_ENTITLEMENT ----------- ------------- --------- ------------------ ------------- -------------------- 4008 42 MFTSBC IDSX** USERNAME abc 4008 42 MFTSBC IDSX** PASSWORD pass12345 4008 42 MFTSBC IDSX** GROUP dxg 4008 42 MFTSBC IDSX** DFLTGRP dxg 4008 42 MFTSBC IDSX** PROFILE prof1 4008 42 MFTSBC SYNCC* USERNAME abc 4008 42 MFTSBC SYNCC* PASSWORD passxy123 4008 42 MFTSBC SYNCC* PROF prof1 4008 42 MFTSBC SYNCC* INSTDATA wel 9 rows selected.
If not please post the result (in tabular format) you should have.
Regards
Michel
Re: *Are* we living in the "Matrix"?
Fifi, I see what you are saying, though the word 'intelligence' is one of those words that can be stretched in every which way. And you seem to be somewhat more optimistic than me with respect to the progression of AI. I had some conversations with Kurtzweil about twenty-five years ago about voice recognition and synthesis and the speed of ... (Read on Source)
Xen 3.1 Binary install on Debian Etch 4...
The comments are owned by the poster. We aren't responsible for their content. Project. All logos and trademarks on this site are property of
Toward A Faster Prenatal Test For Down Syndrome
Scientists are reporting an advance toward rapid testing for prenatal detection of Down syndrome and other birth defects that involve an abnormal number of chromosomes. The test has the potential for producing results for worried parents within two hours rather than the two weeks required with existing tests. (Read on Source)
Easy Magic Tricks Posted By : Malega Michael
Informative article for Easy Magic Tricks subject, tips, ideas, recommendations that is all about Easy Magic Tricks. If you would like to learn more about Magic Tricks, please check our web site by following our link…
Export Mysql data to CSV (PHP)
PHP Database Tutorials
FamilyCrossings.com Gives Families a Home
Same-Page.com is launching www.familycrossings.com. This is a shared virtual space for families to interact, share photos and information and sotre family history without the fear of cyber predators. (PRWeb Feb 7, 2008) Post Comment:Trackback URL: http://www.prweb.com/pingpr.php/SG9yci1GYWx1LUNyYXMtSGFsZi1aZXRhLVplcm8=
Steve Chen Wants Live Video On YouTube This Year
His statement offered less than a 100 percent chance of it occurring, and a wide timeframe to boot. Still, Steve Chen has said that live video should become available on YouTube by the end of this year.
sshpass--Non-Interactive ssh Password Authentication
Debian Admin: "Sometimes, however, it is necessary to fool ssh into accepting an interactive password non-interactively. This is where sshpass comes in..."
Casual games - take it serious
Computer games has always been popular. More and more people play games all over the world. A new kind of games, such as casual games, has become widespread besides console and large games, distributed on CD/DVD. The difference is in the fact that a user can download them freely from the Internet due to their small size and start playing. A small size doesn't mean that these games are not of of good quality as, for example, games for play stations. They excite gamers. The difference is only in gamers audience. Classic games are intended for so-called hard-core gamers, who are ready to spend long hours playing and perfecting their game-playing skills. They are usually teenagers; however they can be adults as well and vice versa...
Google Opens A Smidgen On Search Quality
Competitive concerns and abusive webmasters prevent Google from delving deeper into the secrets behind its search.
TechNet Webcast Audio: New Tools to Streamline Your Windows Server 2008 Imaging and Deployment Proce
We are going to break this webcast into three agenda items. First, we see the new features of Windows Server 2008 that are present when we deploy the operating system. Windows Server 2008, like Windows Vista, was built from the ground up with deployment in mind. The result is a lower cost for migrating to Windows Server 2008 and a lower cost for ownership. These new features include the Windows Imaging Format (WIM) image format, Windows Deployment Services role, and the Windows Automated Installation Kit. Then we look at more complex deployment strategies that involve additional deployment tools, such as the Microsoft System Center Configuration Manager Operating System Deployment (OSD) feature pack. Microsoft has expanded on the capabilities of Microsoft System Center deployment and worked to simplify use of the OSD. It has deeper access to the operating system, in addition to centralized management and reporting, that is appealing to many demanding organizations looking to control server and desktop images. Under the third agenda item, we talk about deployment best practices. The new deployment features are designed around a set of best practices included in the Windows Server Deployment (WSD) solution accelerator. We explain how to use these tools in a variety of ways to suit organizations of different sizes and needs. Original Broadcast Date: Friday, May 16, 2008
UPI NewsTrack Business
British consumers favoring 'green' fish ... Report: NBC near Weather Channel deal ... Part-time workers rising in Japan ... Kindle seen as transitional technology ... News from United Press International.
Dell intros 15.6in Vostro notebook, Atom-based tower
... option of budget Celeron M processors as well as by offering the choice of Ubuntu Linux in place of a costlier Windows Vista install. A 14-inch parallel, the A840, ...
Cancer Breath? New Tool Aims To Detect Cancer Early In Exhaled Air
Early cancer detection can significantly improve survival rates. Current diagnostic tests often fail to detect cancer in the earliest stages and at the same time expose a patient to the harmful effects of radiation. Scientists will be using mid-infrared lasers to create a sensor to detect biomarker gases exhaled in the breath of a person with cancer.
Invoice Factoring — What Is It And What Are The Benefits?
Are you a business owner who wants to increase monthly cash flow, working capitol, and improve your credit rating? Then invoice factoring could be right for you.
Invoice factoring is the process by which businesses sell their invoices to a third party, called a "factor." The factor buys the invoices for about 3 to 5 percent less than the invoice is actually worth. If your business produces any type of invoice, then your business can take advantage of invoice factoring.
Once the factor purchases the invoice, then the factor owns it, and collects the debt from your client. As the business owner, you get to decide which invoices to factor, based on your customers' credit and payment history with your business.
Factoring your invoices means your cash flow does not suffer while you wait for your customers to pay. The factor buys the customers' debt, improving your working capitol and the credit rating of your business.
It works like this: You send an invoice to your customer. Then you inform your invoice factoring company that you have sent the invoice, and in what amount. Usually, that can be done by e-mail, so it's quick and easy.
The second step is the factor confirms the invoice with your client. Usually, this is done in such a way that the customer or client does not know that you have sold their invoice to a third party. The factor will identify itself as a billing department or company, rather than an invoice factor, and will simply call or send a letter to confirm the invoice.
Some invoice factoring companies are willing to keep the factoring completely invisible to your customers. And after you develop a history and good relationship with the factor, they will usually stop confirming every single invoice.
Once the factor has confirmed the invoice, they pay your business a percentage of the total amount of the invoice, usually around 70 to 85 percent. This is called the "advance rate," and it is one of the primary points to look at when selecting a factoring company. When the factor collects the invoice from your customer, you will get the rest of the money you are owed.
Factoring benefits businesses that have poor credit history, no credit history, or limited hard assets. Factoring also helps businesses when they are just starting out, because it can often take time to build up steady cash flow.
Additionally, invoice factoring allows you to increase working capitol without taking liens against your other collateral, so there is little risk to you.
As a business owner you know how frustrating it is when waiting for your customers to pay. Even if your invoices are not past due at all, it can still take weeks to collect the funds you need to put back into your business immediately. Invoice factoring can help your business grow and reduce your own stress level.
Alan Jason Smith is the owner of <a href="http://www.videofactoring.com" target="_blank">http://www.videofactoring.com</a> which is a great place to find factoring links, resources and articles. For more information go to: <a href="http://www.videofactoring.com" target="_blank">http://www.videofactoring.com</a>
Credit Card Charges Are Avoidable
Nearly all credit card companies in the USA, except one, will charge a two to three percent foreign transaction fee if your card is used abroad. Before this particular time many credit card companies did not clearly explain these fees in their terms and conditions.
Earlier this year many people received a notice of a class action lawsuit settlement concerning these fees.As the lawsuit has now been settled credit card companies are required to state in very clear terms what their foreign and international transaction fees are.
If you do not know how much your current credit card company charges for international transactions, contact customer service to find out most will inform you that the fee is three percent. It can end up being quite expensive to pay an extra three percent on every purchase, but you can find away to avoid these charges.
Foreign currency exchange rates from your bank can be somewhat better than what you will get at a foreign currency exchange booth. ATM withdrawals usually are free from foreign transaction fees, using a debit card as a credit card has some risks.
A credit card provides much better fraud protection than a debit card; for this reason using a debit card abroad to make purchases can be risky. When there are fraudulent charges and overcharges made on your credit card you can contest them a receive a refund.
A debit card used fraudulently will make your bank account disappear and it will be very slow to regain. It seems that the best way to pay no international transaction fees is through credit card use of the ones that charge no fees; these no fee credit cards give you security without the added espense.
It pays to know how much you'll spend; this is great for day-to-day life but it's even more important on vacation, ATM transactions carry a small fee...for each transaction. Unless you are on a very exacting budget, it is difficult to be able to judge how much to withdraw in one ATM transaction and few people can tell precisely how much cash they will need while traveling.
Sometimes it is hard to find a cash machine in many countries, so you have to be careful to not withdraw too large an amount to keep from being robbed. You have to pay fees to convert to foreign currency and then you also have to pay fees to convert back to your local currency.
Traveler's checks are a safe alternative to cash but they are not accepted everywhere and there is a fee to purchase them. When applying for the credit card you believe will not charge any additional fees for foreign purchases be sure you study the terms and conditions carefully to be absolutely sure you are getting the right card.
Check the terms of the card before using it and be sure you can pay off the balance in a hurry if the interest rate is high so you won't be paying fees in a different way.
Alisdair Cosgrove has been writing finance articles for many years and can find more of his work at the UK site CreditCardsWeb.co.uk, offering <a href="http://www.creditcardsweb.co.uk/low-rate-credit-cards/">credit cards with low interest rates</a> for UK residents and also a great selection of <a href="http://www.creditcardsweb.co.uk/0-credit-cards/">0% purchase credit cards</a>. Visit today to read more of Alisdair's great credit card articles including <a href="http://www.creditcardsweb.co.uk/200809/little-point-in-a-rewards-based-credit-card-for-those-that-fail-to-collect/">best rewards credit card use</a>.
Tube Bits for
Good news and bad news for Galactica fans: The DVDs of Season 4 are set to be released on January 6th (good), but Season 4 will actually be split into two DVD releases (bad). Gee, thanks Sci Fi, way to milk the show for as much cash as you can get. Pablo Defendi from Tor.com reviews the first episode of the American version of Life on Mars . I ... (Read on Source)
Daily Search Forum Recap:
Here is a recap of what happened in the search forums today, through the eyes of the Search Engine Roundtable and other search forums on the web. (Read on Source)
Neil Patel Wants to Fund Your Project
Neil Patel of ACS and QuickSprout wants to give you money. There are few people in the SEO world that have been as respectful and helpful to me than Neil Patel. He is now part of a venture capital effort to provide up to 250,000 in exchange for equity in your projects or upcoming projects. To learn [...] (Read on Source)
The Q, with Celtics coach Doc Rivers
... journey in front of us. Q: Last year, you had a team word -- ubuntu, an African word meaning "I am because we are." Do you have a new ...
Satellites map cholera outbreaks
This could provide an early warning system for India and Bangladesh where cholera epidemics occur regularly. Tiny animals which increase in number with sea temperature rise bring the cholera pathogen into the drinking water supply. (Read on Source)
Skye's dinosaur connection to US
Footprints of dinosaurs found on a Scottish island are of the same, or a similar species, which left their mark on Wyoming.
WHO sets limitations on use of melamine
(AP) -- The World Health Organization said Friday that tiny traces of the chemical melamine are not harmful in most foods, except baby formula, but it joined the U.S. and EU in setting a strict limit that regulators should impose before pulling products off the shelf. (Read on Source)
AT&T To Cut 4% of Workforce
December 5, 2008 -- ( <http://www.thewhir.com> WEB HOST INDUSTRY REVIEW) -- The largest telecommunications services provider in the US, AT&T, plans to lay off 12,000 people and reduce new technology spending, amidst similar cuts across an industry which is beginning to feel the pain of the economic nosedive.
The 25 Hours of Thunderhill Can't Tame the Toughest Turbocharged Scion tC on the Planet
A barrel roll late Thursday in practice couldn't stop the Turbonetics turbocharged scrappy Scion tC from finishing the world's longest endurance race held at Thunderhill Raceway. (PRWeb Dec 17, 2008)
Read the full story at http://www.prweb.com/releases/2008/12/prweb1754374.htm
Israel pounds Gaza for second day
GAZA (Reuters) - Israel destroyed Hamas's main Gaza security complex in an air strike on Sunday and prepared for a possible invasion of the territory after killing more than 280 Palestinians in the first 24 hours of a powerful offensive. (Read on Source)
Lehman bankruptcy filing wiped out billions: report
NEW YORK (Reuters) - Lehman Brothers Holdings Inc's emergency bankruptcy filing wiped out as much as $75 billion of potential value for creditors, The Wall Street Journal reported on Monday, citing an analysis by the bank's restructuring advisers. (Read on Source)
Name: SyroBro