DosTips.com

Hi all, I have a folder with .sql files. Inside the scripts there are well formatted and not well formatted "if statements" To be more specific there are if statements which are all in the same line. .i.e. IF CONDITION THEN STATEMENT1; END IF; (the stament can be also in lower case) Could you help m...

Hi all, I am sorry I am newbie in batch scripting, but I need a script to append text to files. I have sql files in a folder structure like the following : C:\Users\George\Desktop\SQL_FILES\data\Folder1\test.sql C:\Users\George\Desktop\SQL_FILES\data\Folder2\test.sql C:\Users\George\Desktop\SQL_FILE...

Hi all, I am writing a batch program to connect to multiple sids for the same hostname. The issue I have is that while the script runs perfectly for me,when I give to other colleagues to use it they complaints that it does not work Version 11 :==> it works for me exit | sqlplus -s user/password@host...

Thanks a lot for your help

Hi all, I an noobie in batch scripting and I would appreciate if you could help me. I want to create a script which reads a root path (windows path or svn path), checking only the .sql files which are inside "Packages" and "Package Bodies" folders. The script I would like to chec...

Hi all,
I am new in batch scripting and I would like to ask you
if there is any way to get graphical interface such as

I would like something like the attached image and only the menu to be refreshed.

Thanks in advance for your answers

I appreciate your help.
It works perfect.

Thank you all for your answers

Hi all, I want to make a batch script in order to verify some database instances that do not have invalid objects. I have created the following sql file : check.sql SELECT owner, object_name, object_type, status FROM dba_objects WHERE status = 'INVALID' / And the executable file is the following : s...