How can I have a light fixture over my dining room table?

Use candles

Solar powered lights, if you receive sufficient sun to charge the batteries, or sufficient numbers of battery operated lights suspended over the table atop a glass or plastic base.

You can buy lamp cord chain to hide a plug-in cord. Weave the cord in and out of the chain and then drape it along the ceiling using decorative plant hooks until you get to the wall where you can let the cord follow the wall down to a receptacle where you can plug the cord in. If you have a light switch near by, it is not that hard to put in a junction box and run a new line to a ceiling fixture.

Hi Shirley, You could get a swag light. Here's a link with pictures: https://www.google.com/search?rlz=1C1CHBF_enUS781US781&biw=1600&bih=794&tbm=isch&sa=1&ei=n_BLW4DkJs_N_AbKupXYDg&q=pictures+of+plug+in+swag+dining+room+lights&oq=pictures+of+plug+in+swag+dining+room+lights&gs_l=img.3...19083.20704.0.21041.8.8.0.0.0.0.117.877.0j8.8.0....0...1c.1.64.img..0.0.0....0.230FgSOpiPQ

Good luck!

Battery operated lights in an overhead position would be inconvenient and impractical. It will be physically awkward to climb up and down just to 'turn on/off' or to replace batteries for each individual light. It is also unlikely that they would give adequate lighting shining down on the dining table.

You can use a regular wall plug for the chandelier. :) Hang the chandelier where you want it with a cup hook, and swag the cord to the wall and down to the outlet. There are simple and attractive cord covers available for this purpose.