Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

What are different sql data types?

0 Answers  

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

Is sql port 1433 encrypted?

0 Answers  

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

---

What are tables and fields?

0 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

How can we debug in PL/SQL?

0 Answers  

---

what are set operators in sql? : Sql dba

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---

What is restrict in sql?

0 Answers  

---