Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table and it has constraints and i want to get
"ALTER TABLE table_name
ADD CONSTRAINT constraint_name constraint type" this code
must be in string type
please help me
if you want, i can give more explainings
- 2 Answers
- 5037 Views
- I also Faced
- E-Mail Answers
Answer Posted / ron
looks like you need to generate create / alter statements
from database data dictionary.
you need to run oracle package:
exec dbms_metadata.get_ddl(.....);
following the link for examples:
http://blogs.ittoolbox.com/database/solutions/archives/ddl-generationoracles-answer-to-save-you-time-and-money-7590
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are archived logs?
What is the sql query to concatenate column values from multiple rows in oracle?
How will you differentiate between varchar & varchar2?
How do I find my oracle client driver version?
Explain the use of compress option in exp command.
How do I know if oracle is installed on windows?
What do you mean by merge in oracle?
What is merge in oracle?
What is the order of defining local variables and sub procedures/functions?
What privilege is needed for a user to create tables in oracle?
How to load data from external tables to regular tables?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Can we convert a date to char in oracle and if so, what would be the syntax?
interview questions with answer for cts
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
