Oracle: How to Prioritise Invalid Objects in a Schema

by

Try using this query to identify the approach to attack invalid objects in the schema   select referenced_name, count(referenced_name) cnt  from user_dependencies where referenced_name in (select distinct object_name                             from user_objects                            where status = ‘INVALID’) group by referenced_name order by cnt desc    This will list down the objects in descending order on which maximum no. of invalid objects … Read more

Adding sequence to a table

by

This TIP can be used to add a sequence in a column for a table The syntax for creating a sequence is  CREATE SEQUENCE sequence_name    MINVALUE value    MAXVALUE value    START WITH value    INCREMENT BY value    CACHE value; The steps are –create table with a column create table tickets3(s_no  integer); — create a sequence , Option 1CREATE … Read more

How to use the copy command in Oracle SQL

by

How to use the copy command in Oracle SQL Syntax: COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, …)]USING query where database has the following syntax: username[/password]@connect_identifier Copies data from a query to a table in a local or remote database. COPY supports the following datatypes:     … Read more

Difference between UNIX and LINUX

by

Most of you might have wondered what the difference between UNIX and Linux is. Here is some of the useful information.   UNIX Vs Linux.   Most common difference: UNIX is propriety system while Linux is an       Open Source system.   2.      Technical a)      In UNIX ‘Development’ is targeted toward specific audience and platform. … Read more