how to delete all the data from the table in sqlplus oracle

Posted by Nubkadiya on Stack Overflow See other posts from Stack Overflow or by Nubkadiya
Published on 2010-06-18T01:43:02Z Indexed on 2010/06/18 1:53 UTC
Read the original article Hit count: 422

Filed under:

oracle11g

|

sqlplus

i want to delete all the data rows in the table. but without dropping the table. delete statement has a where clause so i have to give one by one for each row. is there any other way of deleting the whole data rows in the table.

this is Oracle and using sqlplus

© Stack Overflow or respective owner

Related posts about oracle11g

???? Oracle11g ????????? No.2 - v$database.CURRENT_SCN

as seen on Oracle Blogs - Search for 'Oracle Blogs'
«????Oracle 11g ???????»???????????,?11.2.0.3.0?????: select current_scn from v$database union all select current_scn from v$database; ??????????SCN,??????11.2.0.1.0???????????SCN?????? ??,????11.2.0.1.0????,11.2.0.3.0????X$KCCDI(V$DATABASE?????,??CURRENT_SCN??)??,?????????SCN? … >>> More
Cognos 8.3 and Oracle11g

as seen on Server Fault - Search for 'Server Fault'
When i place ojdbc5.jar in the c8\webapps\p2pd\WEB-INF\lib directory... i receive the error below. And yes the content store is on an oracle 11g RAC database. I am running Oracle11g Client. Cognos version is 8.3 SP4. [Content Manager database connection] 1. [ ERROR ] The database connection failed… >>> More
Cognos 8.3 and Oracle11g

as seen on Server Fault - Search for 'Server Fault'
When i place ojdbc5.jar in the c8\webapps\p2pd\WEB-INF\lib directory... i receive the error below. And yes the content store is on an oracle 11g RAC database. I am running Oracle11g Client. Cognos version is 8.3 SP4. [Content Manager database connection] 1. [ ERROR ] The database connection failed… >>> More
how to display databases in oracle11g using sqlplus

as seen on Stack Overflow - Search for 'Stack Overflow'
in mysql its show databases; but how to show the available databases in oracle. can someone help >>> More
INS-40719 error when Install Oracle RAC?

as seen on Server Fault - Search for 'Server Fault'
I'm tying to (learn how to) install Oracle RAC 11g on CentOS 6 all went OK so far but I get INS-40719 Error message regarding SCAN Name I do not have DNS server and I'm not going to try to use it on this setup I add this line to /etc/hosts 192.168.244.100 rac-cluster then used "rac-cluster" as… >>> More

Related posts about sqlplus

Starting SQLPlus in linux

as seen on Server Fault - Search for 'Server Fault'
How do you start sqlplus in linux? I know this is a service in windows. >>> More
SQLPlus - spooling to multiple files from PL/SQL blocks

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a query that returns a lot of data into a CSV file. So much, in fact, that Excel can't open it - there are too many rows. Is there a way to control spool to spool to a new file everytime 65000 rows have been processed? Ideally, I'd like to have my output in files named in sequence, such as… >>> More
Running pl/sql in Korn Shell(AIX)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a file to execute in Ksh written by someone. It has a set of commands to execute in sqlplus. It starts with, sqlplus -s $UP <<- END followed by a set of ddl commands such as create,drop,etc., When I execute the file in the shell, I get the error in the starting line quoted above… >>> More
Oracle SQLPlus: How to display the output of a sqlplus command without having to first issue the spo

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to display the output of a sqlplus command without having to first issue the spool off command? I am spooling the results of a sqlplus session to a file while at the same time tailing the file. The reason for this is that for table with very long rows the format is easier to look… >>> More
Broker vs. SQLPLUS to manage Data Guard configuration

as seen on Server Fault - Search for 'Server Fault'
Hi all, Can anyone tell me the link to the comparison between using SQLPLUS and Data Guard Broker to manage data guard configuration? Advantages and disadvantages of those two command line interfaces? Thanks, Sarith >>> More