Sql query to list rowcount for all table in schema

Some times we face problems that require to find no. of rows in all tables in schema .

Following are sql queries that list table name and their row count,

For Microsoft SQL Server:

SELECT distinct(t.name) AS table_name,i.rows
FROM sys.tables AS t
INNER JOIN sys.sysindexes AS i ON t.object_id = i.id
 

For Oracle

select table_name,num_rows counter
from dba_tables 
where owner = 'XXX'
order by table_name;

Jdeveloper : Tips and triks

Keyboard shortcut to Search for members in class source for JDeveloper 11g

Use the 'Ctrl+Shift+~ ' this will prompt fabulous structure window as bellow here u can search for fields & method in class.This widow also show method from your extended ones so you can get quick outline.

Keyboard shortcut to Search for words in JAVA class source for JDeveloper 11g

Use the 'Ctrl+E' this will prompt search window like bellow one ,what ever u keyin to this it will search in java source file . and to find next appearance of word u have to just press 'Ctrl+E' ,& u will find that word

Delete files from Jdeveloper or exclude files from the Jdeveloper project

If you want to delete files from your project make sure to use the ‘File-menu’ ‘Erase from disk’ instead of the delete icon in your application navigator। If you use this delete-icon this means an exclude-option is added to your project-properties so the files aren’t shown anymore, but they still exist.

Navigation between pages without validation-exceptions being thrown For Jdeveloper 10g

You want to be able to navigate away from a creation-page but the validation-exceptions are always triggered => use ‘immediate=true’ attribute on the command-link or the menutab-component so validation isn’t fired. You’re getting ‘current rowkey has been modified’-exceptions, set the enableTokenValidation-attribute on the pageDefinition-file to false so rowkey-validation isn’t performed

Oracle plsql building blocks

Pl/Sql is the programming language of ORACLE rdbms, This language is found to be useful by
DB programmers from the begining . It is prefered to write business logic in plsql for performance ressions . for Detail help regarding ORACLE inbuilt functions & packages visit following link


ORACLE inbuilt functions

http://www.psoug.org/reference/builtin_functions.html


here all functions are mentioned with link to detail explanation as per their datatype on which they affect.

ORACLE inbuilt packages

http://www.psoug.org/reference/builtin_packages.html

here some dbms package are mentioned with examples

New face of oracle ADF

JSF - a New View on Oracle ADF

In its efforts of trying to make J2EE simpler, Oracle has been providing J2EE best practices, such as design patterns and application infrastructure in a framework it calls ADF (Application Development Framework). What is really interesting with ADF is that it is platform independent, as it will run on any J2EE compliant application server. Better yet, it provides options for every J2EE layer and development life-cycle phase, and you can use anyone you like. You are not forced to use all or nothing.

Oracle ADF is based on the Model-View-Controller (MVC) design pattern. View layer, which provides the user interface of an application. The view layer uses various markup languages to render the user interface, and it can be web-based, client/server based, a wireless implementation, or even telnet based. The focus is specifically on JavaServer Faces (JSF). Faces, as it's also known, not only provides a view layer, but also a navigation capability, similar to that of Struts and what is called backend beans or managed beans, where you can put your business logic and the interaction with the data sources. With that alone you could start building applications, as Faces is an MVC framework in its own.