SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Load data from excel to Oracle Tables

969952Nov 13 2012 — edited Nov 20 2012

Hi All,

I want to create a table with payment year as sysdate ( to_char(sysdate,'yyyy')) and month as 'MM' by default ( like payment_month default <(syadate,'MM')>

I am trying to do it but failed. Please help me out and the other one is want to load the data from EXCEL to ORACLE table.

I used to load the load the data by using SQL * LOADER. can you please let me know is it possible to load the data without using SQL*Loader? please provide me the solution for this.

Thanks,
Ora.

This post has been answered by AlbertoFaenza on Nov 18 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2012

Added on Nov 13 2012

70 comments

5,943 views