Interested to Buy Any Domain ? << Click Here >> for more details...
How many database objects (trigger, packages, sequence etc)
uses a
particular field in a given table.
For ex: I want to know how many database object uses the
ATTRIBUTE1 in
the PO_VENDORS table.
What query will give me the result showing the database
object
name(package, trigger etc),
field_name used (in this case ATTRIBUTE1) and table_name
(in this case
PO_VENDORS).
- 2 Answers
- 8890 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gaurav
select * from user_source where upper(text)
like '%PO_VENDORS%'
| Is This Answer Correct ? | 2 Yes | 1 No |
Explain some predefined exceptions.
Can a commit statement be executed as part of a trigger?
what are ddl statements in mysql? : Sql dba
Is left join and outer join same?
Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.
What is difference between sql and mysql?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What are the qualities of 2nf?
is it possible to pass an object or table to a procedure as an argument?
Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com
What are the sql aggregate functions?
I want to execute a piece of code before calling a procedure. How to achieve it?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
