03-19-2015
Help to check if Oracle table exists
I am trying to write a script which allows a user to select the what manipulation he needs to do on a table. I want to check if the table exists or not. If it exists I will continue the other things or else I exit saying table doesn't exist. How might I achieve this.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to prompt for a response from a user to enter a path
read dest_dir?"Please Enter Directory :"
How do I do this until a valid directory is entered by the user. I can use
to check the existence of the directory. However when I try the following I cannot get it to work.
while ... (2 Replies)
Discussion started by: jerardfjay
2 Replies
2. Shell Programming and Scripting
Hi Good people :D
How do I check if a directory exists, if it does then carry on rest of the script, otherwise exit.
-------------
cd $mainfolder/system1
#unzips files arrived in last 24 hrs into temp directory
find * -mmin -1440 -exec unzip {} \;
I'd like to check here if temp... (2 Replies)
Discussion started by: SunnyK
2 Replies
3. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
4. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
5. Shell Programming and Scripting
Hi. I'd like to have an IF-Then-Else statement where I can check to see if a file exists? We have the Bourne Shell by default. I'm looking for the syntax to do something like this:
if myfile.txt exists then
...my code
else
...my code
end if
Any help would be greatly... (5 Replies)
Discussion started by: buechler66
5 Replies
6. Shell Programming and Scripting
Hi
#Testing for file existence
if ; then
echo 'SCHOOL data is available for processing'
else
echo 'SCHOOL DATA IS NOT AVAILABLE FOR PROCESSING'
:
i wrote a script, where it begins by checking if file exists or not.
If it exists, it truncates the database... (2 Replies)
Discussion started by: rxg
2 Replies
7. UNIX and Linux Applications
hi,
i need to copy one table with data into another table,
right now am using
create table table1 as select * from table2
i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies
8. UNIX for Dummies Questions & Answers
Hello,
May i please know how do i check if the given input argument is one of the listed numbers then success else failure. I am using bash shell.
if
then
echo "success"
else
echo "failure"
fi
Thank you. (2 Replies)
Discussion started by: Ariean
2 Replies
9. Shell Programming and Scripting
Hi,
I have the below code written. However I am not getting the desired output
I am checking if the particular path has file in it.
#!/bin/bash
ls -l /IRS2/IRS2_ODI/INFILE/*LS* 1>/dev/null 2>/dev/null
if
then
echo $?
echo "File Exists"
fi
... (3 Replies)
Discussion started by: Shanmugapriya D
3 Replies
LEARN ABOUT SUNOS
putdgrp
putdgrp(1M) System Administration Commands putdgrp(1M)
NAME
putdgrp - edits device group table
SYNOPSIS
putdgrp [-d] dgroup [device...]
DESCRIPTION
putdgrp modifies the device group table. It performs two kinds of modification. It can modify the table by creating a new device group or
removing a device group. It can also change group definitions by adding or removing a device from the group definition.
When the command is invoked with only a dgroup specification, the command adds the specified group name to the device group table if it
does not already exist. If the -d option is also used with only the dgroup specification, the command deletes the group from the table.
When the command is invoked with both a dgroup and a device specification, it adds the given device name(s) to the group definition. When
invoked with both arguments and the -d option, the command deletes the device name(s) from the group definition.
When the command is invoked with both a dgroup and a device specification and the device group does not exist, it creates the group and
adds the specified devices to that new group.
OPTIONS
The following options are supported:
-d Delete the group or, if used with device, delete the device from a group definition.
OPERANDS
The following operands are supported:
dgroup Specify a device group name.
device Specify the pathname or alias of the device that is to be added to, or deleted from, the device group.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
1 Command syntax was incorrect, an invalid option was used, or an internal error occurred.
2 Device group table could not be opened for reading or a new device group table could not be created.
3 If executed with the -d option, indicates that an entry in the device group table for the device group dgroup does not exist and
so cannot be deleted. Otherwise, indicates that the device group dgroup already exists and cannot be added.
4 If executed with the -d option, indicates that the device group dgroup does not have as members one or more of the specified
devices. Otherwise, indicates that the device group dgroup already has one or more of the specified devices as members.
EXAMPLES
Example 1: Adding a new device group.
The following example adds a new device group:
example# putdgrp floppies
Example 2: Adding a device to a device group.
The following example adds a device to a device group:
example# putdgrp floppies diskette2
Example 3: Deleting a device group.
The following example deletes a device group:
example# putdgrp -d floppies
Example 4: Deleting a device from a device group.
The following example deletes a device from a device group:
example# putdgrp -d floppies diskette2
FILES
/etc/dgroup.tab
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
listdgrp(1M), putdev(1M), attributes(5)
SunOS 5.10 5 Jul 1990 putdgrp(1M)