04-29-2008
Help with perl scripting on strings
Hai,
I have strings as follows.
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0030166' (INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0029845' (INDEX (UNIQUE)
9 INDEX MODE: ANALYZED (RANGE SCAN) OF 'BR_RELATED_PARTY_DETAILS_IDX1' (INDEX)
5 INDEX MODE: ANALYZED (RANGE SCAN) OF 'IM_ASSET_HOLDING_IDX2' (INDEX)
I have to extract what is present inside the single Quotes ie, i have to extract only 'SYS_C0030166', 'SYS_C0029845', 'BR_RELATED_PARTY_DETAILS_IDX1', 'IM_ASSET_HOLDING_IDX2' . I am new to perl. How do I do this in perl?
Thanks in Advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
STORAGE_TYPE=$1
echo "########### SQL SESSION STARTED ###########"
VALUE=`sqlplus -S /nolog << THEEND
connect tcupro/tcupro_dev@bdd1optn
SET SERVEROUTPUT ON
DECLARE
V_STORAGE_TYPE varchar2(3);
V_ERR_MSG varchar2(255) ;
V_LOG_LEVEL varchar2(200);
BEGIN... (1 Reply)
Discussion started by: piscean_n
1 Replies
2. Shell Programming and Scripting
Hi,
I need sample code to compare the two files line by line which contains text strings and to print the difference in the third file.
Thanks in advance (1 Reply)
Discussion started by: sudhakaryadav
1 Replies
3. Shell Programming and Scripting
Hi All
I need help on how to handle utf8 strings (match, split etc.) in Perl. Thanks in advance. (2 Replies)
Discussion started by: my_Perl
2 Replies
4. Shell Programming and Scripting
Sample data:
revision001 | some text | some text
Comment: some comment
Brief: 1) brief
2) brief
------------------------------------------
revision002 | some text | some text
Brief: 1) brief
2) brief
FIX: some fix
------------------------------------------
revision003 | some... (8 Replies)
Discussion started by: inotech
8 Replies
5. Shell Programming and Scripting
Hi
How to call a shell scripting through a Perl scripting? Actually I need some value from Shell scripting and passes in the Perl scripting. So how can i do this? (2 Replies)
Discussion started by: anupdas
2 Replies
6. What is on Your Mind?
Hi all,
I would like to start developping some good scripting skills. Do you think it would be best to start with shell scripting or Perl? I already got a fundation, really basics, in perl. but I am wondering what would be best to be good at first.
Can you please help me determine which one to... (14 Replies)
Discussion started by: Pouchie1
14 Replies
7. Shell Programming and Scripting
/Path/snowbird9/nrfCompMgrRave1230100920.log.gz:09/20/2010 06:14:51 ERROR Error Message.
/Path/snowbird6/nrfCompMgrRave1220100920.log.gz:09/20/2010 06:14:51 ERROR Error Message.
/Path/snowbird14/nrfCompMgrRave920100920.log.gz:09/20/2010 06:14:51 ERROR Error Message.... (0 Replies)
Discussion started by: Shirisha
0 Replies
8. What is on Your Mind?
Gents,
I have been working in a Solaris/Unix environment for about 9 months. I took some linux classses online before getting the job. But, I am not very good at scripting. I want to learn how to script. Do you think that I should start with Shell scripting or Perl? I wanted to continue with... (2 Replies)
Discussion started by: Pouchie1
2 Replies
9. Web Development
i am going to study any one of the scripting languages mentioned above(shell 0r perl scripting) . Which is having more scope for a fresher? (1 Reply)
Discussion started by: Anna Hussie
1 Replies
10. Shell Programming and Scripting
Hi evrybody
For those who are bored I suggest exercise for tail :)
There is "csv" string:
A,B,C,D,E,G
Desired output:
| (A) A | (A,B) B | (A,B,C) C | (A,B,C,D) D | (A,B,C,D,E) E | G
There are no whitespace characters at the beginning and end of the line. (7 Replies)
Discussion started by: nezabudka
7 Replies
LEARN ABOUT CENTOS
alter_index
ALTER
INDEX(7) PostgreSQL 9.2.7 Documentation ALTER INDEX(7)
NAME
ALTER_INDEX - change the definition of an index
SYNOPSIS
ALTER INDEX [ IF EXISTS ] name RENAME TO new_name
ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name
ALTER INDEX [ IF EXISTS ] name SET ( storage_parameter = value [, ... ] )
ALTER INDEX [ IF EXISTS ] name RESET ( storage_parameter [, ... ] )
DESCRIPTION
ALTER INDEX changes the definition of an existing index. There are several subforms:
IF EXISTS
Do not throw an error if the index does not exist. A notice is issued in this case.
RENAME
The RENAME form changes the name of the index. There is no effect on the stored data.
SET TABLESPACE
This form changes the index's tablespace to the specified tablespace and moves the data file(s) associated with the index to the new
tablespace. See also CREATE TABLESPACE (CREATE_TABLESPACE(7)).
SET ( storage_parameter = value [, ... ] )
This form changes one or more index-method-specific storage parameters for the index. See CREATE INDEX (CREATE_INDEX(7)) for details on
the available parameters. Note that the index contents will not be modified immediately by this command; depending on the parameter you
might need to rebuild the index with REINDEX(7) to get the desired effects.
RESET ( storage_parameter [, ... ] )
This form resets one or more index-method-specific storage parameters to their defaults. As with SET, a REINDEX might be needed to
update the index entirely.
PARAMETERS
name
The name (possibly schema-qualified) of an existing index to alter.
new_name
The new name for the index.
tablespace_name
The tablespace to which the index will be moved.
storage_parameter
The name of an index-method-specific storage parameter.
value
The new value for an index-method-specific storage parameter. This might be a number or a word depending on the parameter.
NOTES
These operations are also possible using ALTER TABLE (ALTER_TABLE(7)). ALTER INDEX is in fact just an alias for the forms of ALTER TABLE
that apply to indexes.
There was formerly an ALTER INDEX OWNER variant, but this is now ignored (with a warning). An index cannot have an owner different from its
table's owner. Changing the table's owner automatically changes the index as well.
Changing any part of a system catalog index is not permitted.
EXAMPLES
To rename an existing index:
ALTER INDEX distributors RENAME TO suppliers;
To move an index to a different tablespace:
ALTER INDEX distributors SET TABLESPACE fasttablespace;
To change an index's fill factor (assuming that the index method supports it):
ALTER INDEX distributors SET (fillfactor = 75);
REINDEX INDEX distributors;
COMPATIBILITY
ALTER INDEX is a PostgreSQL extension.
SEE ALSO
CREATE INDEX (CREATE_INDEX(7)), REINDEX(7)
PostgreSQL 9.2.7 2014-02-17 ALTER INDEX(7)