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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
