Mon Mar 8 20:35:20 2021
EVENTS
 FREE
SOFTWARE
INSTITUTE

POLITICS
JOBS
MEMBERS'
CORNER

MAILING
LIST

NYLXS Mailing Lists and Archives
NYLXS Members have a lot to say and share but we don't keep many secrets. Join the Hangout Mailing List and say your peice.

DATE 2014-11-01

LEARN

2021-03-08 | 2021-02-08 | 2021-01-08 | 2020-12-08 | 2020-11-08 | 2020-10-08 | 2020-09-08 | 2020-08-08 | 2020-07-08 | 2020-06-08 | 2020-05-08 | 2020-04-08 | 2020-03-08 | 2020-02-08 | 2020-01-08 | 2019-12-08 | 2019-11-08 | 2019-10-08 | 2019-09-08 | 2019-08-08 | 2019-07-08 | 2019-06-08 | 2019-05-08 | 2019-04-08 | 2019-03-08 | 2019-02-08 | 2019-01-08 | 2018-12-08 | 2018-11-08 | 2018-10-08 | 2018-09-08 | 2018-08-08 | 2018-07-08 | 2018-06-08 | 2018-05-08 | 2018-04-08 | 2018-03-08 | 2018-02-08 | 2018-01-08 | 2017-12-08 | 2017-11-08 | 2017-10-08 | 2017-09-08 | 2017-08-08 | 2017-07-08 | 2017-06-08 | 2017-05-08 | 2017-04-08 | 2017-03-08 | 2017-02-08 | 2017-01-08 | 2016-12-08 | 2016-11-08 | 2016-10-08 | 2016-09-08 | 2016-08-08 | 2016-07-08 | 2016-06-08 | 2016-05-08 | 2016-04-08 | 2016-03-08 | 2016-02-08 | 2016-01-08 | 2015-12-08 | 2015-11-08 | 2015-10-08 | 2015-09-08 | 2015-08-08 | 2015-07-08 | 2015-06-08 | 2015-05-08 | 2015-04-08 | 2015-03-08 | 2015-02-08 | 2015-01-08 | 2014-12-08 | 2014-11-08 | 2014-10-08

Key: Value:

Key: Value:

MESSAGE
DATE 2014-11-24
FROM Ruben
SUBJECT Re: [LIU Comp Sci] Oracle DBA short cuts
From owner-learn-outgoing-at-mrbrklyn.com Mon Nov 24 13:50:55 2014
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id B7AB7161154; Mon, 24 Nov 2014 13:50:55 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id 9E19C16115B; Mon, 24 Nov 2014 13:50:55 -0500 (EST)
Delivered-To: learn-at-mrbrklyn.com
Received: from mail-qa0-f54.google.com (mail-qa0-f54.google.com [209.85.216.54])
by mrbrklyn.com (Postfix) with ESMTP id C3CE4161154
for ; Mon, 24 Nov 2014 13:50:53 -0500 (EST)
Received: by mail-qa0-f54.google.com with SMTP id i13so6932049qae.27
for ; Mon, 24 Nov 2014 10:50:52 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20130820;
h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to
:subject:references:in-reply-to:content-type
:content-transfer-encoding;
bh=dn9a+uaomx0tPNwkr+DeyuqDL/ajrtwMjfD1Prc4S/M=;
b=Afx1Bs44X0oibNoSuShI/pNDThD8yU3ArldJgea860o4QErBindWIA3PqYilKmSmz9
MK+w1488E/B9bnk6WmzlPWQ0tM7IBbEZP4rJnO58KebwnWyppvzZszmPEzqAn2sAp6HO
FsEUv9NPMpYUORbQnqaJPN0gwRMPQFUTCvjA4mLIq5zzJGdPquoeSP9NjQvatiT7UXrF
KH0legUUCnRsk+mv1nNMi5pdAFZxki05UK/Xg3uem9WJmSQQIR03U55O4r+WBWu422pR
WULTOFan9EnhBakAbD9zOTOKFSGY3/OFRrOHHoSbMOz3ymwCnPMSxWscCJ7YfkRWBzec
w9oQ==
X-Gm-Message-State: ALoCoQn5OTF+zXpd2nQwtcp0lp+ht9mzhzMAREhULtEn1pcf9B81FnNT7HXWAIczrm262QhR3uOt
X-Received: by 10.140.102.116 with SMTP id v107mr30444432qge.68.1416855052783;
Mon, 24 Nov 2014 10:50:52 -0800 (PST)
Received: from [10.0.0.42] ([96.57.23.82])
by mx.google.com with ESMTPSA id f65sm12523908qgf.41.2014.11.24.10.50.52
for
(version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
Mon, 24 Nov 2014 10:50:52 -0800 (PST)
Message-ID: <54737E53.8000904-at-my.liu.edu>
Date: Mon, 24 Nov 2014 13:52:03 -0500
From: Ruben
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.1.0
MIME-Version: 1.0
To: learn-at-mrbrklyn.com
Subject: Re: [LIU Comp Sci] Oracle DBA short cuts
References: <54737DB7.2080706-at-panix.com>
In-Reply-To: <54737DB7.2080706-at-panix.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Sender: owner-learn-at-mrbrklyn.com
Precedence: bulk
Reply-To: learn-at-mrbrklyn.com

SELECT *
FROM user_cons_columns
WHERE table_name = '';
FYI, unless you specifically created your table with a lower case name (using double quotes) then the table name will be defaulted to upper case so ensure it is so in your query.

If you then wish to see more information about the constraint itself query the USER_CONSTRAINTS view:

SELECT *
FROM user_constraints
WHERE table_name = ''
AND constraint_name = '';
If the table is held in a schema that is not your default schema then you might need to replace the views with:

all_cons_columns
and

all_constraints
adding to the where clause:

AND owner = ''


  1. 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] Re: Welcome to learn
  2. 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] second post!!
  3. 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Files for the Homework and Oracle Resources
  4. 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Webineir on pl/sql
  5. 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] UEFI and Secure Boot
  6. 2014-11-24 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Oracle DBA short cuts
  7. 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle DBA short cuts
  8. 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Re: Database Management Systems: DBMS Announcement on Nov. 23
  9. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Problems with Normalization
  10. 2014-11-26 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] =?UTF-8?B?UmU6IERhdGFiYXNlIE1hbmFnZW1lbnQgU3lzdGVtczogQ1MgNjQ5IEE=?=
  11. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] More problems with modeling and normalization
  12. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Normalize because your professor said too
  13. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Problems with Normalization
  14. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Data Models Shouldn't Drive Object Models (And Vice Versa)
  15. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Normalization Failed to Become the Ultimate Guide for Database
  16. 2014-11-29 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Memory Cache theory Architecture Class
  17. 2014-11-30 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Cache Model in C programming

NYLXS are Do'ers and the first step of Doing is Joining! Join NYLXS and make a difference in your community today!