DESC <TABLE NAME>
EX : DESC EMPDETAILS
Type: Posts; User: nehrumosuru; Keyword(s):
DESC <TABLE NAME>
EX : DESC EMPDETAILS
Try this query select length(div_code)+length(name) as "size" from pay
Hi
Try this query
select greatest(10,15,20,30,) from dual
greatest value
-------------
30
Hi
Try this following query
create table <Newtablename > as select *from <Data table name >
where <field_name> is null
the above query copied only data structure from Data table name
The following commands used for adding new column and inserting values to the table.
1. For adding column to the table
ALTER TABLE emp
ADD ( EMP_NAME VARCHAR(30));
2. For inserting data...