User Profile

Collapse

Profile Sidebar

Collapse
sushjames
sushjames
Last Activity: Jul 12 '07, 01:43 PM
Joined: May 22 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sushjames
    replied to [1]: (Error): ORA-00907: missing right parenthesis
    in Oracle
    Hello brother

    This Problem arrives due to syntax error. So re do the statement once again and make sure you had closed all the brackets and ; all this stuffs.
    See more | Go to post

      Leave a comment:

    • sushjames
      replied to Cursor in PL/SQL Oracle
      in Oracle
      Here you can download the oracle 9i book (complete reference)

      http://rapidshare.com/files/18825720/Oracle9i.The.Co mplete.Referenc e.rar

      Have a nice day
      See more | Go to post

        Leave a comment:

      • sushjames
        started a topic is this syntax right?
        in Oracle

        is this syntax right?

        Here this Syntax doesn't have where clause. SO is it possible to specify a condition without where clause also?. Can someone help me pls.

        select empname from employess empname like 'jack%';
        See more | Go to post
        • sushjames
          replied to function truncate
          in Oracle
          can anyone tell me how to recall the deleted data ?...
          See more | Go to post

            Leave a comment:

          • sushjames
            replied to alter table syntax
            in Oracle
            Thanx dude! and Can you tell me anything about OCP Exam?...
            See more | Go to post

              Leave a comment:

            • sushjames
              replied to alter table syntax
              in Oracle
              hi frozenmist,

              I had tried this syntax in oralce 8i but still it's not working. Are you sure that this syntax is working in oracle 9i bcoz if it's working in oracle 9i then i will upgrade my oracle 8i to 9i. Can you pls confirm it.. thanx in advance
              See more | Go to post

                Leave a comment:

              • sushjames
                started a topic alter table syntax
                in Oracle

                alter table syntax

                hello experts,

                i'm having a problem in this synatx

                alter table <table name> drop column <column name>

                alter tabel <table name> rename column <old column name> to <new column name>

                actually this syntax aren't working in oracle 8i whether it will work in 9i ?. can anyone suggest me pls. and also can anyone tell me the difference between 8i...
                See more | Go to post
                No activity results to display
                Show More
                Working...