I need to view the number of tables existing under one
particular Owner. Is it possible? If so, pl give the SQL
query for this?
No Answer is Posted For this Question
Be the First to Post Answer
How do you find the maximum value in a column in db2?
What is innodb buffer pool?
What's the maximum number of volumes that can be added to a STOGROUP?
Can you access the DB2 Directory table using SQL?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
Plan has the optimized access path in it. But is that optimized access path is attained or known
How to select the duplicate rows from a table?
Highlight all the advantages that are attached to a package.
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What is the format (internal layout) of ?TIMESTAMP??
What is the reason behind not using select * in embedded sql programs?