Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Tuesday, 3 October 2017

Drop Column in Oracle Table

Used to remove column from existing table
        Alter table <table_name> drop <col  datatype>;
ALTER TABLE student DROP (phone,email);
Share this article :


  1. Hi There,

    Great info! I recently came across your blog and have been reading along.
    I thought I would leave my first comment. I don’t know what to say except that I have

    We have a linked server "LinkSQL" defined on SQLServerA against the same server, ie, SQLServerA and the server has Named Pipes disabled. Isn't communication among'st applications within one server happens primarily through Named Pipes. If so, would it be better if we have Named Pipes enabled on this SQLServer box?
    We are seeing intermittent TCP/Semaphore errors and I was wondering if enabling this option would help.
    But nice Article Mate! Great Information! Keep up the good work!

    Thank you,

  2. Hi There,

    So bloody thorough! Ah! So happy and blessed out! I feel redeemed by reading out Drop Column in Oracle Table Keep up the good work!

    I got a list of the INDEXES from DBA Team which are non value added to the Database with the following conditions
    1:Low selectivity indexes.
    2:The number of distinct key values is less than 10 and the number of rows in table in greater than 100000.
    3:All these normal(Balances -Tree )indexes.
    They are asking the App Team to review these and to drop those indexes.
    But when I analyzed those indexes some of the columns are using in the where conditions of the so many queries.
    After applying the HINT of those indexes also the cost of query was decreasing.
    Here my confusion was, if we really drop those indexes, will it increase the performance?
    Do we need to convert those as BITMAP as they have low cardinality ?

    Please help me to understand the concept behind this .

    Thank you very much and will look for more postings from you.

    Thanks and Regards,

  3. Hi There,

    In debt to you for making my learning on the Drop Column in Oracle Table area so hassle-free! I lay my faith on your writings.
    I am facing one ora-error while executing the procedure.
    ORA-06512: at "Lax.CLOSE_DUP"
    ORA-06502: PL/SQL: numeric or value error: character string buffer too small

    i am suspecting it could be length issue with some of variables i have declared inside procedure
    l_effectreqcount number;----> This is tracking no of records being fetched.
    l_postdata varchar2(999); ---> This is the variable for which i believe the error has come.
    The reason is that in this variable l_postdata I am concatenating all the data being fetched from is something like this.

    THANK YOU!! This saved my butt today, I’m immensely grateful.


  4. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check

  5. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  6. Thanks a lot for sharing a valuable blog on OA Framework. I was browsing through the internet looking for OAF and Oracle ADF and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can find more information about OAF by attending oracle oaf online training. You can learn about interview questions by visiting OAF Interview Questions

  7. Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle PPM Cloud . Actually I was looking for the same information on internet for Oracle Project Portfolio Management (PPM) Cloud Tutorial and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more aboutOracle PPM Cloud . By attending Oracle PPM Cloud Training .

  8. Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. 増田裕介