Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2011
    Location
    Hyderabad
    Posts
    18

    Unanswered: subprogram(vital-india)

    Design A Sub Program Which Can Generate A Primary Key Value Whenever The Table Name And Column Name Are Passed As Parameters?

    Design A Sub Program Which Can Check Spaces And Report An Error?
    Last edited by vithalreddy; 10-20-11 at 05:37.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    I have no idea what you are talking about.
    You need to provide a lot more details

    And what does DASP mean?

  3. #3
    Join Date
    Oct 2011
    Posts
    9
    Can Generate A Primary Key Value... do you mean auto increment ?
    you need to create sequence and trigger

    Which Can Check Spaces And Report An Error... is this space or null ?
    for null you can use nvl function to check whether the field empty or not empty

  4. #4
    Join Date
    Sep 2011
    Location
    Hyderabad
    Posts
    18

    vithal

    DASP =design a sub program....how to achieve my requirement through the sub programs

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Oh! How come your didn't ask a question as
    DASP WCG APKV WTTN ACN APAP
    Anyway: the first one might be solved as @dendybsulistyo suggested, while the second one requires further explanation. What "spaces"?

  6. #6
    Join Date
    Sep 2011
    Location
    Hyderabad
    Posts
    18

    subprograms

    DASP Which Can Generate A Primary Key Value Whenever The Table Name And Column Name Are Passed As Parameters?
    DASP Which Can Check Spaces And Report An Error?
    DASP Which Can Check SPL Characters And Report An Error?
    DASP Which Can Check Numbers And Report An Error?
    DASP Which Can Check Symbol '@' To Be Part of Email Only Once?
    DASP Which Can Check Symbol '.' After '@' Only Once?
    DASP Which Can Check No of Characters of The Domain Extension To Be Absolutely 2 or 3 Characters? If the Domain Extension is 2 Characters Then It Can Accept One More '.'?
    DASP Which Can Check That Email Is Only In Upper Case And Convert Into Lower Case And Insert or Update But Give Acknowledgement To The End User About Conversion?
    DASP Which Can Check That Email Is Only In Upper Case And Convert Into Upper Case And Insert or Update But Give Acknowledgement To The End User About Conversion?
    "WASP Which Can Check That
    1) First_Name Not Equal to Middle_Name And Last_Name?
    2) Middle_Name Not Equal to First_Name And Last_Name?
    3) Last_Name Not Equal to First_Name And Last_Name?"
    WASP To Check DOB Is Always Lessthan SYSDATE?
    WASP Which Never Allows PK Values Not To Get Updated?
    WASP Which Allows Change of First_Name, Middle_Name And Last_Name To Be Updated On Any Table Only When The Update Is Done At The Admin User Level Only?
    WASP Which Allows Change of DOB To Be Updated On Any Table Only When The Update Is Done At The Admin User Level Only?
    DASP Which Can Take The Audit of No of Records And No of Effected Tables Whenever A Record is Deleted OR Updated In The Master Table?
    DASP Which Can Take The Audit of No of Tables That Are Expected With Relational Data When One Record is Inserted Into The Master Table?

  7. #7
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Ummm ... you are missing ASAP.

  8. #8
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    We do NOT do homework. If you try and it doesn't work we can help, but we will not do it for you.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •