> 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
way.
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