Make Money Easy For You

分类目录

文章归档

Searching in CLOB using Oracle Text

Last Updated: 2011/10/04

Introduction

In the present era of Knowledge based computer applications, there is often a need to store a large amount of text based data into the Database. Moreover, the user also needs facility to search this text for specific key-words. There are several ways to provide search functionality.

If the Oracle database is used in the application, then such massive text data can be stored into Oracle database as CLOB (Character Large Object) data type. Oracle 10g supports storing of character data up to 4 GB in CLOB.

Oracle Text provides a powerful text search and text management for Oracle 10g database. Oracle Text indexes the text content for fast & accurate retrieval of information.

Usage

Let me now illustrate how to use Oracle Text for searching in CLOB data into Oracle 10g database.

There is a table in the database which is having a large text content stored as CLOB.

Table : CONTENT_TBL

CONTENT_ID NUMBER(6)

CONTENT_DESC VARCHAR2(100)

TEXT_CONTENT CLOB

Oracle Text requires an index to be created ion the field which is to be searched for. So, create an index named Content_Tbl_Index as :

CREATE INDEX Content_Tbl_Index ON

Content_Tbl (Text_Content) INDEXTYPE IS CTXSYS.CONTEXT;

Now, user can search for all content with multiple combinations of Keywords and operators, for example:

SELECT Content_Desc FROM Content_Tbl

WHERE CONTAINS (Text_Content, ‘%OUT SOURCING%’ OR ‘%SOFTWARE DEVELOPMENT%’ OR ‘%WEB SITE%’ ) >0;

This query will return all the rows from the database with the column TEXT_CONTENT containing any of the key words ‘Out Sourcing’, ‘Software Development’, ‘Web Site’.

Concerns

While using the Oracle Text search features, I have observed that the following points are to be kept in mind for getting proper search results:

1. The keyword as well as join operators are to be provided in Upper case.

2. The keyword should be pre-fixed and suffixed by a % sign.

3. Whenever the content is changed or updated, the index does not updated automatically. It follows the ing line which needs to be executed after each “Save” process to update the index.

CTX_DDL.SYNC_INDEX (index name)

Your Wedding Day Music – The Soundtrack for Your Perfect Day

Last Updated: 2011/10/04

So you are planning your Wedding Day and its going to be perfect. You have the flowers, cake, invitations, your dress, his outfit, and favors sorted. Your own fair hand has written your Wedding Vows, funny or otherwise, so you are ready to get underway, but what about your Wedding Music?

Your Wedding Music will be the audio background for the entire day so it’s important to have Wedding Music that you really like. There’s the prelude to think about first. What kind of Wedding Music should be playing for your guests as they assemble in the venue for the ceremony? Many people will choose a restful, classical piece for this part of their wedding such as,

Adagio from Santana in E-flat by Mozart,

Air from Water Music by Handel or

Air on the G-String by Handel.

These are gentle pieces that provide a soothing backdrop and excellent start to you Wedding Music choices.

The next choice to make is what Wedding Music do I walk down the aisle to? Goodness this is a big choice. These days you do not have to have the traditional Wedding March by either Wagner or Mendelssohn although these are still very popular. Listen to Harry Conick, JR singing Ave Maria, Canon in D by Pachelbel or Arioso by Bach before deciding on your entrance Wedding Music!

When the moment comes that bride and groom are joined together as one the Wedding Music can be “their song”, something more uplifting like the Beatles and Let It Be or something spiritual and heavenly like, my personal favorite, From This Moment by Shania Twain and Bryan White.

During every ceremony there are pauses and its nice to fill those pauses with Wedding Music especially chosen. Sometimes a soloist will fit the bill and Ave Maria or the Lords Prayer can do justice to the moment. Maybe you would like just music and Spring from Four Seasons by Vivaldi or O Mio Babbino Caro by Piccini are both excellent choices.

Now as husband and wife you are about to step out into the world and what is the right Wedding Music for you to do that to? Still very popular is the Wedding March by Mendelssohn but you by no means have to choose that. Ode to Joy by Beethoven or Inseparable by Natalie Cole can express the feeling of that moment.

