1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Literal character strings

Discussion in 'SQL PL/SQL' started by expora, Oct 24, 2011.

  1. expora

    expora Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    80
    A literal is character, expression, or number placed in the select list between column names. You enclose character literal values in single quotation marks. You don’t need to enclose number literals in quotation marks. Literal is a value that appears once for every row of data.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Nice copy and paste from the posted website. Can you explain that in your own words?
     
  3. expora

    expora Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    80
    Yes it copy past from my web site i want inform you that my web site content a group of new courses for beginner it means my target only beginners and here I’m trying to help beginners only also I have many courses in my web site
    http://oracle-sql-tutorials.blogspot.com
     
  4. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    At Last your promotion link is displayed here.............
     
  5. expora

    expora Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    80
    It’s some sequence tutorials I submitted for how want start to learn SQL please if you are expert and content it normal for you please don’t replay or add! and if you want to see complete explain check that link http://oracle-sql-tutorials.blogspot.com
    Thank you
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    I will reply and/or add as your examples contain errors which need to be corrected. Your post on savepoints is wrong as the syntax is incorrect; you post that 'rollback insert_finish' is correct and it isn't:

    Code (SQL):
    SQL> CREATE TABLE newemp AS SELECT * FROM emp;
     
    TABLE created.
     
    SQL>
    SQL> SELECT empno FROM newemp;
     
         EMPNO
    ----------
          7369
          7499
          7521
          7566
          7654
          7698
          7782
          7788
          7839
          7844
          7876
     
         EMPNO
    ----------
          7900
          7902
          7934
     
    14 ROWS selected.
     
    SQL>
    SQL> UPDATE newemp
      2  SET empno = empno + 1000;
     
    14 ROWS updated.
     
    SQL>
    SQL> SELECT empno FROM newemp;
     
         EMPNO
    ----------
          8369
          8499
          8521
          8566
          8654
          8698
          8782
          8788
          8839
          8844
          8876
     
         EMPNO
    ----------
          8900
          8902
          8934
     
    14 ROWS selected.
     
    SQL>
    SQL> SAVEPOINT empno_chg;
     
    SAVEPOINT created.
     
    SQL>
    SQL> UPDATE newemp
      2  SET sal=sal+300;
     
    14 ROWS updated.
     
    SQL>
    SQL> SELECT sal FROM newemp;
     
           SAL
    ----------
          1100
          1900
          1550
          3275
          1550
          3150
          2750
          3300
          5300
          1800
          1400
     
           SAL
    ----------
          1250
          3300
          1600
     
    14 ROWS selected.
     
    SQL>
    SQL> ROLLBACK TO empno_chg;
     
    ROLLBACK complete.
     
    SQL>
    SQL> SELECT empno FROM newemp;
     
         EMPNO
    ----------
          8369
          8499
          8521
          8566
          8654
          8698
          8782
          8788
          8839
          8844
          8876
     
         EMPNO
    ----------
          8900
          8902
          8934
     
    14 ROWS selected.
     
    SQL>
    Notice the correct syntax for using a savepoint to rollback to. The sequence post contains errors as well, and is incomplete. Your post on truncate doesn't explain anything as far as what truncate actually does (it does FAR more than simply removing rows from a table). the post on constraints is, again, incomplete. Your entire blog provides a small bit of information and many times that is not enough to fully describe the aspects of Oracle you want to teach. It is an admirable attempt but if you won't ensure your posts are using the correct syntax and describe the areas accurately it doesn't provide much in the way of assistance.
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
  8. expora

    expora Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    80
    Dear Members I'm Sure From My Examples If You Want Check Please Take A Copy And Past In SQL Editor And Replay, I Will Complete My Posts Still I Didn’t Finish My Blog Please Check Dates Of Posts. Also It A Blog You Know What Mean Blog I Think If You Know The Meaning Of Blog You Will Not Replay Like That
    Good luck
    And I’m sorry for disturbing for all who replay by criticism method
    Please if you see any error in any post in my blog please write a comment there and post