Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

How to select oracle sequence from different schema and

How to select oracle sequence from different Databases.

Explain with example

Question Posted / harikanth

Answer Posted / harikanth

How to select oracle sequence from different schema

ANS:
a. SCHEMANAME.SEQUENCENAME.CURRVAL.
b. SCHEMANAME.SEQUENCENAME.NEXTVAL

How to select oracle sequence from different Databases

ANS:

a. SCHEMANAME.SEQUENCENAME.CURRVAL@DBLINK
b. SCHEMANAME.SEQUENCENAME.NEXTVAL@DBLINIK

Thanks,
Hari

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Segment Advisor in Oracle?

1106

What is Undo Management Advisor in Oracle?

1099

What is oracle database client?

1034

How to define a cusotmer as a supplier in ORACLE R12

2232

How can we view last record added to a table?

1040

How to rename an index in oracle?

1118

What are set operators?

1087

What is the maximum limit on the number of columns in a table?

1089

How to test null values?

1112

How to create a new table by selecting rows from another table?

1102

Can select statements be used on views in oracle?

1027

How to convert a date to char in oracle? Give one example.

1069

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1351

Can multiple columns be used in group by in oracle?

990

What is the order of defining local variables and sub procedures/functions?

1061