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
