07-13-2016
Fill in the entire questionnaire compulsory for homework (see rules).
This User Gave Thanks to RudiC For This Post:
10 More Discussions You Might Find Interesting
1. Programming
hi ,
How to view the contents of a "c" program symbol table information in unix. (1 Reply)
Discussion started by: saravanan_nitt
1 Replies
2. Shell Programming and Scripting
Hi ,
Can anyone help me regarding loading a unix file data to oracle database table using shell scripts?
I wanted to grep only this data from a spool file
sql_test.txt
99
00:00:00:01
but if I use grep I am getting format
sql_test.txt
99 rows selected.
Elapsed:... (2 Replies)
Discussion started by: ran16
2 Replies
3. Shell Programming and Scripting
Hi All,
In a given directory, I need to list the files present in it in the below given format as a table.
File name Permission Number of Bytes File Type
Telecom1 --w-r-x 1230 Directory
Telecom2 ---x---x---x 450 Device file
Telecom3 ... (7 Replies)
Discussion started by: mr_manii
7 Replies
4. UNIX for Dummies Questions & Answers
I need help to produce output as below
1 2 3 4 5
2 4 6 8 10
3 6 9 12 15
4 8 12 16 20
5 10 15 20 25
my script
#!/bin/bash
for (( i = 1; i <= 5; ++i ));
do
echo -n $i
for (( j = 1; j <=5; ++j ));
do
multiply=$(( $i * $j ))
done
echo $multiply (1 Reply)
Discussion started by: killboy
1 Replies
5. Shell Programming and Scripting
Hi,
I am trying to insert a record into a table (say dips_tbl) which resides in Oracle DB through a ksh script. I want to insert records into few of the table columns-not all. I'll give an e.g. for the date column "CREATE_DATE".
For that I first execute
SQL1="SELECT SYSDATE FROM DUAL"
... (1 Reply)
Discussion started by: dips_ag
1 Replies
6. Shell Programming and Scripting
#!/bin/sh
echo Enter the multiplication number required:
read number
for i in 1 2 3 4 5 6 7 8 9 10
do
echo "$number * $i = expr $number \* $i"
done
I am not getting the output for this multiplication table. (4 Replies)
Discussion started by: vinodpaw
4 Replies
7. UNIX for Dummies Questions & Answers
I need to create a simple table of information by grepping several columns from various files and display them all at once with simple headers on top. Can anyone help get me started? I am very new to unix so I really have no idea how to work with this and I appreciate any help I can get! Let me... (11 Replies)
Discussion started by: aj250
11 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I just downloaded this example from the net. I was looking around for a hash table like implementation in unix when I came across this.
ARRAY=( "cow:moo"
"dinosaur:roar"
"bird:chirp"
"bash:rock" )
for animal in ${ARRAY} ; do
KEY=${animal%%:*}
... (8 Replies)
Discussion started by: anindyabecs
8 Replies
9. Shell Programming and Scripting
Hello All,
i have a file sort.txt with below entries.
1 12 10
16 6 4
20 8 15
i need to sort these entries and the out put should come in a single line.
1 4 6 8 10 12 15 16 20
Can you please help me sort this out? (2 Replies)
Discussion started by: sureshk_85
2 Replies
10. Shell Programming and Scripting
Hi frndz,
Can anyone provide me some input or pseudo code for my req as mentioned below...
I am loading 2 files through unix script into oracle table...as i am doing some updates also i am getting an error where both files try to update the table simultaneously and my script fails..
so i... (3 Replies)
Discussion started by: gnnsprapa
3 Replies
LEARN ABOUT CENTOS
drop_table
DROP
TABLE(7) PostgreSQL 9.2.7 Documentation 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 the table owner, the schema owner, and superuser can drop a table. To empty a table of
rows without destroying the table, use DELETE(7) or 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))
PostgreSQL 9.2.7 2014-02-17 DROP TABLE(7)