Advertisement

1 - 10 of 134 containing alltags:("ddl") (0 seconds)
I am trying to generate DDLs for hundreds of tables, including indices, constraints, synonyms, etc. Are there any ways or tools to extract DDLs automatically? I don't want to use  Designer 2000 o...
Zones: OracleDate Answered: 11/02/2000 Grade: A Views: 0
Can someone tell me if it is possible to execute dll from plsql? I am trying to see if a sequence exists, drop it if it does, and recreated it according to a certain max(column) in a table. ...
Zones: OracleDate Answered: 05/18/2001 Grade: B Views: 0
Hello, i have an submit form, this form sends a variable called catID from a ddl(drop down list) to a confirm page, which I want to display the same catID in a ddl. the only problem is that these...
Zones: PHPDate Answered: 12/23/2002 Grade: A Views: 0
I have 2 drop down lists(DDL). After the user selects value from DDL #1, i would like to query the DB and populate DDL #2. How do i do this? Thanks
Zones: C#Date Answered: 03/21/2004 Grade: A Views: 0
how can i use any Oracle DDL Statement (Create, alter, drop, rename ...) and and any SQL * Plus (set feedback off) in a pl/sql block ? Thanks.
Zones: DatabasesDate Answered: 04/30/2005 Grade: B Views: 0
I would like to know if there is a way to validate a DDl statement before it is executed and returns an error code. I am refering not only to the validity of the DDL's syntax, but more important...
Zones: Oracle Product InfoDate Answered: 12/03/2006 Grade: A Views: 0
How can I create a trigger that would allow ORACLE forms to do the equivalent of the sql command: CREATE USER username IDENTIFIED BY userpsswd DEFAULT TABLESPACE filename TEMPORARY TABLESPACE temp...
Zones: OracleDate Answered: 09/17/1998 Grade: B Views: 0
How do I add an Autonumber field to a table by using a DDL SQL statement?  I can define it as an integer primary key like this, but I cannot set it to autoincrement.   ------- CREATE TABLE Sample...
Zones: MS AccessDate Answered: 01/24/1999 Grade: A Views: 0
I have a procedure wich have an input parameter the name of a table (ex. mytable ) in the body  of the procedure i want to execute this sql : select mycolumn into myvar from mytable ... forms doe...
Zones: OracleDate Answered: 09/04/1999 Grade: C Views: 8
How to generate DDL (for tables only)from existing database without using export? Is there any script available? Thanks.
Zones: OracleDate Answered: 05/15/2000 Grade: C Views: 18