> Dear AK,
> Thanx a lot for answering my prev. questions. Now i have two more
> questions;
> 1. How to create tables dynamically based on the given date using
> SQL*Plus/Forms4.5?
>       For eg, if i enter 19-FEB-1998, the name of table to created is
> FEB19_1998 and so on.
> 2.  How to find out whether a column has been indexed in Ascending Order
> or Descending?
> Thanx in advance for ur. help.
> -SrinivasanR
>  Chennai,India.
Namaste from the USA,

1. You will need to use dynamic SQL. This is with the DBMS_SQL package. You
   can create DML statements in any way you want. It's really powerful and
   flexible. You can specify the table name based on SYSDATE if you want this
2. As for ascending or descending, I do not know what you mean. Indexes are
   stored in a B-Tree fashion. The records can be selected in different orders
   based on the ORDER BY clause. In Oracle8 there are reverse-key indexes which
   store the index using the last byte of the column as the first byte of the
   index, the second-to-last byte of the column as the second byte of the
   index, etc.

**** Thanks to Hari Vesta for the following additions to this tip: *****

It is good thing to user Dynamic SQL. But Forms 4.5 has more power ful 
feature to create tables. Forms has a function called FORMS_DDL which 
takes sql statement as Varchar2 and submitts it to the Database.

Second thing to create indexes ASC or DESC. Oracle allows to created 
indexes in Ascending or descending order what you have to do is to 
specify the ASC or DESC after the column name. The default is ASC.


Best of luck,

-Ari Kaplan
Independent Oracle DBA Consultant

<-> For 160+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->

Back to Ari Kaplan's Home Page ndex.htm"> Back to Ari Kaplan's Home Page