Home » Other » General » What is alternet of cursor
icon5.gif  What is alternet of cursor [message #122332] Mon, 06 June 2005 00:11 Go to next message
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 Go to previous message
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

Previous Topic: connect oracle through vb
Next Topic: invalid sys object
Goto Forum:
  


Current Time: Thu Mar 28 07:14:53 CDT 2024