06-03-2008
Analytic functions in Pro*c
Hi All,
when I use the following analytic function in sql prompt, i am getting the result
count(emp_no) over (partition by emp_no )
/* select count(emp_no) over (partition by emp_no ) from temp */
but when i use the same analytic function in Pro*c i get the following error
Error at line 160, column 36 in file test.pc
count(emp_no) over (partition by emp_no)
...................................1
PCC-S-02201, Encountered the symbol "(" when expecting one of the following:
, into, from,
Error at line 0, column 0 in file test.pc
PCC-F-02102, Fatal error while doing C preprocessing
rm: sef_msel.c: No such file or directory
make: The error code from the last command is 2.
Can you advice me how to use analytic function in Pro*c?
Thanks...
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
this is the seventh problem i'm having with samba.
for some reason, i cannot logon to the domain.
i've created user accounts... and i was able to establish a connection between
the samba server (my PDC) and my workstations by logging in as "root."
however now when i try to logon it gives... (5 Replies)
Discussion started by: xyyz
5 Replies
2. Shell Programming and Scripting
Hi,
I have a function or script like this.
show()
{
echo "Hi"
} | tee -a log
show
This creates a logfile and prints Hi in it. Now when I try to do the same for sql like this:
show()
{
sqlplus -s scott/tiger<<!
select * from details;
!
} | tee -a log
show
Then it gives me a... (2 Replies)
Discussion started by: sendhilmani
2 Replies
3. Shell Programming and Scripting
Hi
my shell is tcsh
can I have functions in my shell scripting?
Is the below shell script correct.
Can I have two functions and call one of them as required.
----------
echo "functions"
f1
f1 ()
{ echo "hello" }
f2 () (1 Reply)
Discussion started by: amitrajvarma
1 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I am exploring with defining functions in my BASH shell scripts. However, I am bit confused about how to pass parameters to my functions. I was under the impression that you must do something like the following:
Define a function called "sample_function":
function sample_function {... (3 Replies)
Discussion started by: msb65
3 Replies
5. Shell Programming and Scripting
Hi, im making a little script but need some help
Code i have so far is
read -p 'Bot Nickname:' ecnick
read -p 'Bot Username:' ecusername
read -p 'Bot Realname:' ecrealname
read -p 'Your Email:' ecemail
echo ''
echo Your bots nickname is set to $ecnick
echo Your bots username is set to... (2 Replies)
Discussion started by: Gemster
2 Replies
6. Programming
Hi All,
Can any one help me.
I am calling in a function2 with string as parameter from function1, the function1 gives 3 values. how i get the 3 values from funciton2 to function1. i have to give a return or something.
thanks in advance. (2 Replies)
Discussion started by: uday.sena.m
2 Replies
7. Shell Programming and Scripting
I have 7 functions those need to be executed as command line inputs, I tried with below code it’s not executing function. If I run the ./script 2 then fun2 should execute , how to initiate that function I tried case and if else also, how to initiate function from command line
if
then... (8 Replies)
Discussion started by: saku
8 Replies
8. UNIX for Beginners Questions & Answers
Hello guys :)
I am new to using Unix and was hoping somebody could help me. Essentially, I am trying to clean out my database. For example, I have a directory filled with 100s of analytics and I want to know if they are used by any other analytics or if they are used by the front end user... (17 Replies)
Discussion started by: Michael37
17 Replies
HFORMAT(1) General Commands Manual HFORMAT(1)
NAME
hformat - create a new HFS filesystem and make it current
SYNOPSIS
hformat [-f] [-l label] destination-path [partition-no]
DESCRIPTION
hformat is used to write a new HFS filesystem to a volume. A UNIX pathname to the volume's destination must be specified. The destination
may be either a block device or a regular file, but it must already exist and be writable.
An optional label can be specified to name the volume. The name must be between 1-27 characters and cannot contain a colon (:). By default,
the volume will be named Untitled.
If the destination medium is partitioned, one partition must be selected to receive the filesystem. If there is only one HFS partition on
the medium, it will be selected by default. Otherwise, the desired partition number must be specified (as the ordinal nth HFS partition) on
the command-line. The size of the partition determines the size of the resulting volume.
Partition number 0 can be specified to format the entire medium as a single filesystem without a partition map, erasing any existing parti-
tion information. Since this will destroy all the partitions, the -f option must be specified to force this operation if the medium cur-
rently contains a partition map.
If the medium is not partitioned (or if partition 0 is specified), the size or capacity of the medium determines the size of the resulting
volume.
The new volume will be empty and will become "current" so subsequent commands will refer to it. The current working directory for the vol-
ume is set to the root of the volume.
EXAMPLES
% hformat /dev/fd0
If a floppy disk is available as /dev/fd0, this formats the disk as an HFS volume named Untitled. (N.B. The floppy must already
have received a low-level format by other means.)
% dd if=/dev/zero of=disk.hfs bs=1k count=800
% hformat -l "Test Disk" disk.hfs
This sequence creates an 800K HFS volume image in the file disk.hfs in the current directory, and names it Test Disk.
% hformat -l "Loma Prieta" /dev/sd2 1
If a SCSI disk is available as /dev/sd2, this initializes the first HFS partition on the disk (which must already exist) with a new
filesystem, naming the resulting volume Loma Prieta.
% hformat -f /dev/sd2 0
This causes the medium accessible as /dev/sd2 to be reformatted as a single HFS volume, ignoring and erasing any existing partition
information on the medium. The -f option must be specified if the medium is currently partitioned; otherwise the command will fail.
NOTES
This command does not create or alter partition maps, although it can erase them (as described above). Any partition number specified on
the command line must already exist.
The smallest volume size which can be formatted with hformat is 800K.
SEE ALSO
hfsutils(1), hmount(1)
FILES
$HOME/.hcwd
AUTHOR
Robert Leslie <rob@mars.org>
HFSUTILS
08-Nov-1997 HFORMAT(1)