Muhammad Badarnee There is at least one (somewhat complicated) way in which this can be done in SPSS that I can think of. (Maybe somebody else knows an easier way.)
The partial correlation is equal to the zero-order correlation of regression residuals R1 and R2 obtained from two linear regressions (partialling out the third variable Z from the two variables X1 and X2 for which you wish to compute the partial correlation). You can save these residuals in SPSS by using the REGRESSION option twice (once to partial Z from X1 and once to partial Z from X2). You can then correlate the residuals R1 and R2 from those two regressions. This (also) gives you the partial correlation. To my knowledge, SPSS does not give confidence intervals for correlations directly. However, you can obtain them indirectly via the REGRESSION option (see below).
To obtain the confidence interval for the residual (=partial) correlation, you can run the correlation between the residuals "indirectly", that is, by again using the linear regression function, this time regressing one residual on the other, e.g., R1 on R2. The reason is that for a bivariate regression, the standardized regression coefficient BETA is equal to the Pearson product-moment correlation. In the case of regression residuals, BETA is equal to the partial correlation.
The REGRESSION option in SPSS allows you to print confidence intervals (CIs) for B (the unstandardized regression slope coefficient). If you z-standardize your residuals (or save standardized residuals to begin with) before running the regression, B will be equal to BETA (the partial correlation; see https://www.youtube.com/watch?v=-dSoWqDyT4E) so that you can obtain the CIs for the partial correlation that way.
I almost always agree with Christian Geiser's advice, and I frequently recommend his responses. But in this case, I disagree with the method described in the YouTube video he mentioned. Why? Because it yields CIs for rho that are symmetrical. The usual method for computing the CI for rho, on the other hand, yields a symmetrical CI only when the observed correlation = 0. Otherwise, the interval is asymmetrical--see the 3rd slide in the attached PDF. While it is true that the CORRELATIONS command in SPSS still has no option to show confidence intervals, there are other options, including the (Python) extension command STATS CORRELATIONS. One of the attached PDFs has instructions on how to find and install it. And sorry for disagreeing with you, Christian. ;-) HTH.