Cinderella is just fairy tales, good match the hap
by uggsboots28 on Mar.04, 2010, under Uncategorized
First love is already a very old thing, it was a decade ago, I read the university, the ivory tower of carefree era. Hymer is our Chairman of the Department of Student Union, but also basketball team captain, a sun handsome boy. At that time, Hammer was a lot of girls in mind, “Prince Charming.” Of course, those girls inside, but also including me. I remember that time in order to attract his attention, I take every opportunity to inquire of his love, know that he likes the blue, my clothes almost entirely blue.
Admittedly, I am also beautiful, excellent, I was the school radio station announcer, is on campus, one of ten singers,ugg boots, plus his own motives, Hymer noted that I am also a very natural thing. Our first “date” is that he proposed, and he gave me a note that read: “Tomorrow, my basketball game, you will time then it?”
That night, I could not sleep with excitement. The next day in court, I did not like the old days as yelling, looking for the Hammer refueling girls proudly I can not help thinking: Well, he had me!
Hymer family
conditions are good, his father was their local cadres, Mom to do business at home can be both costly and have the right. And I, it is an average family of children, and hemmed together, I believe that the existence of the Cinderella story is in reality being, and I love people who gave me a pair of well-being of the Slipper.
time very happy, campus love simple, beautiful, and I like the feeling hemmed bright crystal clear, beautiful and flawless.
graduation working on this issue, Hymer’s attitude is very clear, he is sure to go home. My home in Jinan, Mom and Dad did not want me to leave, but to love, I still go after graduation to follow them hemmed there.
in before I see my parents very disturbed Hymer, worried that they despise me, it turned out, my hunch is correct. They want to find all respects mirrored in Alzheimer’s people, not me nothing girl.
At that time, still has the power of love, to me, Hammer and his parents had a falling out, he moved out from home, it did not go to his father arrange the unit to work. We rented a small house and began a difficult but happy life.
I hemmed Though all found jobs, income is not high, in addition to the rent, just enough to live. The beginning of our future is full of hope, can be life is not because we insist on the blooming smiles.
Later, Hammer began to familiar people unwilling to face, he began to dislike himself and hold anything against me. I know that he wanted to succeed, want to prove to his parents read it, but we are too young, that cities are not suitable for our development opportunities.
Still later, we began to quarrel, hemmed often drunk, life, hope is like to be done in charcoal burning and fire and getting smaller and smaller.
Later I know that hemmed often without the knowledge of my home, he began to slowly come to accept my parents paved road. Weekend overtime, he said, later I learned that his parents introduced him to see the girls … … I told him to say that he was upset that he has been working hard, I have to give him time.
I do not know how to do, in that city, I only have hemmed a family, in addition to believe him, I have no other way out. However, the time I gave him, he gave me the result is not Elixir of Love, but Laoyanfenfei.
Hymer said that if he and I together, he no longer cared for his parents that he would be, we will be over a lifetime prosaic life. If you and I may be separated from his parents will take him to the sun is a glorious future road.
heartache, do not blame him, a young boy, his choice can not be said is wrong.
So, I took back covered with scars, Jinan. Later, with the help of relatives, I went to this unit to go to work now. Nice work, income can, of course, and hemmed the future compared to the days of my worth mentioning, but I am concerned, is sufficient.
I want just a trivial contend fireworks day.
there was a period of decadence, I do not believe that anyone, much less believe that the feelings. My parents live together, work every day from work, those who introduced me to the object to give enthusiasts are invariably no reply.
world is very small, vast sea of so many people, it just turns to me and hemmed meet; the world’s great love of two people who, after breaking up but Zaimo message. How did not miss him, but that felt very empty, and sometimes air was pain.
Last spring, I met Li Mu, he was a civil servant, you are very busy every day, but do not see The Apprentice opportunities, his family and I are similar to the people living in sub-Mom and Dad are honest.
then gradually, and he became friends through a period of time, he expressed to me love. I feel like I knew there come a day, I naturally gave it away, and, begin to imagine the two men later in life, and even thought of, in the future birth to a child would be a little more like him, or like me a little more.
Li Mu honest as to be almost a bit stiff, he would not say anything sweet, nor the General Assembly and considerate person, but I know he loves me, cherish me, and will keep with me a lifetime. We may not be how much affection, but we are interdependent and indivisible right-hand man.
Perhaps this is the ordinary people’s lives, Slipper’s story is nothing but a beautiful fairy tale.
However, just me and Li Mu Tanhunlunjia time, Hammer appeared. I do not know where he had to get my phone number, give me a call, to cry. I have never seen him cry, he has always been confident and proud. “Lili, experienced a lot of people and things learned, or did you best, and I am tired of life right now, if you nod, I immediately Ben you are away.” Having said that numerous “Sorry\Mo told me so.
I do not know what to say, a kind of Manasarovar feeling.
I still plan a wedding, and Li Mu, will not answer the phone hemmed,uggs, not back to his information. Later, he came to Jinan approached me, saying that, and Li Mu competition, as long as I did not get married, he had the opportunity one day. I feel funny, is this what set? But again some heartache, the wounds still.
sometimes think of and hemmed with time, would the short-term well-being I would like to make long, long time. However, I have not thought of his compound, even though he may really understand love. So, I am often told in slightly pained yourself: time will dilute everything, Slipper had passed, I was princess ugg boots … …相关的主题文章:
Hello poison
by uggsboots28 on Mar.04, 2010, under Uncategorized
uncle,ugg, I feel good, dedicated men and drug toxicity world-wide women!
You say you can not do without
shamelessly before you say that I am seeking only their own selfish love
waves with the crazy wind and rain came
I swung right and left almost Overturn planted on
Fortunately, I still have a little skill In
you can not touch the crucial point of my fatal
Maoshang you have to deserve
surmise surmise Zirendaomei you really look bad heart drugs
Hello,ugg, Hello, Hello, toxic poisoning hum Ming
you becomes clearer and outrageous
I heard the more puzzled
drugs hello hello hello toxic poison Wuwu Wu
killed refused to concede defeat
also pretend that you do not care
Hello, good drugs drugs drugs Wu Wuwu
hello you gave me make it clear I want Kendiao
your poison bone
Hello Hello Hello toxic drugs every time Wu Wuwu
I will revenge be taken advantage of carefully相关的主题文章:
The ten men a woman can not be separated
by uggsboots28 on Mar.04, 2010, under Uncategorized
He can not do without you to be a woman, to be a man so disoriented woman, women know what they want and they will know in a timely manner expressing her needs, so the result is often that a woman eventually got his wish to please a man heart.
1, maintain an independent
whether she is one of the company’s CEO, or a restaurant hostess, were insignificant. She has the most genuine life. She has her own honor,uggs, and she did not make it go and beg for a living.
2, is not entangled each other
stars, the moon and the sun have their own trajectory, and similarly, she will not be around him round and round. When her constellation metaphor shows him moving away from her Mercury, Venus, she no longer dating him. He or she would not watch him struggle. He is not the center of the universe. Case in point: his girlfriend let him struggle “psychological tilt”
3, mysterious
integrity and frank is a difference. She is honest, but it does not mean that she needs to confess everything. She also does not clearly and simply put their cards on the table. She knew the past is just as rude – all too familiar lack of respect for the seeds will be planted, and even planted the seeds of tired.
4, she let him hard to get impatient
she does not need to see him every night, nor in his lengthy telephone message left on. Her name is not his secretary arranged a week plan first. In fact, men were also eager to love. The feelings of desire, is also very beautiful
5, would not let him see his own Langbei Xiang
she was not thinking of chaos as far as possible when the exchange with him, but also try to avoid upset when communicating with him. And so on his mind when sober, and then expressed in a concise manner.
6, independently arrange their own time
she was deliberately slow down, especially when he can not wait the time. The rhythm of her own act, rather than each other’s footsteps, the purpose is to prevent by his mercy.
7, she maintained her sense of humor
humor can feel the other side of her independent thinking. However, she would not laugh at him, nor will he does not respect.
8, she was very confident
when he compliment her, she would say, “Thank you.” She was not going to stop him praise. She will not ask his former girlfriend’s appearance, it will not work with jealousy over other women.
9, her passion for certain things more than he needs
when he felt that she is not for him, “Once you have, do not want nothing,” when he felt that she was full of charm. Because there are things to be busy, so she would not see him and angrily ran. In her mind he had no privileges, not made “a fixed parking spaces,” there is no “exclusive access.” He got, but next to the “carpark” and a “temporary parking” only.
10, she cherished her own body
to focus on their appearance and health. A man how to maintain his / her looks, can reflect the extent of their self-esteem. If he told her that he did not like red lipstick, and this lipstick letting her feel good, she will still use.
a woman to be a personality,ugg, and let a man with chronic poisoning, drug addiction is provoked when the men came here, you will not be smart and personalized for their own pride in it, seize the men is not just rely on an informed MANAGEMENT, but also have its own personality, such a woman, is the most attractive.相关的主题文章:
Internet Love
by uggsboots28 on Mar.04, 2010, under Uncategorized
chat, meet, drink, one-night stand is a “network of love,” a four-step song. So, why should they go to bed to meet anyone do? Finishing a number of points when you finish watching supplementary oh ~
(a) buys them on intuition
Almost all such cases
met handsome guy is a beauty, a see “love” match can still be felt, so, do you love I wish, turn off the lights to go to bed.
(b) the general trend of the drive
all do to meet anyone else’s, why do I not? So, naturally, without more, everything naturally.
(3)
surface is also due to sensibilities met, drank wine,ugg, and handsome guy of the money spent, wondering if that was not a go? Moreover, and handsome guy well prepared, wanted to run? Not so easy, hey, who told his so greedy, well, sleep
(d) emotional foundation
the so-called emotional foundation, it is the two of them have some contacts in the network and understanding, feeling each other quite humorous, pretty funny, two quite able to talk to, so to meet, online what kind of jokes are opened before, and net down point of the real work?
(5) physiological needs
such behavior is not a girl, a woman should do. Older, may have had marriage history, loneliness intolerable, so generously,ugg boots, to enable small handsome guy when a return to cheap gigolos, as the authentic one-night stand.
(6) given to the
such cases to see someone belonging to middle of the night, and fought over, paid handsome guy, since come, can see the left side carry a fail, handsome guy driving charges will be as generous, well, washed the sleep !相关的主题文章:
Reprinted Women’s health food, Comrade
by uggsboots28 on Mar.04, 2010, under Uncategorized
As the saying goes, medicine make up less Sibu. Nutrition experts point out that attention to nutrition in their daily diet with a reasonable and properly adds the following foods can help fight against the women.
1, anemia, high-iron foods to add additional high-speed rail
food
because of the cyclical blood loss and reproductive and other reasons, some women over there You Sancheng mild iron deficiency anemia.
anemia may easily lead to a long-term decline in ovarian function,uggs, the impact on women’s health.
can be described as a woman’s life blood nourishing the “homework.” Animal liver, lean meat, spinach and other foods is not only a high iron content, and easy to absorb. Medical experts remind women during menstruation, when tea and coffee to try to drink less thick, so as to avoid tannins which inhibit iron absorption.
Keywords: 2, menstrual discomfort drink hot milk,ugg, add honey drink hot milk, add honey
<br "Lower abdominal pain, Yaoxisuanruan, physical fatigue, sleep disturbances and emotional irritability and other symptoms, women often experience physical discomfort during menstruation. Obstetrics and Gynecology expert recently found that women in the menstrual period before going to sleep every night to drink a cup of hot milk and honey, reduce or eliminate menstrual discomfort.
because of potassium in milk can soothe emotions, and to relieve abdominal pain, prevent infection, reduce the role through the blood; honey contained in the central nervous system of magnesium can be calm, to help eliminate the women in the menstrual tension, relieve psychological stress .
3, dysmenorrhea
eat bananas eat bananas
banana is rich in vitamin B6, vitamin B6 has a role in nerve stability, not only can stabilize the anxiety of women during menstruation, but also help improve sleep, relieve abdominal pain.
migraine magnesium eat food to eat magnesium food
migraine headaches occur in the child-bearing age women, particularly those engaged in intellectual work,女性. The study found that some patients with migraine headache low blood magnesium levels, if a diet rich in magnesium intake note that foods such as millet, buckwheat noodles, beans, bananas, nuts and seafood can reduce the onset of migraine .
depression
eat fish
eat fish
hormonal changes due to the impact of endocrine women than men, more likely to have depression.
study found that frequent eating salmon, sardines and other ω-3 fatty acids rich in fish, can help relieve depression in women, or reduce the incidence of depression. Because these fish rich in ω-3 fatty acids have antidepressant effect.
estrogen decline in intake of soy products
intake of soy products
estrogen
important to female body sex hormone, when it is in the blood below normal levels, makes a woman’s reproductive function and sexual function are affected, but also to enable the heart to lose the protection.
isoflavones contained in soy is an estrogen substance, the body can compensate for lack of estrogen.
drank 500 ml of milk or eat more than 100 grams of soy products such as tofu, yuba and so on, can effectively regulate endocrine function, to promote return to normal levels of estrogen.
mycotic vaginitis
eat garlic, eat garlic class
class
regular consumption of garlic class Women are not prone to fungal vaginitis.
because the garlic is rich in allicin, allicin and other substances, which are sulfur-containing natural bactericidal substance has a strong bactericidal effect, inhibit Candida albicans in the vagina of excessive growth and reproduction.
breast disease
eat whole grains foods and seaweed
eat whole grains foods and seaweed
One study found that women of childbearing age more than in the diet intake of whole grain foods, make estrogen in the blood circulation to maintain an appropriate level to avoid the high levels of estrogen caused a lot of breast disease.
kelp contains a lot of iodine, can stimulate the pituitary secretion of luteinizing hormone to promote ovarian follicle luteinization, reducing the body’s estrogen level. Therefore, regular consumption of kelp contribute to the prevention and treatment of breast hyperplasia.
Gynecologic Oncology
eat more fruits and vegetables Erythroderma erythroderma
eat fruits and vegetables
red apple, red the red peppers and other vegetables and fruits contain a natural plant chemical composition, can effectively inhibit the growth of a number of gynecological tumor cells, while reducing their estrogen responsiveness, and thus has a role in the prevention of gynecological cancer.
In addition, onion, Muscatel grapes and other fruits and vegetables also have a similar effect.
ovarian cancer
eat high calcium foods high calcium foods
eat
lot of investigation and found that calcium intake enough calcium intake of less than women who reduced the probability of suffering from ovarian cancer 54%. Because of adequate calcium helps control the growth and spread of cancer cells.
Therefore, women should pay attention to appropriate complementary foods high calcium, especially in postmenopausal women and older women, daily calcium intake should reach 1000 mg. This requires a day and stick to milk or dairy products, eat soy products, small dried small shrimps, fish, seaweed, and shepherd’s purse and other food.
——————————————
The article was from: Veteran: Women’s health food Comrade
reading room with the QQ-mail subscription
What is the reading room for veterans?
相关的主题文章:
Poppy flower
by uggsboots28 on Mar.02, 2010, under Uncategorized
poppy flower is very beautiful,
but its fruit?? a drug,
one-night stand is also true,nike air max,
? and her? start? romantic,uggs,
they be? people? foot one? desire,Louis Vuitton shoes,
but? later,
its? possession of toxicity is likely?? regret life
..相关的主题文章:
Let me grabbing a computer expert
by uggsboots28 on Mar.02, 2010, under Uncategorized
楼主: computer illiterate, said:
long time ago, and that was when I used the win98 times I had a system crash, because I am a computer idiot, my friend introduced me to an expert to help me repair the computer.
He looked at the computer and asked if I have 98 of the disk, I said no.
He thought for a moment and told me to fixed-line telephone showed him, I would like to repair the computer what to call, but the people are masters, I do not it say anything, put the phone down to pull him.
he empty a telephone line connected to a jack inside the computer, and then into the dos, and then started on the phone non-stop by pressing keys, his keys very quickly, but only Press 0,1 two keys, I do not understand that what’s the use, but do not dare to ask, having read more than half an hour, he kept the press these two keys, I gradually came to some of the storm, I asked him how long this thing wants to, he said to a few hours, I poured him a cup of tea on a person to sleep next door.
woke up when one has been to see a more than 4 hours, I went into the next door and saw that he was 98 inside debugging, after a while child, he said, you try, I boarded a chair used what, really good, when I also do not understand computers, thanked the people left.
Then I slowly got to know the computer, and finally understood that when the original master who is a 98 machine language compiled system, then I asked my friend who master the whereabouts of my friend said, a few years ago to the United States, the heard from since ….
【2 floor】 computer idiot wrote:
long time ago, and that was when I used the winXP one occasion I have a system crash, because the I am a computer such thing, my friend introduced me to an expert to help me repair the computer.
He looked at the computer and asked if I have XP installation disk, I said no.
He thought for a moment and ask me to put a blank DVD discs, and gave him a needle, I would like to repair the computer what you want to burn discs and needles, but the people are masters, I do not it say anything , put DVD discs, get one to give him.
he poke the needle facing the recording disc, his poke very quickly, but only poke deep or shallow, I do not understand that what’s the use, but do not dare to ask, having read more than half an hour , he kept Poking a DVD recording of the plate, I gradually came to some of the storm, I asked him how long this thing wants to,ugg boots, he said to a few hours, I poured him a cup of tea, on a person to sleep next door.
woke up when one has passed to see more than 4 hours, I went into the next door and saw that he was inside Xp debugging, but also installed on the office, photoshop,christian louboutin, Thunder, World of Warcraft software such as … … After a child, he said, you try, I boarded a chair with a bit, really good, when I also do not understand computers, thanked the people left.
Then I slowly got to know the computer, and finally to understand, the original master who is the needle was engraved a single-sided dual-layer DVD, inscribed on the inside of the Xp, office, photoshop, World of Warcraft Setup, then I asked my friend who master the whereabouts of my friend said, after a few years ago to the United States, heard from since ….
【3 floor】 computer big idiot wrote:
long time ago, and that was when I use the winXP one occasion I did not accidentally drive D grid, and because I am a computer such thing, my friend introduced me to an expert to help me recover data.
He looked at the computer and asked if I had not backed up Ghost, I said no.
He thought for a moment and told me to put a magnet showed him, and asked me what the D drive, there are things I would like to repair the computer what to magnets, but the people are masters, I do not it say anything on the the magnet to him, and also told him that I D tray full of Naruto animation.
he removed the hard drive, using magnets in the above circle, his circle very quickly, but only met or not met,air max shoes, I do not understand that what’s the use, but do not dare to ask , read more than half an hour, he was kept in the hard disk painted circle, I gradually came to some of the storm, I asked him how long this thing wants to, he said to a few hours, I poured him a cup of tea, a person to the next bed.
woke up when one has been to see a more than 4 hours, I went into the next door and saw that he was inside the D drive to debug, which are all animated Naruto, after a while child, he said, You try, I get on a chair with a bit, really good, when I also do not understand computers, thanked the people left.
Then I slowly got to know the computer, and finally understood who was the original master is used magnets to write data directly on the hard drive that, with astonishing memory will be written into the Naruto animated all hard drives, I later asked my friend who master the whereabouts of my friend said, went to England, after a few years ago, been heard from since ….相关的主题文章:
_ Tiny meet unexpectedly ..
by uggsboots28 on Mar.02, 2010, under Uncategorized
I would like to start a new life? beam that’s the end of the past.
a matter of fact that part of the past may be long over. but I was too stubborn always let it live in the deepest bottom of my heart for several years. you and I always have more and more do not understand. I do not know it was not the culprit. maybe. one another? from? pass is the real reason you and I of ? very long time are? have to sit down? be properly talk
?? each other’s heart?
you have for me is still unknown.
I have thought about. ” br> But you? not? me?? was probably only one or two opportunities. I have no grasp.?? do not know you really do not understand you
asked one? person guess you? heart in thinking about
its? is a very? endure something
; ; ; ; know?
; ; ;? is yours?,? in you? not?
? is my?,? in my paid no attention to
; ; ; I? watched? health.
you will also have a regret like me?
I do not know? to go to your left, what?
For me. it could be more beautiful, only pity. . . .
really really miss it when the beginning of the most open. though when everything seemed so childish. are too many good memories. Today want to come. It all seems to be a long long time ago indeed. and now. people into all, this last may be the non-playback
time really be that we really can see the kind of simple summer I am not afraid but would feel regret, however, forgotten the face of the feelings between people we had on the inability to separate
, after so long, ; you have no further thought about me, this is I have always wanted to ask, but never asked exports, perhaps love slip through between the passage of time. In trying to flaunt its mouth, tears in the surrender.
? you go? me? through their place, do you think of me,cheap gucci shoes, I did think of me? leave with? place is so small , as little as you can? zero in? in front of the Secretary, do you think will be a sudden I have? Do you?? many times I do not like?, and things?? sue? I, do not you? night sleep,manolo blahnik, you will would not want to, now I have to sleep, I really do not know to see you?? that hand? me?-yong? with you wearing one? I am very nervous at what I do not know this?. Mi. Thought I caught harsh.
I said. ??? Why.
If the habit, once into a natural, then forgetting the past it really hurts
a lot? designate, I would like to?? find out whether I was How? one? person.
; ; ; ; harsh yes? tube Ru Ho, I know I?? yes? people like?’s.
; ; ; for? me? care about their own pay, too much notice of? people vision
;?? my own all? too? Heart ? What???? get me so?. ? What is it?
heart, and sometimes very full, and sometimes very empty. A lot of feelings, all because of wishful thinking, and finally even he does not become friends.
There are some things you can not expect, and perhaps the other side is not Yi, you may be friends, but not as good as the previous good.
or? I?? you, I?? than? in? heart, pity me? not
or? you still hard-hearted? me, and I?? than? in? heart, unfortunately I can not hope, I also believe you do not?
knows??
you and me not comfortable but I insisted?? do
? called wayward
me? of
really do not know. but also with multiple long time to forget you. to have, and I gradually lost once people gradually left when we love, only I miss how to say, we will be very sad how to do, we will be very sad
we recently? me? it? The more? more??
more? more selfish
more? more? ?
more? more spent
Yes
I invited?
? is the last paragraph?? him? really is the last it does not mean let? result? I know that I?? really need?? need?? needs? heart Every day I need to know? under?? you have that information, but you can not go back?? I know you have received it have been?? enough of even if I’ll record? more? people Or you record? are out? She <br " ; me????
do not know what the reasons are
Recently, I have a man quietly? listen to songs, enjoying no one else in the world. ??? Follow the beat,ugg, the? Good? Once again? Yi? Times, and then … … the past before, after, I continue strong? As indifferent. ?? A person to travel
相关的主题文章:
Colombian beauty even your child!
by uggsboots28 on Mar.02, 2010, under Uncategorized
~ Is quasi-oh ~Quick play the following?? ~ even be able to? out of you? sub-Oh ~ you HAPPY about oh ~ ~ ~
相关的主题文章:
Oracle Lessons Learned
by uggsboots28 on Mar.02, 2010, under Uncategorized
1, a 2-to-many table, just take a record of writing multi-
example: USER table fields USER_ID; USER_LOG table fields LOG_ID, USER_ID, LOG_CONTENT, LOG_TIME, seek out a query ” br> USER_LOG sheet date a record.
analysis: a general or inner join with left join, then check the right table will remove all records:
select A. USER_NAME, B. LOG_CONTENT
from USER A
inner (left) join USER_LOG B on A. USER_ID = B. USER_ID
where …
to see my colleagues using max () method to USER_LOG by USER_ID group can be one-way relationship between the and then associated with the collection from this inquiry, but this can not be some other fields:
select A. USER_NAME, B. LOG_TIME
from USER A
inner (left) join (select max (LOG_TIME), USER_ID from USER_LOG group by USER_ID) B on A. USER_ID = B. USER_ID
where …
According to this thinking, the use of keywords over (partition by … can be achieved the ultimate goal:
select A. USER_NAME, B. LOG_TIME
from USER A
inner (left) join (
select LOG_ID, USER_ID, LOG_CONTENT from (
select LOG_ID, USER_ID , LOG_CONTENT, row_number () over (partition by USER_ID order by LOG_TIME desc) t from USER_LOG
) where t = 1) B on A. USER_ID = B. USER_ID
where …
partition is a partition of the meaning of the performance of the multi-district and then on-demand by USER_ID sort.
single out select LOG_ID, USER_ID, LOG_TIME, LOG_CONTENT, row_number () over (partition by USER_ID order by LOG_TIME desc line running results similar to the following:
LOG_ID USER_ID LOG_CONTENT T
———- ———- ————– —— ———-
3 ; 1 log3 1
2 1 log2 ; ; 2
1 1 log1 3
5 2 log5 ; 1
; 4 2 log4 2
6 3 log6 ; 1
this record Zaiqu-one relationship between T = 1 set.
<br "2, multi-field, aggregate
a many to many table fields required by the A group, the A field is the same B-field is displayed in a line together.
For example: CITY in the table are PROVINCE_ID, and CITY_ID, fields:
select * from CITY order by PROVINCE_ID;
PROVINCE_ID CITY_ID
—— —- ———-
1 ; 1
1 2
1 3
; 2 4
2 ; 5
3 ,cheap nhl jerseys; 6
seeking SQL displays the following results:
PROVINCE_ID CITY_ID_ALL
———- ———-
1 1 , 2,3
2 4,5
3 6
look seems to be similar to the sum (), as the results of the GROUP together with string, but Oracle does not provide such a function, so one idea to customize a function like this function, this time being put aside, first look at a use of a wide range of solutions.
first look at sys_connect_by_path (column, char) function, known as the “turn out OK,” is a special tree-like structure functions, can be a tree structure of the result set is displayed in one column, usually when reading the directory tree to use than more.
The first parameter is the column name, is to concatenate the column, the second parameter is the separator character. This function wants to START WITH and CONNECT BY Keywords used in combination:
START WITH ‘root’
CONNECT BY PRIOR ‘child’ = ‘Father’;
, but this title is not a tree, “but also to create conditions on the unconditional “In order to achieve the purpose, give it creates a tree as the root provinces, cities lined up according to ID one after another tree, the tree structure needs three conditions, root, ID and parent ID, you can use the row_number (),lacoste shoes, respectively get 2 ID:
select PROVINCE_ID, CITY_ID,
row_number () over (order by CITY_ID) RN,
row_number () over (partition by PROVINCE_ID order by CITY_ID) RM
from CITY
PROVINCE_ID CITY_ID RN RM
———- ———- ———- ———-
1 1 1 1
122 2
1 3 3 3
2 ; 4 5 1
2 ; 5 6 2
3 ; 6 7 1
where RM = 1 as the root, the next line is the line of the parent nodes, R = R-1:
select PROVINCE_ID, ltrim (sys_connect_by_path (CITY_ID,’,')) as CITY_ID_ALL
from (
select PROVINCE_ID, CITY_ID ,
row_number () over (order by CITY_ID) RN,
row_number () over (partition by PROVINCE_ID order by CITY_ID) RM
from CITY
)
start with RM = 1
connect by prior RN = RN – 1
results are as follows:
PROVINCE_ID CITY_ID_ALL
———- ———-
; 1 1
; 1 1,2
1 ; 1,2,3
2 ; 1,2,3,4
2 ; 1,2,3,4,5
3 ; 1,2,3,4,5,6
->
2 ; 4
2 ; 4,5
3 4,5,6
->
3 6
This result seems strange, does not want, we can see where in the RM = 1 will begin CITY_ID a string from start to finish, because RN is continuous, it will always be string to the end. Therefore, in order a way to disconnect the RN by PROVINCE_ID group, where the introduction of rank () function, the role for each group is given a grade value, so that you can level on the basis of the value of re-start sort:
row_number () over (order by CITY_ID) RN, replaced by rank () over (order by PROVINCE_ID) + row_number () over (order by CITY_ID) RN,
results:
PROVINCE_ID CITY_ID_ALL
———- ———-
1 ; 1
1 ; 1,2
1 1 , 2,3
2 4
; 2 4,5
; 3 6
so close, and finally a group by to get results:
select PROVINCE_ID, ltrim (max (sys_connect_by_path (CITY_ID,ugg,’,'))) as CITY_ID_ALL
from (
select PROVINCE_ID, CITY_ID,
rank () over (order by PROVINCE_ID) + row_number () over (order by CITY_ID) RN,
row_number () over (partition by PROVINCE_ID order by CITY_ID) RM
from CITY
)
start with RM = 1
connect by prior RN = RN – 1
group by PROVINCE_ID
The following is using a custom aggregate function method:
assume that we can use select PROVINCE_ID, strcat (CITY_ID) CITY_ID_ALL from CITY group by PROVINCE_ID achieve the purpose of this statement, strcat this function is defined to do, and its role is to max (), avg () as the aggregation function.
first define TYPE:
CREATE OR REPLACE TYPE strcat_type AS OBJECT (
cat_string varchar2 (4000),
static function ODCIAggregateInitialize (cs_ctx In Out strcat_type) return number,
; member function ODCIAggregateIterate (self In Out strcat_type, value in varchar2) return number,
member function ODCIAggregateMerge (self In Out strcat_type, ctx2 In Out strcat_type) return number,
member function ODCIAggregateTerminate (self In Out strcat_type, returnValue Out varchar2, flags in number) return number
)
TYPE_BODY:
CREATE OR REPLACE TYPE BODY strcat_type is
static function ODCIAggregateInitialize (cs_ctx In Out strcat_type) return number is
begin
sctx: = strcat_type (0);
return ODCIConst.Success;
end;
member function ODCIAggregateIterate (self In Out strcat_type, value in varchar2) return number is
begin
; self.cat_string: = self.cat_string | | ‘,’ | | value;
return ODCIConst.Success;
end;
member function ODCIAggregateMerge (self In Out strcat_type, ctx2 In Out strcat_type) return number is
begin
self.num: = self.num;
return ODCIconst . Success;
end;
member function ODCIAggregateTerminate (self In Out strcat_type, returnValue Out varchar2, flags in number) return num is
begin
returnValue: = self.num;
return ODCIConst.Success;
end;
end;
function definition:
CREATE OR REPLACE FUNCTION strcat (input varchar2 ) RETURN varchar2 PARALLEL_ENABLE AGGREGATE USING strcat_type;相关的主题文章:
Looking for something?
Use the form below to search the site:
Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!
Visit our friends!
A few highly recommended friends...
Archives
All entries, chronologically...
