How to put sql script into batch (. bat) file for execution

Reported answer
How to put sql script into batch (. bat) file for execution
Ask online customer service
Scan the code to ask online customer service
  • Number of answers

    three

  • Number of browses

    1,060

3 answers Default sorting
  • Default sorting
  • Sort by time

Adopted
Cmd/c osql - S127.0.0.1 - Usa - P123 - dTest - iE: Data Learn MSSQL Dos Executive File test.sql

-S: Database IP address
-U: User name

-P: Password

-d: Database name
-i: Database file

Note: If the database is not installed, your system may not have an environment for the osql tool. At this time, we only need to set the OSQL Copy the EXE and osql.rll files to the c: window system32 directory
cancel comment
@echo onlsnrctl start@pause runas /savecred /user:devadm cmd /c cd /d D:\oracle\DEV\11204\BIN&sqlplus \/as sysdba\ @Open.bat
cancel comment
The sql script should be imported and executed in the manager
cancel comment
ZOL Q&A > camera > Other classifications > How to put sql script into batch (. bat) file for execution

Top Digital Cameras

See more rankings>

report

Thank you for contributing to the harmony of the community. Please select the type of report

Reported successfully

It will be handled after verification
Thank you for your contribution to community harmony

Scan the code to participate in the trial of new products at 0 yuan
You can get the sheets and grand gifts on the top floor

 Scan and pay attention to us
Tips

Are you sure you want to cancel this registration and exit this activity?