we are using create table command for creating a table
my question is what is the default path of that table.
can i save that table in my own path.
if so then what is the syntax
what is the extension of of that table
hiral amit patel
Last Activity: Aug 19 '09, 10:44 AM
Joined: Jul 16 '09
Location:
-
where table is stored in oracle
-
I want to search the names whose intial starts from a to c
with your answer i can find only those names which starts from a or b -
check constraint
Hi amit
I m using oracle 8iLeave a comment:
-
between operator in oracle
when i am searching the names in range with following query
select * from salesman where name between 'a%' and 'c%';
it does not display the names starting from c; it displays the name which starts from a and b. why it is so? -
check constraint
i have tried that one but not able to create such table.
the following error is being generated
create table t12(dat date,constraint my_cons check(dat between '01-jan-2009' and '31-jan-2009'))
*
ERROR at line 1:
ORA-02436: date or system variable wrongly specified in CHECK constraintLeave a comment:
No activity results to display
Leave a comment: