Results 1 to 2 of 2

Thread: How can I execute a file which include 'create table ' statement

  1. 07-17-2007 #1
    Geek_Guest
    Guest

    How can I execute a file which include 'create table ' statement

    How can I execute a file which include 'create table ' statement? for example file.out I want to execute in a procedure. I try @file.OUT,exec file.OUT but didn't work.

    Question asked by visitor joe

    Reply With Quote Reply With Quote
  2. 07-17-2007 #2
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas How can I execute a file which include 'create table ' statement

    Re: How can I execute a file which include 'create table ' statement

    write the SQL statments to a file and save with the extension .SQL

    then use

    SQL> @filename

    it will execute.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact