Thu Nov 21 23:50:51 2024 EVENTS FREE SOFTWARE INSTITUTE POLITICS JOBS MEMBERS' CORNER MAILING LIST 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 2024-11-21 | 2024-10-21 | 2024-09-21 | 2024-08-21 | 2024-07-21 | 2024-06-21 | 2024-05-21 | 2024-04-21 | 2024-03-21 | 2024-02-21 | 2024-01-21 | 2023-12-21 | 2023-11-21 | 2023-10-21 | 2023-09-21 | 2023-08-21 | 2023-07-21 | 2023-06-21 | 2023-05-21 | 2023-04-21 | 2023-03-21 | 2023-02-21 | 2023-01-21 | 2022-12-21 | 2022-11-21 | 2022-10-21 | 2022-09-21 | 2022-08-21 | 2022-07-21 | 2022-06-21 | 2022-05-21 | 2022-04-21 | 2022-03-21 | 2022-02-21 | 2022-01-21 | 2021-12-21 | 2021-11-21 | 2021-10-21 | 2021-09-21 | 2021-08-21 | 2021-07-21 | 2021-06-21 | 2021-05-21 | 2021-04-21 | 2021-03-21 | 2021-02-21 | 2021-01-21 | 2020-12-21 | 2020-11-21 | 2020-10-21 | 2020-09-21 | 2020-08-21 | 2020-07-21 | 2020-06-21 | 2020-05-21 | 2020-04-21 | 2020-03-21 | 2020-02-21 | 2020-01-21 | 2019-12-21 | 2019-11-21 | 2019-10-21 | 2019-09-21 | 2019-08-21 | 2019-07-21 | 2019-06-21 | 2019-05-21 | 2019-04-21 | 2019-03-21 | 2019-02-21 | 2019-01-21 | 2018-12-21 | 2018-11-21 | 2018-10-21 | 2018-09-21 | 2018-08-21 | 2018-07-21 | 2018-06-21 | 2018-05-21 | 2018-04-21 | 2018-03-21 | 2018-02-21 | 2018-01-21 | 2017-12-21 | 2017-11-21 | 2017-10-21 | 2017-09-21 | 2017-08-21 | 2017-07-21 | 2017-06-21 | 2017-05-21 | 2017-04-21 | 2017-03-21 | 2017-02-21 | 2017-01-21 | 2016-12-21 | 2016-11-21 | 2016-10-21 | 2016-09-21 | 2016-08-21 | 2016-07-21 | 2016-06-21 | 2016-05-21 | 2016-04-21 | 2016-03-21 | 2016-02-21 | 2016-01-21 | 2015-12-21 | 2015-11-21 | 2015-10-21 | 2015-09-21 | 2015-08-21 | 2015-07-21 | 2015-06-21 | 2015-05-21 | 2015-04-21 | 2015-03-21 | 2015-02-21 | 2015-01-21 | 2014-12-21 | 2014-11-21 | 2014-10-21 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 = '' 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] Re: Welcome to learn 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] second post!! 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Files for the Homework and Oracle Resources 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Webineir on pl/sql 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] UEFI and Secure Boot 2014-11-24 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Oracle DBA short cuts 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle DBA short cuts 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Re: Database Management Systems: DBMS Announcement on Nov. 23 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Problems with Normalization 2014-11-26 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] =?UTF-8?B?UmU6IERhdGFiYXNlIE1hbmFnZW1lbnQgU3lzdGVtczogQ1MgNjQ5IEE=?= 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] More problems with modeling and normalization 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Normalize because your professor said too 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Problems with Normalization 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Data Models Shouldn't Drive Object Models (And Vice Versa) 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Normalization Failed to Become the Ultimate Guide for Database 2014-11-29 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Memory Cache theory Architecture Class 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!