Home » Other » Training & Certification » Miscellaneous basic questions (zillion threads merged)
Miscellaneous basic questions (zillion threads merged) [message #269421] Sat, 22 September 2007 03:51 Go to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
delete the rows in a table without using DELETE Statement?
Re: delete the rows in a table without using DELETE Statement? [message #269425 is a reply to message #269421] Sat, 22 September 2007 03:57 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
truncate table your_table_name

Truncate command delete all the data of the table. And the data can not be rollback. So be careful when u use truncate table command.

[Updated on: Sat, 22 September 2007 04:00]

Report message to a moderator

Re: delete the rows in a table without using DELETE Statement? [message #269427 is a reply to message #269421] Sat, 22 September 2007 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Other ways:
drop the table
drop the user
drop the tablespace
drop the database
drop the server
drop the site
drop the world
drop the universe

Regards
Michel
Re: delete the rows in a table without using DELETE Statement? [message #269429 is a reply to message #269425] Sat, 22 September 2007 04:02 Go to previous messageGo to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
delete the particular row in a table
without using DELETE statement.
Re: delete the rows in a table without using DELETE Statement? [message #269431 is a reply to message #269429] Sat, 22 September 2007 04:05 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
srikanthvijay8 wrote on Sat, 22 September 2007 04:02
delete the particular row in a table
without using DELETE statement.

Particulars row can not be deleted without delete.
Re: delete the rows in a table without using DELETE Statement? [message #269432 is a reply to message #269431] Sat, 22 September 2007 04:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use PC Tools and patch the blocks.

Regards
Michel
Re: delete the rows in a table without using DELETE Statement? [message #269444 is a reply to message #269429] Sat, 22 September 2007 06:16 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
srikanthvijay8 wrote on Sat, 22 September 2007 11:02
delete the particular row in a table
without using DELETE statement.

Do you want to delete the rows from your table or from your resultset (that is the set of row that your query returns).
Re: delete the rows in a table without using DELETE Statement? [message #269456 is a reply to message #269444] Sat, 22 September 2007 07:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I bet he does not want anything.
It is one this stupid interview question.
Stupid interview question does not need any answer, it is only a behaviour question. Whatever you answer the interviewer does not care, he just want to see how you act.

Regards
Michel
Miscellaneous basic questions (Merged a zillion threads [message #269501 is a reply to message #269421] Sun, 23 September 2007 00:46 Go to previous messageGo to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
while desinging a database.
create table emp
(
empno number not null,
sex char(1));
here for sex char(n) .
what is the maximum n value can you give?
Re: Is pragma exception_init is automatically raised? [message #269505 is a reply to message #269501] Sun, 23 September 2007 00:52 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Exception automatically raised but to handle your desired one, You have to declare at first.
Re: CHAR datatype [message #269507 is a reply to message #269501] Sun, 23 September 2007 00:54 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
2000 chars

read this
http://www.psoug.org/reference/datatypes.html
Re: CHAR datatype [message #269508 is a reply to message #269501] Sun, 23 September 2007 00:55 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

2000 bytes.
Exceptions [message #269509 is a reply to message #269501] Sun, 23 September 2007 00:56 Go to previous messageGo to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
inside pl/sql block update dml is used but it
a)updates tends to zero records
b) in update there is error
for a) and b) what are all the exceptions raised?
Re: Exceptions [message #269511 is a reply to message #269509] Sun, 23 September 2007 01:01 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Foe a and b) All exceptions has not named except a few. You have to name them by pragma explicitly.
Re: Function overloading [message #269512 is a reply to message #269501] Sun, 23 September 2007 01:04 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Please cease & desist spamming this forum.

Please read & follow posting guidelines in #1 STICKY post at top of this forum.
Re: To_char to_DAte [message #269515 is a reply to message #269501] Sun, 23 September 2007 01:06 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Are you incapable or unwilling to Read The Fine Manuals found at http://tahiti.oracle.com????????????
Re: Database Trigger VS System Trigger [message #269516 is a reply to message #269501] Sun, 23 September 2007 01:06 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
http://www.psoug.org/reference/system_trigger.html

http://www.psoug.org/reference/ddl_trigger.html
Re: How to insert multiple data from single query [message #269518 is a reply to message #269501] Sun, 23 September 2007 01:12 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
What is your problem man? You may not interested to reading. Please go to market and buy a printed book like "Oracle Complete Reference", Read it and you will know about all. You might prefer beg than self dependent.
Re: DBMS and RDBMs [message #269519 is a reply to message #269501] Sun, 23 September 2007 01:15 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Go on google.com you get thousands of reference.
Re: rowtype and record data type in oracle [message #269520 is a reply to message #269501] Sun, 23 September 2007 01:16 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Go on google.com you get thousands of reference.
Re: Which scenario do you triggers/functions in your projects [message #269521 is a reply to message #269501] Sun, 23 September 2007 01:16 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Go on google.com you get thousands of reference.
Re: Inside a view definition [message #269523 is a reply to message #269501] Sun, 23 September 2007 01:18 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Go on google.com you get thousands of reference.
Re: rowtype and record data type in oracle [message #269524 is a reply to message #269501] Sun, 23 September 2007 01:18 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Laughing
Re: Miscellaneous basic questions (Merged a zillion threads [message #269525 is a reply to message #269501] Sun, 23 September 2007 01:22 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Thanks moderator for merged all his basic questions
Laughing
Re: Exceptions [message #269527 is a reply to message #269511] Sun, 23 September 2007 01:27 Go to previous messageGo to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
I want to know which exception name is cached or
no exceptions occured only?
is Dup_val_on_index or no_data_found or any other.
Re: Miscellaneous basic questions (Merged a zillion threads [message #269528 is a reply to message #269501] Sun, 23 September 2007 01:29 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
REDUNDANCY is the best way to teach IDIOTS.
REDUNDANCY is the best way to teach IDIOTS.
REDUNDANCY is the best way to teach IDIOTS.
REDUNDANCY is the best way to teach IDIOTS.
REDUNDANCY is the best way to teach IDIOTS.

You are a real slow learner.
Get a clue & go AWAY.
Re: Exceptions [message #269530 is a reply to message #269527] Sun, 23 September 2007 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to know which exception name is cached

All of them.

Regards
Michel
Re: Exceptions [message #269603 is a reply to message #269530] Sun, 23 September 2007 15:53 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Sun, 23 September 2007 08:34
Quote:
I want to know which exception name is cached

All of them.

Regards
Michel


Wow, Michel,

Do you actually want to say that you understood that question???

Quote:
I want to know which exception name is cached or
no exceptions occured only?
is Dup_val_on_index or no_data_found or any other.
Re: Exceptions [message #269675 is a reply to message #269603] Mon, 24 September 2007 01:34 Go to previous message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Actually I stop to the first part changing "cached" to "catched" but maybe I'm wrong as after that I was lost. Wink

Regards
Michel
Previous Topic: Need Help Friends
Next Topic: referential integrity
Goto Forum:
  


Current Time: Wed Dec 07 06:34:05 CST 2016

Total time taken to generate the page: 0.11614 seconds