GeekInterview.com
Series: Subject: Topic:
Question: 28 of 165

Can you truncate a table in a procedure in Oracle Forms? The table name is passed into the procedure.

Asked by: Amritha | Member Since Jun-2006 | Asked on: Jun 22nd, 2006

View all questions by Amritha

Showing Answers 1 - 3 of 3 Answers
kaye

Answered On : Aug 22nd, 2006

yes.use execute immediate.

  
Login to rate this answer.
rampratap409

Answered On : Dec 4th, 2006

View all questions by rampratap409   View all answers by rampratap409

yes

create procedure truncatetable(tname in varchar2) is

sqlstr varchar2(100);

begin

sqlstr := 'truncate table '||tname;

execute immediate  sqlstr;

end;

  
Login to rate this answer.
Shital Mistry

Answered On : Aug 11th, 2012

It is not directly supported in forms, but FORMS_DDL built in can be used to TRUNCATE the table.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Backup and Recovery

Basics

Concepts and Architecture

D2K

Data Access

Database Administration

Database security

Database Tuning

Distributed Processing

General

Memory Management

Oracle Forms 4.0

PL/SQL

Programmatic Constructs

RMAN Interview Questions

Scenarios

SQL

SQL Plus

System Architecture

Interview Coaching

What is the role of a mechanical engineer in the Software Industry?

What are my options when I do not get a job after graduation?

Tell me about a skill you recently acquired or improved.

What do you think about continuous learning?

Does a problem make you a better person?

Do you seek advice from others when you have a question?

Has there been a time when you were presented a problem and solved it?

How do you handle difficult situations?

How do you approach a problem?

How do you deal and overcome major challenges?

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe