Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQL table and the PLSQL
table?
- 3 Answers
- 18454 Views
- Mastek, I also Faced
- E-Mail Answers
Answer Posted / shivakanth reddy
In case sql table we use PRIMARY KEY to avoid duplicates and
null values.
But in case of PL/SQL PRIMARY KEY is used as an index to
ann array for accessing rows.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How to run sql statements with oracle sql developer?
Is oracle sql free?
How to call shell script from pl sql procedure?
How to install oracle sql developer?
What are the different types of tables in sql?
what is the difference between truncate and delete statement? : Transact sql
Can we join tables without foreign key?
Can a foreign key have a different name?
What are sql ddl commands?
How to prepare for oracle pl sql certification?
How many tables can a sql database have?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what is collation? : Sql dba
What is trigger in pl sql with examples?
