I do believe you..... On 11/13/10, Michael Moore <[email protected]> wrote: > Is this a school homework assignment? > > On Sat, Nov 13, 2010 at 9:31 AM, deepanshu <[email protected]> wrote: > >> Column Name Data Type Possible Values >> USERID VARCHAR2 (8) AVINAS12 >> USER NAME VARCHAR2 (100) AVINASH REDDY >> PASSWORD VARCHAR2 (10) Avin#123 >> MAKERID VARCHAR2 (8) Ramsh12# >> MAKERDATE DATE 1/2/2009 >> 1. Write a select statement, which can identify the space between the >> letters of >> the USER ID column. Eg. RAM GOPAL >> 2. Write a select statement, which can identify the special character >> used in the >> password column. For e.g., #,@ etc. >> 3. Write a select statement, which can identify that first letter of >> the USER ID >> column starts with a character (alphabet) and does not have a numeric >> or >> special character. >> 4. Write a select statement based on which we can identify the USERID >> column >> whose length is greater than seven characters. >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Oracle PL/SQL" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/Oracle-PLSQL?hl=en > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en
-- Regards, Jignesh Makwana, +919892500936 -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
