How to run SQL statements?

9 posts · originally from https://geek.digit.in/community/threads/how-to-run-sql-statements.54005/

I am new to DBMS.....

when i construct simple queries, i can't run them either with Oracle 10g
or with MySQL. They show 'Not connected to server'.....or something like that.

this is obvious as there is no server or a central system to store the database queries....

so how to run these on a single standalone PC?

1) Open notepad

2) Copy the following code:-

@echo off
echo connect INTERNAL/ORACLE >%0.tmp
echo STARTUP OPEN >>%0.tmp
echo exit 8; >>%0.tmp
rem -- Run sql script --
sqlplus /nolog @%0.tmp
rem -- Cleanup --
del %0.tmp

3) Save the file as "Start.bat"
4) Run this file and then try your SQL commands in MySql.

Hope this will work for you..

Do let me knw if u face any prob still !

when u got SQL> on Oracle 10g, write 'connect' there.

and use username as scott 'n password as tiger.

or username as system and username u provided on installation

tried...but its saying "no database selected"......

^^^^ u tried with the batch file??

the batch file got executed in a flash and went off.

then once again i opened mysql command line and created a table(query)....
it didnt accept saying, 'no database selected'

don't just jump on oracle it is very advance database server start from mssql
it is available free @ msdn.com for developer and student.

Why u don't tried with GUI ???

Oracle 9i onwards support Browser based database creation!

Not Connected to Server error??? tat might b bcoz oracle DB has been disabled in startup... try enabling it???