 What is alternet of cursor [message #122332] |
Mon, 06 June 2005 00:11  |
deshle
Messages: 23
Registered: June 2005
Location: Bangalore
|
Junior Member |
|
|
Answer these questions:
1. What is alternet of cursor?
2. How can we know the size of database?
3. Diffrence between procedure and function?
4. Difference beteen delete and truncate?
5. How to deploy package in oracle?
6. What is transaction?
Answer it urgently
|
|
|
|
| Re: What is alternet of cursor [message #122401 is a reply to message #122332] |
Mon, 06 June 2005 07:00  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
| deshle wrote on Mon, 06 June 2005 07:11 |
Answer these questions
|
Say please. How would you expect people to answer your question if you don't take time to write a proper question?
| deshle wrote on Mon, 06 June 2005 07:11 |
1. What is alternet of cursor?
|
I don't get it. Can you rephrase this.?
| deshle wrote on Mon, 06 June 2005 07:11 |
2. How can we know the size of database?
|
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:285415955510
| deshle wrote on Mon, 06 June 2005 07:11 |
3. Diffrence between procedure and function?
|
See your other post
| deshle wrote on Mon, 06 June 2005 07:11 |
4. Difference beteen delete and truncate?
|
Search the board like I did:
TRUNCATE is a DDL command, which implies an implicit commit.
- No rollback
- No explicit commit
- Changes are permanent
- No WHERE clause: that's not valid for DDL.
With TRUNCATE you reset the table's high watermark (the point up to where a table once has been filled). Oracle re-initialises this high watermark for the table, hence just 'forgets' the table's contents. No real physical delete takes place, the data location becomes available.
If there are dependent tables (through FKs), truncate will result in an error...
Search this site:http://asktom.oracle.com ( and bookmark it!!!).
| deshle wrote on Mon, 06 June 2005 07:11 |
6. What is transaction?
|
A Logical unit of work.
| deshle wrote on Mon, 06 June 2005 07:11 |
Answer it urgently
|
Please?
[EDIT: Minor typo]
MHE
[Updated on: Tue, 07 June 2005 04:25] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
