Answer / m haribaskar

Create Database Link <<LinkName>>
Connect to <<USerName>>
Idenitfied By <<PAssword>>
Using <<DATABASE_NAME>>

Answer / gaurav gupta

CREATE PUBLIC DATABASE LINK remote
USING 'remote';

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

How would you convert date into julian date format?

0 Answers  

---

Explain mutating table error.

0 Answers  

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

---

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

---

why not null constraint showing its constraint type as 'c'

1 Answers  

---

What is a sql trace file?

0 Answers  

---

How to pronounce postgresql?

0 Answers  

---

using comand prompt how can import table data and table space with example

2 Answers  

---

What does the hierarchical profiler does?

0 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---