-
system is slow
I am working on Windows XP Professional. My system is slow, means when I open any application it takes much time to open. Why?
hpss007
- Mar 10th, 2008
Thier are millions of reasons that your system is slowone is the drives may not be properly fragmentdthe other one is that some of your system files may b corruptthe great one is that u might be under the virus attack.,..........
-
Retrieve deleted table or form
How to retrieve a deleted table or any D2K based form?
-
Copy structure of a table
How can I copy the stucture of a table to a text file.
krishnaindia2007
- Jun 21st, 2008
You can copy the definition of objects to text file using dmbs_metadata package.This is the query to copy emp table definition to text file.spool textfilenameselect dbms_metadata.get_ddl('TABLE','EMP','CMSJAN') from dual;spool off;
-
Database Instance
How can I copy a table from one database instance to another database instance
-
get records into a block with scroll bar
How can I get more than one record from a table appeared in a block with scroll bar.
Sudhir Sorout
- Feb 4th, 2008
follow these steps:..........1. go to the property of that block2. choose Records->number of records displayed=10(now 10 records come at a time in block u can give any no of record here...
-
Copying table with constraints and data
How to copy a table with constraints and data to another table.
krishnaindia2007
- Jun 21st, 2008
Using the following query you may copy table structure and data but you can't copy constraints.Create table emp_copy as select * from emp;
ugly1
- Jan 25th, 2008
below shown query will copy table with constraints and data into new table. here table_copy is the new table and old_table is the table whose data and constraints are to be copied.create table table_copy as (select * from old_table)
