03-29-2013
1. table name and schema name should be passed as input parameters to the script
2. taking those inputs it should validate all the database objects
3. after validating it should write to a .csv or excel file
writing output should be like this
SELECT table_name, column_name, data_type, data_length, nullable
FROM all_tab_columns
WHERE table_name IN ('$TABLE_NAME') AND owner IN ('$OWNER_NAME')
ORDER BY column_id;
Last edited by srikanth_sagi; 03-29-2013 at 02:08 AM..
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 REDHAT
drop_table
DROP
TABLE(7) SQL Commands DROP TABLE(7)
NAME
DROP TABLE - remove a table
SYNOPSIS
DROP TABLE name [, ...] [ CASCADE | RESTRICT ]
INPUTS
name The name (optionally schema-qualified) of an existing table to drop.
CASCADE
Automatically drop objects that depend on the table (such as views).
RESTRICT
Refuse to drop the table if there are any dependent objects. This is the default.
OUTPUTS
DROP TABLE
The message returned if the command completes successfully.
ERROR: table "name" does not exist
If the specified table does not exist in the database.
DESCRIPTION
DROP TABLE removes tables from the database. Only its owner may destroy a table. A table may be emptied of rows, but not destroyed, by
using DELETE.
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 foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove the foreign-key constraint, not
the other table itself.)
NOTES
Refer to CREATE TABLE and ALTER TABLE for information on how to create or modify tables.
USAGE
To destroy two tables, films and distributors:
DROP TABLE films, distributors;
COMPATIBILITY
SQL92
SQL - Language Statements 2002-11-22 DROP TABLE(7)