03-28-2013
Any Sample ksh script to validate all the database objects
Hi,
I need a sample script to validate all the database objects like
1. table structure(columns, datatypes,key contraints if any)
2. synonyms
3. grants
4. indexes
....etc
thank you!
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi everybody,
Does somebody has a sample of script that control a daemon?
for example use loop until the daemon is on and if is not on
do something else?
Thanks
Pier (0 Replies)
Discussion started by: pierrelaval
0 Replies
2. Shell Programming and Scripting
Hi All,
I need to convert the data from excel to database table in sybase. Please provide some sample script..
thanks,
Royal. (1 Reply)
Discussion started by: royal9482
1 Replies
3. Shell Programming and Scripting
Hi all:
Trying to count the number of oracle instances on HPUX 11.23 - using ksh. I have multiple instances running and I would like to have a count for how many processes for each instance. Example, run the 'ps -efu oracle' command and for each instance increment a counter. So I am looking for... (4 Replies)
Discussion started by: raggmopp
4 Replies
4. Shell Programming and Scripting
how do i validate xml agaist xsd is ksh? (1 Reply)
Discussion started by: LiorAmitai
1 Replies
5. Shell Programming and Scripting
Hi All,
I want to validate the Production Database password at the time of login through script. If incorrect password entererd by the user, the script will ask again for the password.
Below is the sample of my script...
#########################
# Unix Code Starts here #... (6 Replies)
Discussion started by: saps19
6 Replies
6. Shell Programming and Scripting
Hello, I'm new to this forum, and I apologize in advance if I did something wrong here.
I am pretty stumped here as I am still getting the error message, "./comc1.sh: test: argument expected." after executing the script itself.
Here's the script file I modified:
I tried executing line 4... (1 Reply)
Discussion started by: ConcealedKnight
1 Replies
7. Shell Programming and Scripting
hi all, I need some help in regards of how to process just a sample from a large .txt file
I have a large file from many new lines (say above 200.000 new lines), I need a script that process just a sample of it, say 10.000 bur a random sample (taking rows from top top to the the bottom)
... (4 Replies)
Discussion started by: c_lady
4 Replies
8. Shell Programming and Scripting
Below is the code. Its the 1st line of a file.
How can I remove the bracket and display like below.
123 web int 1 09:30:45 2013
I dont want to use AWK or SED or PERL. I need to use only the bash shell scripting commands to do it. (3 Replies)
Discussion started by: ghosh_tanmoy
3 Replies
9. UNIX for Beginners Questions & Answers
Sample shell script to add a user:
Today i learn how to add a user to linux server with a password.
#!/bin/bash
# Script to add a user to Linux system
if ; then
read -p "Enter username : " username
read -s -p "Enter password : " password
egrep "^$username" /etc/passwd >/dev/null
if ;... (0 Replies)
Discussion started by: ulaxmi
0 Replies
LEARN ABOUT SUSE
drop_table
DROP
TABLE(7) SQL Commands DROP TABLE(7)
NAME
DROP TABLE - remove a table
SYNOPSIS
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP TABLE removes tables from the database. Only its owner can drop a table. To empty a table of rows without destroying the table, use
DELETE [delete(7)] or TRUNCATE [truncate(7)].
DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is
referenced by a view or a foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove a dependent view
entirely, but in the foreign-key case it will only remove the foreign-key constraint, not the other table entirely.)
PARAMETERS
IF EXISTS
Do not throw an error if the table does not exist. A notice is issued in this case.
name The name (optionally schema-qualified) of the table to drop.
CASCADE
Automatically drop objects that depend on the table (such as views).
RESTRICT
Refuse to drop the table if any objects depend on it. This is the default.
EXAMPLES
To destroy two tables, films and distributors:
DROP TABLE films, distributors;
COMPATIBILITY
This command conforms to the SQL standard, except that the standard only allows one table to be dropped per command, and apart from the IF
EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER TABLE [alter_table(7)], CREATE TABLE [create_table(7)]
SQL - Language Statements 2010-05-14 DROP TABLE(7)