Sponsored Content
Top Forums Shell Programming and Scripting Truncate table $TABLE -- SQLPLUS Post 302898628 by IB_88 on Wednesday 23rd of April 2014 05:33:53 AM
Old 04-23-2014
Truncate table $TABLE -- SQLPLUS

I want to truncate a table using sqlplus where the table name is in shell variable:

I am using :
Code:
sqlplus -s / <<end
truncate table $TABLE
end

 

10 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

How to access Oracle table using sqlplus

Hi, I want to use sqlplus from server1 sqlplus usr1/pass1@dns1 and I want to connect to an Oracle database from a server2. Unfortunately the database was created on the server1 and on server2. So when I use the command just like that...it connects to the database from the server2. ... (2 Replies)
Discussion started by: AngelMady
2 Replies

2. UNIX for Dummies Questions & Answers

how to run cron job to truncate database table

hi i'm a bit stuck trying to find the correct syntax in order to run a cron job which just truncates all info from a single table in my database i have a main database - db1 and i have a table in that database - userips i wish to create a cron job that truncates or removes all the info... (9 Replies)
Discussion started by: wingchun22
9 Replies

3. Shell Programming and Scripting

Truncate table

Hi In unix able to connect to oracle database and create table ,when rerun ,if table exist ,truncate that table.Any idea how to do that a.sh ---- sqlplus -s datadmin/password <<EOF create table xx(col1 number, col2... ); exit; EOF I... (1 Reply)
Discussion started by: mohan705
1 Replies

4. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

5. Shell Programming and Scripting

calling sqlplus, read table return etc

I have korn shell scripts. I want to pass a variable to a script which will execute a a sql script to read a table that contains env. variables. I want to read and then somehow export at unix level variables example for every row selected from the table build export command line field1... (5 Replies)
Discussion started by: TimHortons
5 Replies

6. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

7. UNIX and Linux Applications

create table via stored procedure (passing the table name to it)

hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname' for example ... (6 Replies)
Discussion started by: rethink
6 Replies

8. UNIX for Dummies Questions & Answers

Creating a condensed table from a pre-existing table in putty

Hello, I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information. More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
Discussion started by: Deedee393
5 Replies

9. Shell Programming and Scripting

Build a table from a list by comparing existing table entries

I am new to this shell scripting.... I have a file which contains list of users. This files get updated when new user comes into the system. I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing... (3 Replies)
Discussion started by: dchavan1901
3 Replies

10. Web Development

Getting Rid of Annoying Bootstrap Table Borders and Wayward Table Lines

Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer: <script> $(function(){ $('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies
XtParseTranslationTable()												 XtParseTranslationTable()

Name
  XtParseTranslationTable - compile a translation table into its internal representation.

Synopsis
  XtTranslations XtParseTranslationTable(table)
	 String table;

Inputs
  table     Specifies the translation table to compile.

Returns
  The compiled form of table.

Description
  XtParseTranslationTable()  compiles  table  into its opaque internal representation of type XtTranslations.  This compiled form can then be
  set as the value of a widget's XtNtranslations resource, or merged with a widget's existing translation table with  XtAugmentTranslations()
  or XtOverrideTranslations().

  The syntax of the string representation of a translation table is documented in Appendix F.

  If  an  empty  translation table is required for any purpose, one can be obtained by calling XtParseTranslationTable() and passing an empty
  string.

Usage
  This function is generally only needed by application writers.  When writing a widget, you specify a default translation table as a string,
  which the Intrinsics automatically parse.

  You  only need to use this function when you want to set translation values from C code; translation tables specified in resource files are
  automatically compiled by a resource converter.

  It is also possible to set a translation table with the XtVaTypedArg feature of XtVaCreateWidget() and XtVaSetValues().  This allows you to
  specify the translation table in string form, and have the appropriate resource converter automatically invoked to compile it.

  The string table passed to XtParseTranslationTable can be freed after the call if there are no more explicit references to it.

See Also
  XtAugmentTranslations(1), XtOverrideTranslations(1), XtUninstallTranslations(1).

Xt - Translations and Actions												 XtParseTranslationTable()
All times are GMT -4. The time now is 03:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy