User Littlefoot

4 votes

Restore Standard/Enterprise Dump to Express

answered Aug 15, 2018 at 16:42

3 votes

Accepted

ORA-01789: query block has incorrect number of result columns

answered Sep 10, 2020 at 11:13

3 votes

Remove third ordinate from string of 3 ordinates

answered May 20, 2022 at 20:32

3 votes

How can I compute the TOTAL of multiple COLUMNS from a PIVOT?

answered Feb 8 at 7:46

3 votes

How to export and Import entire oracle database using sqlplus on terminal linux machine?

answered May 11 at 5:45

2 votes

Name of SQL programming style where KEYWORDS | CRITERIA are justified to centering line

answered Mar 17 at 6:48

2 votes

Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?

answered Aug 29 at 7:52

2 votes

Regarding creating the index

answered Sep 11 at 6:01

2 votes

Accepted

What I learned about inserting data into a table using external tables, views, procedures, and how to write those procedures

answered Aug 18, 2020 at 5:16

2 votes

Accepted

Seperate value of a specific column with "," delimiter in Oracle using "Regular Expression"

answered Aug 29, 2020 at 13:59

2 votes

Creating a table with Rank ordering in Oracle

answered Dec 10, 2020 at 21:27

2 votes

Repeat row in the result based on the value of a column

answered Sep 15, 2018 at 11:15

2 votes

Accepted

How to display the exact query in the output section of a stored procedure when using 'Dynamic SQL' and 'Bind variables' in Oracle

answered Jul 25, 2020 at 19:42

2 votes

Accepted

How to automate CSV-exports of queries in PL/SQL Developer (Oracle)?

answered Nov 9, 2018 at 19:17

2 votes

Accepted

Custom return type of a function in Oracle PL SQl

answered Nov 12, 2018 at 16:53

1 vote

updating 1st 5 digit of a column value in sql

answered Aug 24, 2018 at 19:20

1 vote

Conditional Query selection on the basis of paarameters

answered Aug 28, 2018 at 19:59

1 vote

Accepted

How to create stored procedure that returns query result?

answered Dec 25, 2018 at 15:57

1 vote

Accepted

How to grant user to dbms_crypto ?? Oracle (User which created inside SYSTEM)

answered Mar 19, 2019 at 13:44

1 vote

Accepted

Facing error while executing function inside the package in PL/SQL

answered Jun 1, 2019 at 20:59

1 vote

How to use 'Bind Variable' with 'With clause' in a Dynamic query using PLSQL

answered Aug 2, 2020 at 12:04

1 vote

How to export user with tables and tablespace oracle

answered Sep 6, 2018 at 19:39

1 vote

Oracle database backup and restore options

answered Dec 13, 2019 at 7:12

1 vote

How could I fix this warning?

answered Sep 20, 2018 at 8:16

1 vote

Accepted

Generate hierarchical path

answered Sep 21, 2019 at 20:16

1 vote

Accepted

Trigger: Only raise error if related record was NOT created between now and last Sunday

answered Aug 29, 2020 at 20:40

1 vote

Joining two tables based on two Aggregate columns

answered Sep 25, 2020 at 21:23

1 vote

How to get all rows which created or updated for a specified day

answered Nov 22 at 13:07

1 vote

Accepted

How do I interpolate months in PLSQL

answered Nov 2, 2020 at 21:09

1 vote

Accepted

Add unique conditional constraint to exsiting table

answered Jan 15 at 8:49

Stack Exchange Network

69 Answers

Restore Standard/Enterprise Dump to Express

ORA-01789: query block has incorrect number of result columns

Remove third ordinate from string of 3 ordinates

How can I compute the TOTAL of multiple COLUMNS from a PIVOT?

How to export and Import entire oracle database using sqlplus on terminal linux machine?

Name of SQL programming style where KEYWORDS | CRITERIA are justified to centering line

Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?

Regarding creating the index

What I learned about inserting data into a table using external tables, views, procedures, and how to write those procedures

Seperate value of a specific column with "," delimiter in Oracle using "Regular Expression"

Creating a table with Rank ordering in Oracle

Repeat row in the result based on the value of a column

How to display the exact query in the output section of a stored procedure when using 'Dynamic SQL' and 'Bind variables' in Oracle

How to automate CSV-exports of queries in PL/SQL Developer (Oracle)?

Custom return type of a function in Oracle PL SQl

updating 1st 5 digit of a column value in sql

Conditional Query selection on the basis of paarameters

How to create stored procedure that returns query result?

How to grant user to dbms_crypto ?? Oracle (User which created inside SYSTEM)

Facing error while executing function inside the package in PL/SQL

How to use 'Bind Variable' with 'With clause' in a Dynamic query using PLSQL

How to export user with tables and tablespace oracle

Oracle database backup and restore options

How could I fix this warning?

Generate hierarchical path

Trigger: Only raise error if related record was NOT created between now and last Sunday

Joining two tables based on two Aggregate columns

How to get all rows which created or updated for a specified day

How do I interpolate months in PLSQL

Add unique conditional constraint to exsiting table