Home » SQL & PL/SQL » SQL & PL/SQL » Instr Query (sql)
Instr Query [message #390553] Sat, 07 March 2009 04:39 Go to next message
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 #390557 is a reply to message #390553] Sat, 07 March 2009 07:05 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check REPLACE, TRANSLATE or REGEXP_REPLACE.

Welcome to the forum.
Re: Instr Query [message #390598 is a reply to message #390553] Sun, 08 March 2009 01:49 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
icon14.gif  Re: Instr Query [message #390663 is a reply to message #390653] Mon, 09 March 2009 04:02 Go to previous message
mzakariya
Messages: 3
Registered: March 2009
Location: Jeddah
Junior Member
appreciate your advice ............... thank you
Previous Topic: optional condition in SQL
Next Topic: clob data
Goto Forum:
  


Current Time: Fri Feb 07 00:05:37 CST 2025