Instr Query [message #390553] |
Sat, 07 March 2009 04:39  |
mzakariya
Messages: 3 Registered: March 2009 Location: Jeddah
|
Junior Member |
|
|
Hi frndz ...... i just joined the institute in order to study oracle...... i m a beginnner in this field and need your expertise to become my self an expert adminstrator
i m stuck in nested functions.
the task is as follow
statement is "hahahahaha" and i have to jst pick all 'a' from it kindly let me know about it ........
appreciate your support ........
thank you and best regards
Zaki
|
|
|
|
Re: Instr Query [message #390598 is a reply to message #390553] |
Sun, 08 March 2009 01:49   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
mzakariya wrote on Sat, 07 March 2009 11:39 | Hi frndz ...... i just joined the institute in order to study oracle...... i m a beginnner in this field and need your expertise to become my self an expert adminstrator
i m stuck in nested functions.
the task is as follow
statement is "hahahahaha" and i have to jst pick all 'a' from it kindly let me know about it ........
appreciate your support ........
thank you and best regards
Zaki
|
The fact that you are a beginner is irrelevant to what you are asking. If I understand you correctly, you are following some kind of education in Oracle. For this, you got the assignment for which you seek help here.
Normally in education, assignments are meant to bring into practice what you just learned.
So, this leads me to believe that you did not really pay attention during class, or did not read the required parts of the textbook, but skipped right to the assignments.
This way, you will never ever learn anything important about Oracle.
|
|
|
Re: Instr Query [message #390652 is a reply to message #390598] |
Mon, 09 March 2009 03:10   |
mzakariya
Messages: 3 Registered: March 2009 Location: Jeddah
|
Junior Member |
|
|
thank you ebrian, i have done it by my own way anyhow thank you loots
frank, actually this is not a thing that i m not paying attention, my mean to ask that; lets take an example of this query, my frnd ebrian said to use replace and translate function and i have done it by just to use instr function only. Every person has its own logic and i want to learn maximum logic.
you are cent percent right that we have to do our assignments by ourself
i hope u get my perspective
|
|
|
Re: Instr Query [message #390653 is a reply to message #390652] |
Mon, 09 March 2009 03:14   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
In your initial post you clearly stated that you were stuck, not that you were looking for alternatives for something you already know.
First try to get the job(/assignment) done with stuff you learned. Don't try to get ahead or use more if you don't master that.
This is meant as a good advice. SQL is hard enough to learn in the beginning as it is, so try to stick with what you have to do. Plenty of time to look around once you master the basics.
|
|
|
|