How to Creation & Execute the script using Oracle SQL command line/SQL Plus
HTML-код
- Опубликовано: 4 окт 2024
- #SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant
Join Our Telegram Group:
t.me/techtalks...
FOLLOW US :
============
RUclips : / techtalkwithnaresh
For More details Contact Us:
Email: nareshtech21@gmail.com
--------------------------------------------------------------------------------------------------------------------------------------------------------
/ @techtalkwithnaresh
You can get different technology videos on this link now started with Oracle database administration. you can watch the video from above link which will help you to improve your knowledge please like the videos and subscribe the channel and share with your friends.
This video will help them who are in the learning phase of PLSQL/SQL. If you have any doubt's regarding this video write in comment section. If you want any other video related to SQL/PLSQl/Oracle please comment in comment section.Please Like,Share and Subscribe the Channel.
Command to format the view of Command line(SQL Plus):
set pagesize 2000;
set linesize 2000;
Command to create the File:
ed file_name
E.g: ed script.sql
Command to run the file:
start file_name
E.g: start script.sql
Command to edit the file:
ed
Command to run script:
run
Lots of explanation in less time.
Nice explanation sir.keep on doing like this content videos.👏👍
@Madhav Thanks for acknowledgement. Subscribe to get latest explanation.
Thanks!
@Daniel Welcome, Subscribe to get latest updates.
Preciso de tradução do vídeo para inglês ou português
@Frases Please write in English so we can able to check and revert.
Nice
@24 AM Wonders Welcome. Subscribe to get latest updates.
Hello sir
Where we can save my script which is written on notepad.
@Bca You cant save select query in data base.
@@TechTalkwithNaresh where will I save my text file?
Which is written on notepad after using ed script.sql in command line???
Please help sir
@Bca.Wallah Save fist at desktop and then follow the steps ftom video.
@@TechTalkwithNaresh
Unable to open file
Error occurred
how to download lst file using sql plus can you explainn
@Neelabh you can fetch only the last query which you had return using sql plus.
how to make run another sql file
@Susanta you can edit the script and re-run.
where and how to download sql plus
@Harshad You can install oracle in the same package SQL plus also get install. And you can download Oracle from office oracle site. Subscribe to get latest updates.
Hi Naresh,
Thank you for the video on script creation.
would you or Do you have a video on connecting to SQLPLUS from a secondary machine
Machine A
Machine B (DB server)
connecting to DB available in Machine B, using a bash script.
could you please point me to your video or help me to do a connection?
@Prasad I don't have the video but you can connect using the TCP connection setting.
Tell me how to paste link on notepad
@Ali which link yo paste???