Question about constraint?? (merged many) [message #378012] |
Sat, 27 December 2008 14:56 |
burak
Messages: 12 Registered: December 2008
|
Junior Member |
|
|
I am studying at computer engineering and I need to solve this problem about oracle sql...
my question is about constraint ..I need to call constraint at select section and I will have result adding constraint with alter table wich ı have call ...but result seem code ...like alter table add constraint
please answer me.....
[Updated on: Mon, 29 December 2008 06:38] by Moderator Report message to a moderator
|
|
|
Re: I have very problem please help me...... [message #378013 is a reply to message #378012] |
Sat, 27 December 2008 15:03 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Sorry, but that question makes absolutely no sense.
A constraint is NOTHING that you would "call at select section" (Whatever that means)
And what would be the actual difference between "have result adding constraint with alter table" (what you seem to want) and "result seem code of alter table add constraint code" (what you don't seem to want).
Both are about adding a constraint with an alter table statement.
What are you actually trying do do?
|
|
|
|
Re: I have very problem please help me...... [message #378015 is a reply to message #378013] |
Sat, 27 December 2008 15:11 |
burak
Messages: 12 Registered: December 2008
|
Junior Member |
|
|
okey ı will explian ...I have a table and ..I have constraints at table...I need to call constraint name with select for example select empvu20 from user_constraint
and result will be code of alter table add constraint empvu20 ... sth like that
|
|
|
|
|
Re: I have very problem please help me...... [message #378018 is a reply to message #378017] |
Sat, 27 December 2008 15:30 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Michel Cadot wrote on Sat, 27 December 2008 22:14 | So do it. What is your problem?
Regards
Michel
|
In other words, what prevent you from doing it? What did you try so far?
Before posting any SQL statement or PL/SQL code, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Regards
Michel
[Updated on: Sat, 27 December 2008 15:38] Report message to a moderator
|
|
|
|
|
Question about constraint?? [message #378054 is a reply to message #378012] |
Sun, 28 December 2008 04:22 |
burak
Messages: 12 Registered: December 2008
|
Junior Member |
|
|
I cant give an example because ıt s my home work...
I need to code for add constraint with alter table..but this will be result...I mean see code at result..
for example ı will call my constraint with select from my table...the result ignore my constraint and adding code them
|
|
|
|
|
|
Re: Question about constraint?? [message #378069 is a reply to message #378067] |
Sun, 28 December 2008 04:57 |
burak
Messages: 12 Registered: December 2008
|
Junior Member |
|
|
I will call my constraint from related table in a select section and then return to me adding constraint sql code ,wihch ı have called,ignore holder consraints and add them again but I see only sql code at result...
thanks...
|
|
|
|
|
|
Need help about user_tab_columns [message #378197 is a reply to message #378012] |
Mon, 29 December 2008 05:44 |
burak
Messages: 12 Registered: December 2008
|
Junior Member |
|
|
hi,
i have a very big problem about oracle.It is about my school project.The problem is that i want to see the table's properties.I want to know how the table is created.For example:
create table TestTable(
2 ID VARCHAR2(4 BYTE) NOT NULL,
3 MyName VARCHAR2(10 BYTE),
4 MyDate DATE,
5 MyNumber Number(8,2)
6 )
7 /
I want to see that code by the command.But this will be done by "select" command.(Not DBMS_METADATA.GET_DDL).I want to details of this structure.(Note:The teacher said that it was about user_tab_columns)
|
|
|
|
|
i want to see the constraints of table by "select" [message #378209 is a reply to message #378012] |
Mon, 29 December 2008 05:55 |
burak
Messages: 12 Registered: December 2008
|
Junior Member |
|
|
My problem is so confused i think.It is about the "select" command.I will write "select" command and the output will be like that:
ALTER TABLE EMPLOYEE
ADD CONSTRAINT REVENUE CHECK (SALARY + COMM > 25000)
So i will see that code by using "select" command but how?
|
|
|
|
|
|
|
|
|
Re: i want to see the constraints of table by "select" [message #378219 is a reply to message #378217] |
Mon, 29 December 2008 06:04 |
burak
Messages: 12 Registered: December 2008
|
Junior Member |
|
|
You merged two questions.They were different.The problem is that i will write some "select" commands and then the structure about the table will come.This is so simple but i don't know.It was about user_tab_columns.I just don't know what to write in "select".
|
|
|
|