Just because the ceremony is over and you are actually married don’t think the picking of Wedding Music ends there. Oh no…you still have the reception to deal with!

You have a cake to be cut and smushed into your other half mouth and a popular Wedding Music choice is…Bride Cuts the Cake by Average White Band. How Sweet It Is by James Taylor, I Got You Babe by Sonny and Cher and Love and Marriage by Frank Sinatra are all understandably popular. As a choice of cake cutting Wedding Music I was surprized to discover that the Theme Song from “Jaws” by Ronnie Neuman is also well used!

Right moving along we now need first dance wedding music and again Shania Twain and Bryan White are very popular with From This Moment. Amazed by Lonestar and Breathe by Faith Hill are also in the top ten as is Truly, Madly, Deeply from Savage Garden. This is a song that becomes a cherished memory, so handle with care. My first dance was to Three Times a Lady although in later years my husband will tell you it was The Lady in Red!

First dance as man and wife is over so we can move on to the wedding music for the rest of the evening. Maybe a mix of romantic numbers like Always by Bon Jovi, Every Breath You Take by Police or My Heart Will Go On by Celine Dion and some party style wedding music such as the ever popular YMCA by Village People, We Are Family by Sister Sledge and Celebration by Kool and The Gang. These are bound to get the party started!

We can start to get a little soppy with some Mother/Son and Father/Daughter wedding music choices like Wind Beneath My Wings by Bette Middler or Unforgettable by Nat King Cole. Can You Feel the Love Tonight by Elton John is another music choice I think works well for the occasion.

Now the evening is drawing to a close, bride and groom are about to take to the floor for their last dance so what wedding music is appropriate? My personal thought is something undeniably romantic like I’ve Had The Time Of My Life by Bill Medly and Jennifer Warnes or Wonderful Tonight by David Kersh. Or there’s always Last Dance by Donna Summers or Time of Your Life by Green Day.

That’s is then, you now know how much wedding music you have to decide on. You may find that the DJ or band that you have organized for your reception will have a fabulous selection and you just pick out a particular few pieces of personal wedding music to be played a key moments or you may want to decide on everything. Before making a decision on your wedding music, listen to as wide a variety of music, tunes or songs as you can and whatever you pick may your wedding music be the perfect soundtrack for your perfect day!

Lorna Mclaren has an information and resources website at http://www.a1-ourwedding.com where you can get inspiration to help you organize your Wedding Day!

Embedded in the Ride

Last Updated: 2011/09/14

Since one of the things I love best is riding, I end up thinking a lot about it and about why I do it and why I like it. It seems to be one of those things that mystifies a lot of people.

How many times have you been told how dangerous it is? Bikes are unstable, You don’t have any protection. Drivers can’t see you. If you go down you can die from the road rash even if you don’t break anything. It goes on and on. The endless list of horrors. The stories about somebody who such and so knew who spent 6 months in traction, got turned into a vegetable, whatever.

Well, it’s all true. There are reasons why insuring your ride is expensive. Mostly having to do with medical costs and theft, I expect. But this is one of those odd ways of viewing the world that people use to put down the things they aren’t interested in doing.

One certainty is that nobody’s getting out of here alive. And it can happen at any moment in any kind of situation from nearly any activity. Life is not safe. Living isn’t about being safe. You going to give up eating because something could get stuck in your throat and kill you?

Still, riding is dangerous, and untrained reckless fools often have a short career – or run through a lot of bikes if they’re very lucky and can afford not to learn how to ride.

Even the best riders can get taken out by a bad combination of events. But so can a driver in a cage or a pedestrian. Things happen. No guarantees.

Unlike a new motorcycle, life is not under warranty. I need to be reminded of that from time to time and to learn, over and over, how to live with uncertainty. Riding brings it home.

Riding a motorcycle has a number of virtues that are sensible and common – you save on gas, you can park almost anywhere with no trouble, they’re relatively inexpensive compared to a car, even the insurance can be less than a car, they are less expensive to maintain and repair. Nice sane virtues, eh?

