OraFAQ Forum: Training & Certification » Miscellaneous basic questions (zillion threads merged)

Home » Other » Training & Certification » Miscellaneous basic questions (zillion threads merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Miscellaneous basic questions (zillion threads merged) [message #269421]

Sat, 22 September 2007 03:51

srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam

Junior Member

delete the rows in a table without using DELETE Statement?

Report message to a moderator

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

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

Michel Cadot
Messages: 68643
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

Report message to a moderator

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

srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam

Junior Member

delete the particular row in a table
without using DELETE statement.

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use PC Tools and patch the blocks.

Regards
Michel

Report message to a moderator

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

Frank
Messages: 7901
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).

Report message to a moderator

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

Michel Cadot
Messages: 68643
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

Report message to a moderator

Miscellaneous basic questions (Merged a zillion threads [message #269501 is a reply to message #269421]

Sun, 23 September 2007 00:46

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?

Report message to a moderator

Re: Is pragma exception_init is automatically raised? [message #269505 is a reply to message #269501]

Sun, 23 September 2007 00:52

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.

Report message to a moderator

Re: CHAR datatype [message #269507 is a reply to message #269501]

Sun, 23 September 2007 00:54

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

2000 chars

read this
http://www.psoug.org/reference/datatypes.html

Report message to a moderator

Re: CHAR datatype [message #269508 is a reply to message #269501]

Sun, 23 September 2007 00:55

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

2000 bytes.

Report message to a moderator

Exceptions [message #269509 is a reply to message #269501]

Sun, 23 September 2007 00:56

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?

Report message to a moderator

Re: Exceptions [message #269511 is a reply to message #269509]

Sun, 23 September 2007 01:01

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.

Report message to a moderator

Re: Function overloading [message #269512 is a reply to message #269501]

Sun, 23 September 2007 01:04

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: To_char to_DAte [message #269515 is a reply to message #269501]

Sun, 23 September 2007 01:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Are you incapable or unwilling to Read The Fine Manuals found at http://tahiti.oracle.com????????????

Report message to a moderator

Re: Database Trigger VS System Trigger [message #269516 is a reply to message #269501]

Sun, 23 September 2007 01:06

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

Report message to a moderator

Re: How to insert multiple data from single query [message #269518 is a reply to message #269501]

Sun, 23 September 2007 01:12

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.

Report message to a moderator

Re: DBMS and RDBMs [message #269519 is a reply to message #269501]

Sun, 23 September 2007 01:15

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

Go on google.com you get thousands of reference.

Report message to a moderator

Re: rowtype and record data type in oracle [message #269520 is a reply to message #269501]

Sun, 23 September 2007 01:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Go on google.com you get thousands of reference.

Report message to a moderator

Re: Which scenario do you triggers/functions in your projects [message #269521 is a reply to message #269501]

Sun, 23 September 2007 01:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Go on google.com you get thousands of reference.

Report message to a moderator

Re: Inside a view definition [message #269523 is a reply to message #269501]

Sun, 23 September 2007 01:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Go on google.com you get thousands of reference.

Report message to a moderator

Re: rowtype and record data type in oracle [message #269524 is a reply to message #269501]

Sun, 23 September 2007 01:18

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

Report message to a moderator

Re: Miscellaneous basic questions (Merged a zillion threads [message #269525 is a reply to message #269501]

Sun, 23 September 2007 01:22

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

Thanks moderator for merged all his basic questions
Laughing

Report message to a moderator

Re: Exceptions [message #269527 is a reply to message #269511]

Sun, 23 September 2007 01:27

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.

Report message to a moderator

Re: Miscellaneous basic questions (Merged a zillion threads [message #269528 is a reply to message #269501]

Sun, 23 September 2007 01:29

BlackSwan
Messages: 26766
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.

Report message to a moderator