Oracle tutorial : Pseudo columns in Oracle PL SQL ( pseudocolumn )
oracle tutorial for beginners
rownum in oracle
This video will show you what is Pseudo columns in Oracle PL SQL.
Pseudo columns are likes ROWNUM, ROENUM, ROWID, NEXTVAL,SYSDTAE , USER etc.
Oracle tutorial : Pseudo columns in oracle
Oracle supports several special-purpose data elements that are not actually contained in a table, but are available for use in SQL statements.
Here is a partial list of pseudo-columns in Oracle
a)CURRVAL : When using Oracle SEQUENCE values, the pseudo-column CURRVAL returns the current value of
for example: schema.sequence_name.CURRVAL
b)NEXTVAL :When using Oracle SEQUENCE values, the pseudo-column NEXTVAL returns the next value of
the sequence and causes the sequence to increment by one.
for example: schema.sequence_name.NEXTVAL
c)ROWNUM:ROWNUM returns a number indicating the order in which a row was selected from a table.
d)ROWID: ROWID returns the rowid (binary address) of a row in a database table.
e)USER :This pseudo-column will always contain the Oracle username under which you are connected to the database.
f)SYSDATE:This pseudo-column will contain the current date and time.
This column is a standard Oracle DATE datatype.
The value represents the current time on the server not the client.
For more tutorial please visit #techquerypond
Marin Community Foundation and Asian Americans/Pacific Islanders in Philanthropy.
Overall, US-born Muslims make up the largest percentage at 34% of all Muslims in the Bay Area, followed by 14% born in Pakistan, 11% in Afghanistan, 10% in India, 3% in Egypt and 2% each in Iran, Jordan, Palestine and Yemen.
Silicon Valley Pakistani-American by the Numbers:
There are 35,000 Pakistani-born Muslims in San Francisco Bay Area, or 14% of the 250,000 Muslims who call the Bay Area home, according to the study. Bay Area Muslim community constitutes 3.5 percent of the area’s total population and is one of the highest concentrations of Muslims in the country.
As of 2013, South Asian Muslims, including Pakistanis, have the highest income levels, with nearly half (49%) of them having a household income above $100,000. In comparison, those groups with the lowest proportion of household incomes above $100,000 were Hispanic Muslims (15%), Afghans (10%), and African American Muslims (10%).
The Bay Area Muslim community is very diverse in terms of race and ethnicity:
South Asians (30%)
African Americans (9%)
Asian/Pacific Islanders (7%)
Based on the survey findings, the majority of Muslims live in the following three counties:
and Contra Costa (12%)
Thousands of Pakistan-born techies are working at Apple, Cisco, Google, Intel, Oracle and hundreds of other high-tech companies from small start-ups to large Fortune 500 corporations. Pakistani-Americans are contributing to what Erik Brynjolfsson and Andrew McAfee describe as "The Second Machine Age" in a recent book with the same title.