How To Find Table For Script
Aug 19, 2010i have table like TWRCHAIN_WS_SUM. it is regularly updated by another object like procedure, function. how can i find which object is updating the particular table across the database.
View 4 Replies
ADVERTISEMENT
How To Find Table Fragmentation
Jul 22, 2011A query to find the table fragmentation.
View 1 Replies View RelatedUnable To Find A Table?
Mar 22, 2011why am i getting this?
SQL> SELECT TABLE_NAME,owner from dba_TABLES where TABLE_NAME in ('BSNL_ACCOUNT_DATA','BSNL_SERVICE_DATA','BSNL_PKG_DETAILS');
TABLE_NAME OWNER
------------------------------ ------------------------------
BSNL_ACCOUNT_DATA BPREAD
BSNL_SERVICE_DATA BPREAD
but the table exists
SQL> select count(*) from BPREAD.BSNL_PKG_DETAILS;
COUNT(*)
----------
3704
SQL> select TABLE_NAME,owner from dba_TABLES where TABLE_NAME='BSNL_PKG_DETAILS';
no rows selected
why is it showing no rows even if the table exists
Find Out Row Count From Each Table?
May 6, 2009I have written a script to get count of each tables of a schema.
DECLARE CURSOR c1 IS
select distinct table_name from all_tab_columns where OWNER='PLAY';
countrows NUMBER;
[Code].....
Find Out Row Count From Each Table
Mar 31, 2009SQL> select count(*) from tab;
COUNT(*)
----------
63
I need to find out how many rows in each table.I've tried with cursor.
SQL & PL/SQL :: How To Find Table That Contains Certain Column
Nov 9, 2011To find out column in which table it is located.
View 1 Replies View RelatedSQL & PL/SQL :: How To Find Table And Column Name
May 14, 2013With Data in a table, is it possible to find out the table name and column name? Means i know the account number (data) of the table and with this data i want to find out column name and table name.
View 3 Replies View RelatedSQL & PL/SQL :: Find Constraint Name Of A Table
Dec 24, 2010I want to know constraint name of a particular table if it exists.Here are the queries that i tried to find the constraint name of a particular table but the results were 'no rows selected'.
Queries:
select constraint_name from user_cons_columns where table_name='x';
select constraint_name from user_constraints where table_name='x';
SQL & PL/SQL :: How To Find Which Table Is Last Updated
Apr 11, 2012I want to know that How to find which table got last updated and how to find last DDL and DML operation obtained in which table? here I know the table name
SQL> SELECT LAST_DDL_TIME FROM DBA_OBJECTS WHERE OBJECT_NAME='PREM';
LAST_DDL_
---------
20-MAR-12
SQL> TRUNCATE TABLE PREM;
Table truncated.
SQL> SELECT LAST_DDL_TIME FROM DBA_OBJECTS WHERE OBJECT_NAME='PREM';
LAST_DDL_
---------
10-APR-12
Note: With out enable the auditing I want to know that .
SQL & PL/SQL :: Find Out Duplicate Name From Table?
Oct 28, 2010i have a employee table .i want to find out duplicate name from this table.so i write following query
select empname from employee
having count(empname) >1
group by empname
i find the result but problem is how i can find out the same name if it have any space like ramkumar ram kumar both are same but above query did not.give this data. how i can solve it
SQL & PL/SQL :: How To Find Out Wrong Value From Table
Jan 13, 2011I've written the code (see below) and after run I get an error:
ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
I don't know how to find out the wrong value from table. How to find it out?
DECLARE
TYPE rowids IS TABLE OF ROWID;
r1 rowids;
type t_varchar is table of varchar2(50);
n1 t_varchar ;
cursor c1 is select e.rowid rid,msisdn_displayed
from the_table
where contract_id is not null;
BEGIN
OPEN c1;
[code].........
PL/SQL :: How To Find Max Date From A Table
Mar 2, 2013I have two table in the database. I want to find the maximum routine date for a case_id when the lock_date is between 20 jan to 29 jan 2012 .
But I am not getting actual output (Output routine_date should be "28-jan-2012" but I m getting "31-jan-2012")
Master
case_id lock_date
101 23-jan-2012
101 24-jan-2012
102 27-jan-2012
102 29-jan-2012
101 30-jan-2012
101 29-jan-2012
Routine (for routine work)
case_id routine_date
101 23-jan-2012
103 28-jan-2012
102 21-jan-2012
102 29-jan-2012
101 21-jan-2012
101 28-jan-2012
101 31-jan-2012
select m.case_id, r.routine_date from master m, routine r,
(select case_id, max(routine_date) from routine group by case_id) rr
where m.case_id=r.case_id
and m.case_id=rr.case_id
and r.routine_date=rr.routine_date
Find Special DML On A Table
Apr 12, 2013i'm just trying to find out DML Statements, that where executed on a special table at a defined time. By googeling i just found a statement to find out the last DML, that was executed on a table or something else. But i want to look into the past. How can i do this?
View 16 Replies View RelatedPL/SQL :: How To Find Sequence For A Table
May 14, 2013I've got plenty of sequences. How can I identify that what are the sequences acting on a table?
View 8 Replies View RelatedHow To Find Last Inserted Record In A Table
Oct 5, 2010I have a table where there is no sequence maintained and there is no time stamp column to track the inserted record.How do I find the latest inserted record in the table.
View 5 Replies View RelatedFind DDL Statement Executed On A Table?
May 19, 2011I want to know the DDL statements executed on a table. Example:
i have a table test1 with structure as below: test1 (aa number, bb varchar2(10))
After some period of time, one DDL statement to alter the column is issued.
alter table test1 modify (bb varchar2(30));
so new table structure is: test1(aa number, bb varchar2(30))
Basically i would like to find these 2 DDL statements executed on this table - test1, so that i compare which column get modified and what modification done.
Is this information stored in any data dictionary table?
note - audit, flashback option not enabled in this database.
What SQL Command To Find Index Of A Table
May 14, 20071) how to find a primary key of a table in oracle, for example if I want to drop a index in table , how do I find what is the primary key in a table so that I can issue that command.
P/s: I don't have OEM installed so I must use SQL command
Example of dropping the index
ALTER TABLE table_name
drop CONSTRAINT constraint_name;
For example:
ALTER TABLE supplier
drop CONSTRAINT supplier_pk;
SQL & PL/SQL :: Find Out Column Value In All Table In Whole Database
May 19, 2010I need the column name and table name which is having the particular value in the whole database.
E.g. :We have 'Scott' value in emp table emp_name column. and we have lot of tables. here we need emp_name and emp as emp table is having scott value in emP_name column.
SQL & PL/SQL :: Find Out Base Table Of Synonym?
Jun 10, 2011How to find out the base table of a synonym?
View 3 Replies View RelatedSQL & PL/SQL :: Find Out Table Name Based On Column Name
Jul 28, 2011i need an sql query or procedure to find out table name based on the column name..
View 4 Replies View RelatedSQL & PL/SQL :: Query To Find Relevant Table Name
Jan 16, 2013i need a SQL query which should return me relevant table names. i.e. if there is table 'EMP' , then query should give table names with below result:
EMP
EMP_1
EMP_2
EMP_3
EMP_4
i.e. All tables which is starting with EMP (No Hardcoding of table, It should be dynamic way).I know we can achieve through SELECT * FROM USER_ OBJECTS WHERE OBJECT_NAME LIKE 'EMP%'. But here object_name i will passing dynamically.
SQL & PL/SQL :: How To Find Column In Which Table It Is Located
Dec 1, 2011How to find out the required column from user tables using query ?
View 6 Replies View RelatedSQL & PL/SQL :: Find Biggest Age Number In Table?
Mar 2, 2010i want a simple query to find out for example the highest age in the table.
View 9 Replies View RelatedSQL & PL/SQL :: How To Find Who Created The Table In Oracle
Feb 8, 2011somebody has created the table , who had created the table Note: not required the schema name,
View 4 Replies View RelatedHow To Find Which Table Inserted Most Recently
Sep 21, 2013I am using an Oracle Forms application. When you click a check-box in the form and save it,a record is inserted to a log table, they say. The DB schema has over 1000 tables and over50 log tables. Is there way using the data dictionaly to find out which table was inserted tomost recently? I don't have access to the Forms code. My goal is to find out the table that the Form inserted the log entry to.
View 7 Replies View RelatedPL/SQL :: How To Find Which Sequence Name Used In A Table - Redux
Sep 9, 2013Beginning with 12c, there is now a way to associate a sequence with a table. It's a new feature called an Identity column.
create table t
(some_id number generated as identity --< creates a system generated sequence
,name varchar2(30)
);
insert into t (name) values ('Smith');
insert into t (name) values ('Jones');
[code]....
PL/SQL :: Find Previous Value From Oracle Table
Jun 4, 2013I have a stat table that got info like login_date,user_id etc.For a specific user, i have a requirement based on the no of days difference between the current login date and last login date.
For example, Tom logged in on June 4th 2013. His previous login was May 31. So no_of_days_difference is 5 days.How to programmatically get this for each user inside a pl-sql sub block.
PL/SQL :: How To Find Source Code Of The Table
Sep 4, 2013i have a existing table called table_1 to did some changes to it, but i need to do a source search to find where all in the code that we reference this code to ensure that there is not a variable declaration that sets this to a specific number. how do i do a source search. i alter a existing column (overbook_max) to number(2) tonumber (3)
View 8 Replies View RelatedPL/SQL :: Query To Find Table And Column Name By Using Value
Sep 3, 2013I google to find the Table Name and Column Name by having a value(Number/String). And my where clauses are
where owner NOT IN ('SYS','SYSTEM') and data_type IN ('CHAR','VARCHAR2','NUMBER')
My query as follows
select a.owner, c.column_name, c.data_type, c.owner, c.table_namefrom dba_objects a, all_tab_cols c where a.owner NOT IN ('SYS','SYSTEM') and where c.owner NOT IN ('SYS','SYSTEM') and where c.data_type IN ('CHAR','VARCHAR2')order by a.owner
PL/SQL :: Employee Table - Find Characters
Sep 24, 2013In the Employee table i want to display having 4 characters of Emplo_name ,that name's 3rd character must be 'R' How to get it .
View 9 Replies View Related