Perl / Sed script SegÃtsÃ©g

sabyasm · #1 (**permalink**) 06-04-2008

Hi All,

Arra szÃ¼ksÃ©g van-e az Oracle Inster parancsfÃ¡jlokat egy excel tÃ¡blÃ¡zat a kÃ¶vetkezÅ‘:

IdÃ©zet:

SRVC_ROLE_SPECIFICATION
REC 1
SRVC_ROLE_SPEC_ID : 1
SRVC_ROLE_TYPE : HeAdmin
MIN_NUMBER_ALLOWED : 1
MAX_NUMBER_ALLOWED : 1
IDENTIFIER_NAME_SPACE : NULL
CREDENTIAL_TYPE : ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID : 1
REC 2
SRVC_ROLE_SPEC_ID: 2
SRVC_ROLE_TYPE: emailLite
MIN_NUMBER_ALLOWED: 1
MAX_NUMBER_ALLOWED: 10
IDENTIFIER_NAME_SPACE:
CREDENTIAL_TYPE: ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID: 1
REC 3
SRVC_ROLE_SPEC_ID: 3
SRVC_ROLE_TYPE: hostopiaAdmin
MIN_NUMBER_ALLOWED: 1
MAX_NUMBER_ALLOWED: 1
IDENTIFIER_NAME_SPACE:
CREDENTIAL_TYPE: ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID: 2
REC 4
SRVC_ROLE_SPEC_ID: 4
SRVC_ROLE_TYPE: voicemailAdmin
MIN_NUMBER_ALLOWED: 1
MAX_NUMBER_ALLOWED: 1
IDENTIFIER_NAME_SPACE:?
CREDENTIAL_TYPE: ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID: 2
REC 5
SRVC_ROLE_SPEC_ID: 5
SRVC_ROLE_TYPE: voicemailUser
MIN_NUMBER_ALLOWED: 1
MAX_NUMBER_ALLOWED: NULL (ez azt jelzi, nincs felsÅ‘ hatÃ¡r)
IDENTIFIER_NAME_SPACE:
CREDENTIAL_TYPE: ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID: 2

Ezt Ãºgy kell tÃ¡volÃtani a kÃ¶vetkezÅ‘k:

IdÃ©zet:

REC 1: INSERT INTO SRVC_ROLE_SPECIFICATION (SRVC_ROLE_SPEC_ID, SRVC_ROLE_TYPE, MIN_NUMBER_ALLOWED, MIN_NUMBER_ALLOWED, MAX_NUMBER_ALLOWED, IDENTIFIER_NAME_SPACE, CREDENTIAL_TYPE, SRVC_SPECIFICATION_ID)
VALUES
(1, "heAdmin ', 1,1," NULL "," ENCRYPTEDTEXT', 1);

REC 2: ..

REC 1, REC 2 stb az elvÃ¡lasztÃ³jeleket a feljegyzÃ©sek ...

Ãšgy gondolom, a gyÃ¶ngy szkript Ãrt e ... tÃºl hasznos lesz nagy segÃtsÃ©g.

Thanks in Advance
Sabya

TÃ¶bb, UNIX Ã©s Linux fÃ³rum tÃ©mÃ¡k Ã–n Ã¡ltal talÃ¡lt Hasznos
SzÃ¡l	Thread Starter	FÃ³rum	VÃ¡laszok	UtolsÃ³ hozzÃ¡szÃ³lÃ¡s
FelhÃvÃ¡s a perl script a perl script	new2ss	Shell programozÃ¡s Ã©s Scripting	6	05-24-2009 06:03 PM
FelvÃ©tel PERL szkript a Unix shell script	ganapati	A UNIX a dummies KÃ©rdÃ©sek Ã©s vÃ¡laszok	1	04-29-2008 01:18 PM
Itt a dokumentum automatizÃ¡lÃ¡sÃ¡ra Perl script felhÃvÃ¡s script	hogger84	Shell programozÃ¡s Ã©s Scripting	3	10-22-2007 11:15 AM
MÃ³dosÃt Perl script dolgozni txt - Permissions script	joangopan	Shell programozÃ¡s Ã©s Scripting	1	09-13-2007 12:38 AM
Perl: Futtassa perl szkriptet az aktuÃ¡lis folyamat	vino	Shell programozÃ¡s Ã©s Scripting	10	12-09-2005 10:45 AM

TÃ©ma eszkÃ¶zÃ¶k	KeresÃ©s a tÃ©ma
Show NyomtathatÃ³ verziÃ³ KÃ¼ldÃ©s e-mailben	KeresÃ©s a tÃ©ma: RÃ©szletes keresÃ©s
MegjelenÃtÃ©si mÃ³dok	Rate this thread
VÃ¡ltÃ¡s Linear Mode Switch to Hybrid Mode Threaded Mode	Rate this thread:


	Powered by