Let’s just skip the downside and get to the real reasons for riding. It’s dangerous and makes you feel alive. A lot of sports are dangerous and that’s a part of the thrill. Actually feeling your heart beat and the adrenaline rush is kind of addictive. Most parts of our lives are safe, sane, cautious and/or plain flat out boring. It’s hard to feel alive in a cocoon.

But even running an errand can bring you back to life – if you ride. A car is just another cage (car fanatics will disagree, but something with 4 or more wheels just doesn’t do the trick) and while they’re great for carrying a ton of groceries and all the kids, they’re mostly like sofas on wheels. You know, get in your cage, roll up all the windows, turn on the air or heat, jack up the 24 speaker cd system and float away. Get totally insulated from the world around you.

On a bike you are embedded in the world. You know you’re on a machine – and you are on it not wrapped up inside it. You are embedded in the machine, you’re the bike’s intelligence and your whole body is involved in making it all work. This is very different than driving a car (racers excepted, of course). Sure you can ride a motorcycle and be absent which does cause a lot of mishaps, but usually the ride demands that you pay attention, that you stay in the present, in the now of you, bike and road.

Too few things demand that kind of attention and presence. We really should live every second fully present, fully awake, completely there. But we don’t. We spend too many hours disconnected or plugged into a pseudo-reality.

The ride teaches me again to wake up and be there. It embeds me in the real world around me. I sense it, hear it, feel it and flow with it. The very best rides are a spiritual experience that can be impossible to describe or explain to anyone who doesn’t already get it. There’s a meditative quality to riding and a cleansing of the trash that accumulates in our heads. For me these are the real reasons I ride. Riding makes my life (and my head) work better.

Ride to live – live to ride. It’s a lot more than transportation.

Richard (Rick) is a long time biker – even longer than he’s been writing, consulting and training.
You can see some of the results at http://www.A-Harley-Motorcycle.com and the blog at http://www.a-harley-motorcycle.com/blog

Snowmobile Lighting

Last Updated: 2011/09/14

With the high cost of fuel riding a snowmobile idea costs lots of money. For those who live in the sticks, we know that sometimes it is about the only way to get around during the tough winters up in high country. Unfortunately high fuel prices and lack of supply is taking its toll on a back countryman’s budget indeed. We must conserve fuel and one way to do this is to use more efficient lighting bypassing the electrical system.

Fuel prices have seen sharp increases in the last few years in our nation. The bumps on the trails we use can power up the headlights using electromagnetic induction technology to charge a capacitor instead of the headlights working off a battery. Currently there are some nifty micro-flashlights being used which you can buy which use a similar technique and are available thanks to the Everlite Flashlight technology research lab. These smaller flashlights work by shaking them for about thirty seconds and shine for about 6 minutes and they shine quite bright since they use a very bright LED light. Here is a link to this home use flashlight:

http://www.modernoutpost.com/gear/details/ee_shakelight.html

Here is a quick movie you can watch online to see how this technology works.

http://www.modernoutpost.com/gear/movies/ee_forever.MPG

I propose we use the engine rumble to light the dashboard lights, taillight and headlights. Generally you have to wait twenty seconds for the engine’s oil pressure to come up anyway. This does not mean that the headlights would not be hooked up to a battery, only that you would not be asking for any juice, thus the alternator does not have as much drag on the engine and saves fuel consumption. Once the engine comes up to oil pressure the snowmobile can then drive and each bump along the way keeps the lights running. If they get too dim from too smooth of a road, yah, we wish, then the system would revert back to the battery. Perhaps this is a good way to save fuel on your snowmobile? Think on this.

“Lance Winslow” – If you have innovative thoughts and unique perspectives, come think with Lance http://www.WorldThinkTank.net/wttbbs

Make Money Easy For You

Three Simple Steps to Having a Great Day!

Choosing Family Camping Tents

History And Purpose Of Education In The United States

Mother Cow Report Card

Working for the Future