Sqlplus variable UNIX Post: 303004846

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

How to pass unix variable to SQLPLUS

hi fellows, can any body tell me how to pass unix variables to oracle code is... #! /bin/ksh echo ENTER DATE VALUE's read START_DATE END_DATE sqlplus xyx/abc@oracle select * from table1 where coloumn1 between $START_DATE and $END_DATE; is this is correct way........... Thanks in...

2. Shell Programming and Scripting

Using a variable in sqlplus

Hello, I'm trying to write a script that will loop a sql statement through an external list. Basically, the script enters a loop and runs the sql statement for each entry in the list file. Currently, the script will stop at a cursor where I can then manually enter the SQL statment. This is...

3. UNIX for Advanced & Expert Users

passing unix variable to sqlplus without a file name

Hi, I want to input unix variable to sqlplus.The following is working fine sqlplus username/password @dummy.sql param1 param2 << EOF create user $1 identified by $2; EOF But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that?? Thanks...

4. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Need to select count(*) from table to check for zero result in unix script

5. Shell Programming and Scripting

Passing the unix variable to sqlplus

Hi, I am writing a script which creates an external table using a shell script. My requirement is like this. Usage: . ./r.ksh <table_name> - this should create an external table. e.g . ./r.ksh abc - this should create an external table as abc_external. How do i achieve this? Please...

6. Shell Programming and Scripting

store sqlplus output in variable

hi how can i store sqlplus output to a variable in sh script (not bash) Thanks MM

7. Shell Programming and Scripting

awk with variable from sqlplus

Hi, I'm a it stuck on the below code where a variable is pulled from sqlplus and used in awk. It runs with no errors but still pulls back all records in the input file. It should pull the max reference from sql plus and then only print those records where the reference value in column 1 is...

8. Shell Programming and Scripting

How to print huge values in sqlplus variable in UNIX?

Hi, I ahve a unix code as below. sqlTxt=$* sqlReturn=`echo "set feedback off; set heading off; set term off; set verify off; set serveroutput on size unlimited set lin 1000; VARIABLE GV_return_val NUMBER; VARIABLE GV_script_error varchar2(4000); EXEC :GV_return_code := 0; EXEC...

9. Shell Programming and Scripting

Scirpt to fetch the variable from sqlplus

Hi Gurus, I am stuck with the step where i need to fetch the location & sales from the below procedure by taking it from table field using the for loop. any idea how this can be done in unix. From one column both the location and sales are taken out. create or replace procedure newyork...

10. Shell Programming and Scripting

Pass a VARIABLE to sqlplus script

Hi Team, I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows: #!/bin/bash export ORACLE_SID=plgc1 export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1 export...

LEARN ABOUT PHP

crack_check

CRACK_CHECK(3)								 1							    CRACK_CHECK(3)

crack_check - Performs an obscure check with the given password

SYNOPSIS

       bool crack_check (resource  $dictionary, string	$password)

DESCRIPTION

       bool crack_check NULL (string  $password, string  $username = "", string  $gecos = "", resource	$dictionary)

	Performs an obscure check with the given password on the specified dictionary. The alternative signature also takes into account the user-
       name and the GECOS information.

       Warning

	      This function is EXPERIMENTAL. The behaviour of this function, its name, and surrounding documentation may change without notice	in
	      a future release of PHP. This function should be used at your own risk.

PARAMETERS

	      o $dictionary
		- The crack lib dictionary. If not specified, the last opened dictionary is used.

	      o $password
		- The password to be checked.

	      o $username
		- The username of the account with the password.

	      o $gecos
		- The GECOS information associated with the user account.

RETURN VALUES

	Returns TRUE if $password is strong, or FALSE otherwise.

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       |  0.3	|						    |
       |	|						    |
       |	|  The $username, $gecos and $dictionary parameters |
       |	| were added to the alternative signature.	    |
       |	|						    |
       +--------+---------------------------------------------------+
PHP Documentation Group 													    CRACK_CHECK(3)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

How to pass unix variable to SQLPLUS

Discussion started by: chiru

2. Shell Programming and Scripting

Using a variable in sqlplus

Discussion started by: MadHatter

3. UNIX for Advanced & Expert Users

passing unix variable to sqlplus without a file name

Discussion started by: sakthi.abdullah

4. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Discussion started by: struggle