Oracle like syntax required

8 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Syntax problem Oracle

Hi All, I have a syntax problem with a procedure in oracle. I am looking to just produce the number of rows from each table located in the HR schema nothing complex. This procedure works great up to dbms_output.put_line(tab_var); where it lists the names of each table in the user schema. My...

2. Solaris

Help Required to access files in Oracle T4-4 server

Hello, First i'm a newbie, so don't mind if i sound stupid. I am working on Oracle t4-4 server with SUN SOLARIS 5.10 installed. I can access server via serial port and net mgt port. But the problem is when i login to console it starts flooding with messages and i can't type anything. I know...

3. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL...

4. Shell Programming and Scripting

Help required for Oracle database shutdown script conversion from shell to perl

Please tell me how to convert below program from shell script to perl. Same commands need to use in shutdown, just need program help for startup. export ORACLE_BASE=/home/oracle1 lsnrctl start lndb1 sqlplus '/ as sysdba' startup;

5. Shell Programming and Scripting

ORACLE SQL: Basic help required in script

Hi, I am having the following codes which generates 24 files: declare begin for i in 0..23 loop EXECUTE IMMEDIATE 'create tablespace TSCGFCDR' ||to_char(sysdate,'DD')||'_'||to_char(i,'fm00')|| to_char(i+1,'fm00')||to_char(sysdate,'MONYY')||' DATAFILE '|| ...

6. Shell Programming and Scripting

Getting required fields from a test file in required fromat in unix

My data is something like shown below. date1 date2 aaa bbbb ccccc date3 date4 dddd eeeeeee ffffffffff ggggg hh I want the output like this date1date2 aaa eeeeee I serached in the forum but didn't find the exact matching solution. Please help.

7. Shell Programming and Scripting

Help required to parse Oracle imp show=y output to DDL Commands

Hi, I generated an Oracle schema DDL script file using the show=y option of the Oracle import utility but the file that it generates needs a little more formating before we can run this as simple DDL comands to generate the schema at Target using the script file.Here is the simplified output of...

8. Shell Programming and Scripting

What syntax is required so that result will start from a new line..

What syntax is required to start the result in a new line

LEARN ABOUT DEBIAN

nicovideo-dl

NICOVIDEO-DL(1) 					      General Commands Manual						   NICOVIDEO-DL(1)

NAME

       nicovideo-dl -- download a video file from www.nicovideo.jp

SYNOPSIS

       nicovideo-dl [options]  video_url

DESCRIPTION

       This manual page documents briefly the nicovideo-dl command.

       This manual page was written for the Debian distribution because the original program does not have a manual page.

OPTIONS

       These  programs	follow	the  usual  GNU  command  line	syntax, with long options starting with two dashes (`-').  A summary of options is
       included below.

       -h	    --help
		 print this help text and exit

       -u USERNAME	     --username=USERNAME
		 account username (e-mail address)

       -p PASSWORD	     --password=PASSWORD
		 account password

       -o FILE		 --output=FILE
		 output video file name

       -q	    --quiet
		 activates quiet mode

       -s	    --simulate
		 do not download video

       -t	    --title
		 use title in file name

       -l	    --literal
		 use literal title in file name

       -n	    --netrc
		 use .netrc authentication data

       -g	    --get-url
		 print final video URL only

       -2	    --title-too
		 used with -g, print title too

       -c	    --get-comment
		 download comment

       -x	    --raw-comment
		 save comment in raw xml

		 --comment-output=FILE
		 output comment file name

       -v	    --version
		 print program version and exit

SEE ALSO

       youtube-dl (1).

AUTHOR

       This manual page was written by paulliu grandpaul@gmail.com for the Debian system (but may be used by others).  Permission  is  granted	to
       copy, distribute and/or modify this document under the same terms as the license of the original software.

																   NICOVIDEO-DL(1)

UNIX for Dummies Questions & Answers