fun-puzzle.blogspot.com

sadatdba.blogspot.com

My Work: DIfference between varchar and nvarchar in Oracle

http://sadatdba.blogspot.com/2009/03/difference-between-varchar-and-nvarchar.html

Monday, March 2, 2009. DIfference between varchar and nvarchar in Oracle. Varchar2(20 char) means you can store 20 characters - whereas varchar2(20) means you can store 20 bytes. the varchar2(20 char) might take 20, 40, 60, 80 or more bytes to hold a string. The maximum length of a varchar2 is still 4000 bytes so varchar2(4000 char) is "misleading" in that the field will max out at 4000 bytes - not 4000 characters. Subscribe to: Post Comments (Atom). Http:/ funny-cool-pictures.blogspot.com/.

sadatdba.blogspot.com

My Work: October 2008

http://sadatdba.blogspot.com/2008_10_01_archive.html

Wednesday, October 29, 2008. Performing Asynchronous AutoLog Publishing in CDC Oracle. Step 1 Source Database DBA: Prepare to copy redo log files from the source database:. Compatible = 10.1.0. Java pool size = 50000000. Log archive dest 1="location=/oracle/dbs mandatory reopen=5". Log archive dest 2 = "service=stagingdb arch optional noregister reopen=5. Template = /usr/oracle/dbs/arch1 %s %t %r.dbf". Log archive dest state 1 = enable. Log archive dest state 2 = enable. Compatible = 10.1.0. ALTER TABLE ...

sadatdba.blogspot.com

My Work: September 2008

http://sadatdba.blogspot.com/2008_09_01_archive.html

Wednesday, September 24, 2008. Dynamic SELECT Statement on Oracle 10G. Sql stmt VARCHAR2(255);. Type DynaCur IS REF CURSOR;. Select 'SELECT 1,b.* from (select rownum nrow,a.* from DBA USERS a where. Rownum=1) b' into sql stmt from dual;. OPEN c FOR sql stmt;. FETCH c into n;. Dbms output.put line(n);. Sunday, September 21, 2008. Estimate TEMP usage without running SQL in Oracle. My immediate answer was :. Login to database with the same user. Watch TempSpc column in execution plan. Drop table plan table.

sadatdba.blogspot.com

My Work: January 2009

http://sadatdba.blogspot.com/2009_01_01_archive.html

Monday, January 26, 2009. Select a random row in oracle database. When you run a select query everytime it will return the same rows. If you wanna make it different every time that is randomly, then you can use it,. SELECT col name  FROM. ORDER BY dbms random.value). WHERE rownum = 1;. Sunday, January 25, 2009. Nijhum Dip, How to go. Saturday, January 24, 2009. Nijhum Dip , The Real Beauty. Tuesday, January 13, 2009. Family Name and Given Name. Rest of the part of full name. Sunday, January 11, 2009.

sadatdba.blogspot.com

My Work: March 2009

http://sadatdba.blogspot.com/2009_03_01_archive.html

Tuesday, March 3, 2009. EXISTS is more faster than IN because EXISTS returns a Boolean value whereas IN returns a value. Monday, March 2, 2009. DIfference between varchar and nvarchar in Oracle. Subscribe to: Posts (Atom). Http:/ funny-cool-pictures.blogspot.com/. Http:/ funny-jokes-quotes.blogspot.com/. Http:/ fun-puzzle.blogspot.com/. View my complete profile. Picture Window template. Powered by Blogger.

sadatdba.blogspot.com

My Work: How to go Kuakata

http://sadatdba.blogspot.com/2009/02/how-to-go-kuakata.html

Monday, February 23, 2009. How to go Kuakata. You can go by Bus or Launch. Direct bus route from Dhaka to Kuakata. “Sakura” costs around 450 Taka (US $8.00). There are some other buses like Druti, Soudia etc. But You have to know the last destination clearly. Because some of the buses goes to khepupara and then you have to buy another ticket towards kollapara(kuakata) worth 30 taka per person. Subscribe to: Post Comments (Atom). Http:/ funny-cool-pictures.blogspot.com/. View my complete profile.

sadatdba.blogspot.com

My Work: November 2008

http://sadatdba.blogspot.com/2008_11_01_archive.html

Sunday, November 16, 2008. NUMERIC Datatype in ORACLE. A base type is the datatype from which a subtype is derived.For your convenience, PL/SQL predefines the following BINARY INTEGER subtypes:. Let you restrict an integer variable to non-negative values. Let you restrict an integer variable to positive values. Prevent the assigning of nulls to an integer variable. Prevent the assigning of nulls to an integer variable. Lets you restrict an integer variable to the values -1, 0, and 1. You use the PLS INTE...

sadatdba.blogspot.com

My Work: August 2008

http://sadatdba.blogspot.com/2008_08_01_archive.html

Sunday, August 31, 2008. Considerations about Multibyte Charactersets. Lets see an example of MultiByte character set,. SQL create table t 1 (col1 varchar2(1) ;. SQL create table t 2 (col1 varchar2(1 CHAR) ;. SQL insert into t 1 values ('é');. Insert into t 1 values ('é'). ERROR at line 1:. ORA-12899: value too large for column "MY UTF"."T 1"."COL1" (actual: 3,maximum: 1). SQL insert into t 2 values ('é');. Check the Database Characterset. Super Set List of Character Set. Saturday, August 30, 2008. FOR X...

sadatdba.blogspot.com

My Work: July 2008

http://sadatdba.blogspot.com/2008_07_01_archive.html

Thursday, July 31, 2008. Send an SMS from J2ME application. By using this code we can send SMS from J2ME application. Public class SMSSender implements Runnable {. Private String message;. Private String phoneNumber;. Private AmarMIDlet midlet;. Private MessageConnection smsconn = null;. Public SMSSender(AmarMIDlet midlet) {. Thismidlet = midlet;. Public void run() {. Open the message connection. Smsconn = (MessageConnection) Connector.open("sms:/ :50001");. Catch (Exception e) {. Thismessage = message;.

sadatdba.blogspot.com

My Work: IN versus EXIST

http://sadatdba.blogspot.com/2009/03/in-versus-exist.html

Tuesday, March 3, 2009. EXISTS is more faster than IN because EXISTS returns a Boolean value whereas IN returns a value. Subscribe to: Post Comments (Atom). Http:/ funny-cool-pictures.blogspot.com/. Http:/ funny-jokes-quotes.blogspot.com/. Http:/ fun-puzzle.blogspot.com/. View my complete profile. Picture Window template. Powered by Blogger.